Currency Revaluation. From currency code. To currency code

(0) Share

Report

Posted on by lmai

2,442

Hi All,

For some reason, each currency revaluation run, AX only picks up two currency to generate gain/loss (screenshot 2).

If I leave the From currency code blank and To currency code EUR, AX picks up the remaining 2 to generate gain/loss.

If I leave the From currency code EUR To currency code USD, it also picks up the remaining 2 currency code to generate gain/loss.

It seems to me that regardless of what From currency code or To currency code is, AX takes the transaction currency and convert them to the accounting currency but only two transactions at a time.

Does anyone see different results?

Currency-Revau.-From.-To.png

2-currency.png1.png

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can't you leave the currency code fields simply blank to get a revaluation of all currencies that you use?

I usually never make use of the currency code restrictions. Why would you?

Best regards,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Kim,

What transaction do you currently have on this account and what is the expected outcome? Dynamics AX is evaluating the balance for the revaluation; not the individual transactions. A revaluation per currency is correct.

Do you have transactions in currencies between CHF and EUR which are skipped?

Was this reply helpful? Yes No
lmai 2,442 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre',

Yes, they all have transaction amounts and the gains/losses are much bigger than the rounding.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

If you know you have transactions, double check the posting period. Can you share those transactions?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Kim,

Can you elaborate what you mean by saying that the gains/losses are much bigger than the rounding?

Some illustrative screenprints would help.

Many thanks,

Ludwig

Was this reply helpful? Yes No
lmai 2,442 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I do a manual calculation outside of the system, in my spreadsheet, to make sure that when I run a currency revaluation, AX gives me the same gain/loss numbers. Mostly yes, AX gives me the same numbers.

To answer your question, my GL parameter rounding is .10. My gain/loss is $.06. AX does not have the $.06 in the Revaluation Report. This is what I meant, on the previous thread, that my gains/losses are higher than my rounding.

Was this reply helpful? Yes No
lmai 2,442 on at

Like (0)

Report
Copy link

Link copied!

I have looked into the GL parameter and the currency setting. I guess there are not many set up to look into. It wouldn't be something technical, right?

If you think of something, anything at all, please let me know. Thanks so much!

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Kim,

If you round values to 0.10 then your excel calculation will never match what you see in AX.

Yet, before performing those double checks assess whether this makes really sense because at the end of the day those revaluations are unrealized profits/loss and unless you talk about really large currency fluctuation amounts, I would not worry about penny's that are not material from a financial / auditing perspective.

About your second response:

Please double check your main accounts whether the revaluation parameter is set for all of the accounts that you use. You can find it in each account in your CoA.

Best regards,

Ludwig

Was this reply helpful? Yes No