Calculation of unrealized FX gain/loss during revaluation and consolidation

(0) Share

Report

Posted on by Community Member

Hi All,

I am working though an issue where our unrealized FX gain/loss account is a couple hunderd off from what we expected it to be, and I am trying to figure out why that is.

Does anyone know the calculation logic AX uses to determin the amount to post to the unrealized gain/loss account during revaluation?

Thank you,

Phil

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Phil,

Can you provide some more details? In which module did you run this revaluation? GL, Bank, Accounts payable or Accounts receivable?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

GL.

My understanding is that AX takes the difference between the FX rate on the transaction date and the average monthly rate and calculates from there, but I am not 100% sure.

-Phil

Was this reply helpful? Yes No
Suggested answer

Biju_John 601 on at

Like (0)

Report

Hi Philip,

For GL - The difference between the rate at transaction date and rate at the 'To date' in the foreign currency revaluation form multiplied by the amount in transaction currency for all transactions in foreign currency

For AP & AR - The difference between the rate at transaction date and rate at the 'Date of rate' in the foreign currency revaluation form multiplied by the 'unsettled' part in transaction currency for all transactions in foreign currency

In both cases, AX uses the rates from the 'default exchange rate type' attached to the ledger (General ledger | Setup | Ledger)

Regards

Biju John

Was this reply helpful? Yes No
nunomaia 25 Moderator on at

Like (0)

Report

The question raised by Andre (GL, Bank, consolidation, etc.) is important.

For example, if you are performing consolidation using Management Reporter, you can define to use average exchange rate.

That setting is setup in main account > Currency translation methods.

Other processes use Exchange Rate in Ledger

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Philip,

The answer from Biju is providing correct information about the process in AX. There is no average monthly rate used here. Are you referring to Management reporter like Nuno suggested?

Was this reply helpful? Yes No