Hi, question about exchange rates. Now the exchang...
# accounting
a
Hi, question about exchange rates. Now the exchange rates are always "today's rates". So if I enter now a transaction and change the transaction date and posting period to for example last day of October, the exchange rate is still the same (from today). Is it possible to change the logic so that the exchange rate would be transaction date's rate instead of the day when I enter the transaction? In many other softwares you can decide whether you want to use the transaction date's rate or today's rate.
l
Are you sure about that? On our NetSuite account, the default exchange rate is based on the transaction date not on today's date.
j
I'm seeing the same behaviour as Luis. When you change the transaction date, the UI will change the rate accordingly (assuming it has a rate, and you aren't dating in the future). You have to switch it back manually if for some reason you want it to persist with the "old" rate
a
For me it is not working that way. I tried to create two transactions, one of them dated for today and one for October 31th. The rates were exactly the same in both transactions. Tried also other dates and the rates were always the same.
l
Are you sure there are default exchange rates on those dates? How about workflows and scripts that might be changing that?
j
Have you set your currency rates to automatically update in Netsuite?
a
Hi. After some testing, we found out that the problem was in the reports instead of transactions. The consolidated report was always showing the same amount regardless of the date it was created. My colleague did something with the consolidated exchange rates and now it seems to be working, the amount is changing based on the date. Thanks for your advises!