Foreign Currency Revaluation for Bank Account in D365 FNOP
As per Accounting Requirement your Foreign Currency bank accounts should be revalued at current rate on closing date. Microsoft Dynamics 365 FNOP has this functionality for Ledger, Customers and Vendors, however there is no functionality available for bank account (Except for few regions). Now in absence of this functionality, how this revaluation can be done, most of the times a solution given is that to perform revaluation on ledge account of that Bank Account, however the only problem in this approach is your Ledger and Bank module will not be reconciled. Following is the work-around to achieve the result without having differences between Ledger and Cash & Bank Module. Using USMF company where Accounting Currency is USD and we have a Foreign Currency Bank account, which is following in our Example: Let us look at transactions of this Bank Account: Now let us export these transactions to calculate the total of transactions in EUR and in USD ...