Finance | Project Operations, Human Resources, ...

Assistance with Bank Revaluation Posting and Dimension Split Explanation

(2) Share

Report

Posted on by ED-03100731-0

Hello everyone,

I’ve encountered a situation where the bank revaluation process has posted unusually large amounts to the general ledger vouchers. While the overall balance aligns correctly with the sum of individual bank transactions recalculated using the new exchange rate, I now need to identify the detailed breakdown of the amounts posted within the voucher and prepare an explanation for the customer.

Specifically, I’m seeking guidance on how best to interpret and explain the following statement from Microsoft Learn:

“The foreign currency revaluation transaction is also split across the dimensions that are found on the bank transactions. The split is based on the balance for each dimension. For example, the total bank balance is 10,000, but the balance for business unit 001 is 4,000, whereas the balance for business unit 002 is 6,000. In this case, 40 percent of the revaluation amount is posted to the revaluation account that has business unit 001, and 60 percent is posted to the revaluation account that has business unit 002. If the account structure doesn't include a business unit, the full amount is posted to the revaluation account.”

Could anyone advise whether there is a standard report or tool available that can help verify how these revaluation amounts were distributed across dimensions?

We did look into the new feature "Enhancements to bank foreign currency revaluation" but first need some explanation on the voucher origin detail.

Thank you in advance for your insights.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

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

Like (0)

Report

Assistance with Bank Revaluation Posting and Dimension Split Explanation

Hi,

While creating a revaluation, you can preview the outcome before posting. This will show you the transactions to be posted. If you need to know the source, you will need to print or export the bank account transactions and then check the balance in foreign and accounting currency per dimension. Then you can check which revaluation amount will be posted per dimension.

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 4,990 on at

Like (1)

Report

Assistance with Bank Revaluation Posting and Dimension Split Explanation

Hi,

Since you have already posted the revaluation, you might not be able to see the preview, if you have sandbox environment available with you, you can try with preview before posting, it will show the amounts with dimension combination.

As per MS document, before doing the revaluation, system will make the combination of Ledger account wise balances and then with new exchange rate, it will suggest the Exchange rate gain or loss.

In most of the clients, there are many other financial dimensions as well, so combination can get so large, so to avoid that situation, Microsoft introduced the new feature "Enhancements to bank foreign currency revaluation" , that gives the option to reset the existing foreign currency revaluation done till date.

It gives the option to define Financial dimension to be taken as All or None, if you choose All, it will have same behaviour which is happening now, in order to generate consolidated entries for bank currency revaluation, it gives you option to select "None".

As suggested by @Andre , to get the detailing about already posted transactions, you need to export the dimension wise data, OR you can also do some mathematics with current posted voucher, and trial balance generated on revaluation date.. you will get the simulation as shown in first screenshot.

In case of any further queries, please let us know..

Regards,

Neeraj Kumar

Was this reply helpful? Yes No