D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Foreign Currency Consolidation

  • 1.  Foreign Currency Consolidation

    Posted Aug 29, 2019 07:08 PM
    Hi all

    I wanted to see how people handle this.

    We have a situation where we have 2 legal entities, one in Canada and one in US. We do consolidations in USD. We convert the Canadian company Balance Sheet accounts at the month end rate and the Profit and Loss accounts at the transaction date.

    This leads to an issue where the reports are out of balance because the two conversions aren't at the same rate. How do people handle this usually?


    Arush Kuthiala

    Arush Kuthiala
    Western Computer
    Toronto ON

  • 2.  RE: Foreign Currency Consolidation

    Posted Aug 30, 2019 04:42 AM
    Hi Arush

    In the GL setup there is a Posting section and in the posting section there is the 'Accounts for automatic transactions' where you setup things like the GL for penny differences and the year end result. One of the posting types is 'Balance account for consolidation differences' and it is the account code entered here that AX uses to balance the consolidation when different exchange rates are used for the P & L and Balance Sheet.

    David Scattergood
    P2 Dynamics Solutions Ltd


  • 3.  RE: Foreign Currency Consolidation

    Posted Aug 30, 2019 09:31 AM
      |   view attached
    Here is a document that will help.  Please see PDF pages 25-27 and method #2 is the more common way to report on currency gain/loss where in the Management Reporter row definition you have one row that grabs all balance sheet and income statement accounts (e,g, 1000:9999) which will net to the FX gain/loss after conversion which is all done in the GL (not the report even though you could have calc columns and rows and enter a rate in column formula).​​  Feel free to email if any specific questions as have done this lots over the last 25 years consulting on these MSFT and other reporting and budgeting products.  Have a nice holiday weekend ALL.

    Derek Krebs
    Sr Consultant
    MSX Group


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