Share
Report
27Hello,
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.
Categories:
All responses (
Answers (
