I have an integration to import sales orders. We have a unit price in the import file but only want it used when the price level price for that item is $0. I have a script for the field that looks like this
If DestinationFields("Unit Price")=0 Then
CurrentField = SourceFields("Sales-Order-Import.Unit Price")
ELSE
DestinationFields("Unit Price").SetToDefault
That doesn't work. When the price level price is 0, it still puts 0 on the sales order that is imported instead of using the unit price from the import. I also tried this
If DestinationFields("Unit Price").HasDefault = False Then
CurrentField = SourceFields("Sales-Order-Import.Unit Price")
ELSE
DestinationFields("Unit Price").SetToDefault
This worked if the price level price wasn't 0 but when it was 0 it would use 0. I think because 0 would still be considered a default value.
So, is there anyway to be able to do this?
Thanks
Jennifer
*This post is locked for comments