The fact that D365 and NAV do not allow GL Accounts to be revalued is a major competitive weakness in the marketplace. Most other products have this functionality and I believe some of the European versions of NAV, for example the Swiss version, have this functionality but it has not been implemented in the NA version.

The main requirement here is to add the transaction currency to the General Ledger Entries table and then allow GL Accounts to be revalued at month end. We also need a flag on the Account Card to indicate whether that account should be revalued. Some accounts, for example fixed assets, should not be revalued although the accounting standards are changing all the time so we need the flexibility to either revalue or not revalues specific accounts.

The revaluation of the Additional Reporting Currency is not usefull since you can only revalue the ACF from the LCY or the LCY from the ACF, neither of whihc makes any sense from an accounting point of view. In reality both LCY and ACF should be revalued from the Transaction Amount which is not in the GL.

In general terms the balance sheet accounts should be revalued at the month end exchange rate and the income statement accounts should either be not revalued at all, assuming the correct exchange rates were in the system during the month, or they should be revalued at an average exchange rate for the month.