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.