0

Hello, i am working with sale orders with multiple currencies. exchange rate is not available so i created two fields for Item price, 'Item Price' and 'Item Price $'. i am importing either one to 'Sale Lines' by a formula as the code below. however, the formula displays the number format 'Sale Item'.'Sale Price' even if the choice was 'Sale Item'.'Sale Price $'. It seems that the formula always displays the first field format of the "if statement" even though it was not true. is there a way to solve this. thanks.

if 'Sale Orders'.Client.Country = "Local" then
'Sale Item'.'Sale Price'
else
'Sale Item'.'Sale Price $'
end

Reply

null

Content aside

  • 3 yrs agoLast active
  • 406Views