Finance | Project Operations, Human Resources, ...

Financial Reporting Currency Translation

(0) Share

Report

Posted on by MuhammadFaisal

329

Hello Experts,

Can anyone shed some light, how the Financial reporting translation works for the currency translation type "transaction date" in the Management reporter?

what I have tried to check this so far.

1- in the fixed asset type main account, I have attached the financial reporting exchange rate type which has the link to the currency conversion rates.

2- Attached the currency translation type "transaction date" with the same fixed asset main account.

3- Created a report in the management reporter

4- Tried the currency filter option to check the conversion.

It is not working for me. If I change the currency translation type to current, the system starts to translate the fixed asset account.

Please let me know if I am skipping any steps or processes.

Thanks and regards,

I have the same question (0)

All responses (6)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (1)

Report

The 'Transaction date' translation type uses the rate in effect on the transaction date. Do you have rates for the associated Exchange rate type populated? Fixed asset historical transaction dates can go pretty far back in time.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Muhammad Faisal,

You can find additional information on the handling of foreign currency amounts on MS docs here:

docs.microsoft.com/.../financial-reporting-currency-capability

Please have a look and let us know if this answers your questions.

Best regards,

Ludwig

Was this reply helpful? Yes No
MuhammadFaisal 329 on at

Like (0)

Report

Hello Frank,

Thank you for sharing the information. Actually, the transaction which I am trying to translate is posted with the exchange rate which was already defined on some previous date, not on the transaction date.

So what I did is I manually calculate the exchange rate for that transaction and entered it in the currency exchange rate screen. but still, the management reporter is not translating the entry.

Thanks and regards,

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Is your report defined at transaction level ?

Was this reply helpful? Yes No
MuhammadFaisal 329 on at

Like (0)

Report

Hello Ludwig,

I hope you are doing well. Thank you for sharing the link, I already go through this link.

Let me share with you some background of the case.

a fixed asset was sold and the system picked the conversion rate which was already defined in the system on some previous date.

And when I created the report in the management reporter, it was not translating that specific entry. so I dig down and found the article for which link you have shared.

After reading the article, what I did is, I manually calculated the exchange rate for that transaction and enter the rate in the conversion screen for that specific date.

After updating the rate, I have checked that transaction translation in the Management reporter but it did not work for me.

Just for your information, if change the reporting currency translation type to current instead of the Transaction date, the management reporter starts translating the transaction.

Please let me know if you want me to share some screenshots for it.

thanks and regards,

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

HI MuhammadFaisal,

Are you saying that the currency translation does not properly work if you select the 'transaction date' rate?

If this is the case, have a look at LCS first.

I found an hotfix for 10.0.19 and 10.0.20 that might help

Issue 588983 (Link: fix.lcs.dynamics.com/.../Details

Please check if you have this fix installed or run the very latest D365 version.

If you do then possibly a datamart reset might help especially if you subsequently updated / changed the exchange rate.

If this does not fix the issue as well, then I would recommend reaching out to the MS support for some additional assistance / screensharing.

Best regards,

Ludwig

Was this reply helpful? Yes No