Repro steps:
1. Go to Cash and Bank Management > Periodic
2. Foreign Currency Revaluation
3. Revalue a bank account in foreign currency.
4. System creates multiple entries for revaluation.
The current process does not have an option to select what financial dimensions should be posted at the time of processing bank foreign currency revaluation Which is available under AP and AR.
Ask from support:
Since in AR and AP module revaluation function feature is available
https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/foreign-currency-revaluation-accounts-payable-accounts-receivable#:~:text=Foreign%20currency%20revaluation%20can%20be,amounts%2C%20on%20a%20specified%20date.
Financial dimensions – The financial dimensions that are posted on the accounting entries of the foreign currency revaluation transactions:
• None – No financial dimensions are posted. If you have a required financial dimension in your account structure, the revaluation process is still run and creates accounting entries that have no financial dimensions. You will receive a warning message first, so that you can cancel the revaluation.
• Table – The financial dimensions of the customer account or vendor account are posted on the foreign currency revaluation transactions.
• Posting – The financial dimensions of the transaction that is being revalued are posted on the foreign currency revaluation transactions. By default, the financial dimensions from the original transaction's AR/AP ledger account will be used for the revaluation transaction's AR/AP main account, and the financial dimensions from the original transaction's expense/asset/revenue ledger account will be used for the revaluation transaction's unrealized gain/loss main account.
Comments
Agreed. We have no financial dimensions on the account structure applicable to the cash accounts however Microsoft Support has said the FCR looks to the default dimension on the voucher at the time of posting, so if the offset account had a financial dimension, it assumes that dimension for the cash subledger. There is also no report available to output these balances by financial dimension from the subledger (again, GL has no dimensions associated with the cash accounts so TB shows nothing). The documentation is also misleading as it states "If the account structure doesn’t include a business unit, the full amount is posted to the revaluation account" however it still posts as if dimensions are included.
Category: Cash and bank management
For the calculation of the bank revaluation, is necessary to consider the financial dimensions of the accounting structure.
Category: Cash and bank management
It would be great if revaluation functionality in Business Central to match the capability in Dynamics GP. Revaluation at the GL is a key requirement for many GP customers who want to move over to BC.
Category: Cash and bank management
Administrator on 10/12/2023 7:56:33 AM
This feature is delivered in 10.0.36.