Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Travis Kurtz]

Can anyone tell me how the exchange rates are working in the report designer (Management Reporter)? 

Thanks

——————————
Travis Kurtz
Mansfield Oil Company
Gainesville GA
——————————

[Juan Sebastian Grijalba]

Hello,

I am not sure if this answers your questions but each main account is assigned a exchange rate and a type (Weighted, current, average etc…) manager reporter will use these settings to do the translations of transactions.  

there are several blogs that talk about this like this one

https://cloudblogs.microsoft.com/dynamics365/no-audience/2016/05/03/using-currency-translation-with-management-reporter-and-ax/

——————————
Juan Sebastian Grijalba
Berkowitz Pollack Brant
Miami
——————————
——————————————-

[Pamela McElhany]

Hello,

In the Chart of Accounts expand the Financial Reporting FastTab.  Under Currency Translation select Financial reporting exchange rate type (these must have exchange rates associated with them in the currency setup)

Average for P&L accounts
Closing for BS accounts

Select Currency translation type 

Weighted Average – P&L accounts (exchange rate *days in effect)/Days in period
Average – P&L accounts
Current – Balance Sheet accounts
Transaction date –  This method is used for fixed asset accounts.  The exchange rate used is the rate on the day the asset was acquired.  If a rate in not entered on that date, the rate used is the previously entered rate closest to the asset acquisition date. 

——————————
Pamela McElhany
Merit Solutions
Wheaton IL
——————————
——————————————-