Hello,
This question is about currency translation in D365 F&O. Here is the example from the scenario we have-:
Balance on an Account on CAD - 5000 as on 01/31/2020
I run the month end consolidation and D365 translates CAD 5000 to USD at what ever exchange rate I have specified ex - Closing, Average etc.
Now during Feb 2020, I post additional CAD 3000 to the same account.
I run the month end consolidation on 02/28/2020 - Now the system translates only difference of CAD 3000 to USD @ the month end rate or as selected by the user.
Our client is not agreeing to this logic and says that the system must translate the entire CAD 8000 at the FEB 2020 rate and not just CAD 3000 and this will result in a difference (CAD 5000 was translated and different rate earlier and my balance at the end of Feb 2020 is not correct)
We suggested them to run the revaluation in the Consolidation company which actually takes care of the difference, but they don't agree to this logic and claim that it is the wrong way of doing consolidation.
Any suggestions apart from using Management reporter?
Narasimha
