Dynamics Community Forum Thread Details

GL foreign currency revaluation not calculating deltas

Hello,

We are regularly running GL foreign currency revaluation on balance sheet accounts. During the previous year, everything was working as expected and as described in the documentation: Foreign currency revaluation for General ledger - Finance | Dynamics 365 | Microsoft Learn

Most notably, this part: In General ledger, the previous revaluation is not reversed. Instead, a transaction is created for the delta between the balance of the main account, including any previous revaluation amounts, and the new value based on the exchange rate for the Date of Rate.

However, starting from this year, GL foreign currency revaluation is NOT creating the transactions for the delta. Instead, it keeps posting the new value based on the exchange rate for the Date of Rate.

Example:

Posting date	Amount in CZK	Exchange rate CZK/EUR	Amount in EUR	Expected currency revaluation amount	Actual currency revaluation amount that is posted	Description
31.12.2022.	100	24,1910824415	4,13	-	-	Original transaction
31.1.2023.	100	23,8018659455	4,20	0,07	0,07	currency revaluation
28.2.2023.	100	23,6526394435	4,23	0,03	0,10	currency revaluation
31.3.2023.	100	23,5739913207	4,24	0,01	0,11	currency revaluation

When I run the simulation (Preview before posting), the /Last revalued amount/ that is showing is the original amount from the opening balance, not the last revalued amount.

Does anyone have any idea what could be causing this issue, or what to check? I cannot reproduce it in our test environment, but in the production environment it's consistently happening, across multiple companies, currencies, GL accounts, even different charts of accounts.

I have also reported this to Microsoft but I figured it wouldn't hurt to ask the community, as well.

Quick Links