RE: Receivables/SOP transactions in multicurrency
Hi Babu,
Thanks for responding. It seems that I have not been clear in articulating what my problem is. I am fine with viewing my data in both originating and functional currency and that is not the issue.
What is happening is that balance in the originating currency is changed in the new period because there is a different exchange rate, while the corresponding functional amount remains the same.
Because these customers are maintained in the originating currency, I need to have their originating balance remain the same across periods, even if there is a different exchange rate in the new period, and the functional amount should be recalculated at the new rate.
an example of this is:
Transaction at 31/5/16 entered in originating$ = $556,000.00
Exch. Rate at 31/5/16 .00865 (multiply)
Balance in functional $ = $4809.4
Each subsequent period when viewing reports in multicurrency, the $4809.40 remain the same and is being re converted at the new rate, which gives a different originating amount. This is the opposite of what needs to be done as I need to have the originating amount remain at the figure it was entered in and the functional $ displayed based on the applicable exchange rate.
I hope I have stated the issue clearly and let me know if I need to provide more information.