1,351
Hi there,
I have a report that compares current period figures with last year's figures. The functional currency is EUR but the reporting currency is USD. The comparison is done in USD. MR is translating last year's figures at last year's exchange rate and this years at this years exchange rate. Is there a way of translating last year's figures at this year's exchange rate??
Many thanks!!
Hi Microsoft user,
Right.
The only option that I know would be adding a 'calculation column' that does this conversion for you.
This can be defined on a report by report basis but is at best a workaround.
Best regards,
Ludwig
Thanks Ludwig, that is a good idea but as you said we don't want all reports converted at the constant rate and changing the exchange rate type every time it's too time consuming. I would expect that you could define a fixed exchange rate in MR, out of AX but it seems that is not possible. Thanks again!
Hi Microsoft User,
Such Option is available in option for Main Accounts settings, Financial reporting> Currency Translation type.
There are options for Weighted Average, Average, Current & Transaction date.
MR will Fetch the exchange rate according to your setup here.
Warm Regards,
Zain
You want to eliminate the FX effect, right?
The only thing that we have available are the fields that we have available in the Chart of Account.
You could create a specific exchange rate type with a constant exchange rate.
If you link this exchange rate type to your main accounts, the management reporter should translate the data with this constant rate.
This should work ok but will influence all of your other reports as well. Best regards,
Ludwig
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 (