D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Report Designer - exchange rates.

  • 1.  Report Designer - exchange rates.

    SILVER CONTRIBUTOR
    Posted 20 days ago
    Can anyone tell me how the exchange rates are working in the report designer (Management Reporter)?

    Thanks

    ------------------------------
    Travis Kurtz
    Mansfield Oil Company
    Gainesville GA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Report Designer - exchange rates.

    SILVER CONTRIBUTOR
    Posted 20 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Report Designer - exchange rates.

    Posted 19 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role