2,947
I have multicurrency transaction.
Candadian $ = 52.65
Exchange Rate: 1.0531000
Rate Type: AVERAGE
Debit amount = 55.45
Question: How Debit amount is calculating? Please help.
*This post is locked for comments
H Bab - there is nothing inherently wrong with this transaction. It is doing exactly what it is being asked to do.
However - what result did you expect? Did you expect a converted value of $50.00 (49.995)? If so, then the translation method is set incorrectly - Divide instead of Multiply.
I this is the issue, then:
In the FX Rate set up window, you will need to delete all rates entered, then change the conversion method, then re-enter the rates. This will not update any transactions that have already been entered. Unposted transactions, you can change manually, posted ones, you might have to reverse and re-enter.
Or...you can set up a completely new FX table and start using that for future transactions.
Best regards,
Ian.
Hello Bab
Open the Exchange Table Maintenance and access the Exchange Table ID for Canadian Dollars to the functional currency setup in your company, which has been mapped to the rate type AVERAGE.
Check out what is the rate calculation method (multiply or divide) which determines how the functional equivalent for the Canadian$ amount which you have entered.
It looks like your Exchange Table is multiplying Canadian $ x 1.0531000 to arrive at your functional currency. Is this not correct? What is your functional currency?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (