In AX2012 the functionality to setup currency translation method on each main account worked ok.
I have tried to use the functionality in D365FO (different environments including a PEAP environment) but in Financial reports I don't get different reporting amounts for different main accounts with the same transactions using one of the four methods listed below.
Does someone know if there is a bug in Financial reports / D365FO or can someone verify that the functionality is still available and works as decribed and please also the required setup?
The functionality is described in docs:
https://docs.microsoft.com/en-us/dynamics365/finance/general-ledger/generating-consolidated-financial-statements
Currency translation methods
There are four options for calculating exchange rates in Financial reporting:
- Weighted average – This method is used most often for profit and loss accounts. It uses the following formula: (Exchange rate × Days in effect) ÷ Days in period
- Average – This method is an alternative method for profit and loss accounts. It uses the following formula: Total of exchange rates ÷ Number of exchange rates
- Current – This method is used most often for balance sheet accounts. The exchange rate that is used is the rate on or before the date of the report or column in Financial reporting.
- Transaction date – This method is used for fixed assets accounts. The exchange rate that is used is the rate on the day when the asset was acquired. If a rate isn't entered for that date, the previous rate that was entered closest to the asset acquisition date is used.
