Does any one know how NetSuite handles foreign currency? We have a saved search that pushes data to external system based on line last update date. This works fine for most of the transactions but has does go out of sync for foreign currency transactions. Our data matches for the foreign_currency_amounts but it seems like the amount gets updated some times without an update to the last update date. My hypothesis was that this happens when NetSuite updates the currency conversion rates. however, I found a transaction (if it matters it was a JE ) This had 4 lines. All the lines have same foreign currency amount. Same date, accounting_period_end_date, last modified date etc. but the amount field has 3 different values. ( 2 are identical amounts the other 2 are different) The difference is small but meaningful. Implies a 1.2% difference in the conversion rates

which rate provider you are using? have you checked your system notes for that JE, someone may have added the lines later o. This may caused currency reval to kick in on different dates - in theory

what you're describing on a journal entry doesn't sound very likely for pure foreign currency exchange. I can see it happening on an advanced intercompany journal (because there is a per-line exchange rate), but you would definitely expect to see some audit trail on the line if that was the case. Are you looking at the journal at translated rates? i.e. you are looking at its effect in a different currency to the base currency of the subsidiary? If that's the case, then yes you can have a maximum of three different rates on the transaction (one for current account types, one for average account types, one for historical account types). Depending how many times you run the period close process and the intervening transactions, those rates could change dynamically throughout the month The above assumes you're not using multi-book

I am very new to NetSuite so pardon my ignorance.