I have a question regarding currency conversions on PO's. For example: If a subsidiary has EUR as base currency and the PO is filled in USD then the total amount is displayed in USD (which is good). But then when a saved search is created to display the amount, that amount is always displayed in a different currency. There is a field amount(foreign currency) but that includes tax. I would need the foreign currency amount without tax. The strangest thing is that the conversion is wrong as well (if you calculate it yourself with Netsuite's exchange rates, it doesn't add up) -> even the conversion direction seems to be wrong (eg EUR amount is higher than USD amount even though USD is worth less). Do you know what might cause this?
Example:
- USD amount on PO: 50,820.00 (incl tax) and 42,000.00 (excl tax)
- conversion rate: 1 USD = 0.94640508 EUR
- EUR amount on PO (via saved search or list view): 54,159.80 (incl tax) and 44,760.17 (excl tax)