Skip to main content

Financial Consolidations - Dynamics Ax 2009


10 Jun 2011

Financial Consolidations process:
3 steps to perform consolidation in Microsoft Dynamics Ax 2009.
I ) Consolidation company setup
II) Subsidiary company setup
III) Perform consolidation
I) Consolidation company setup:
Consolidation company creation: Consolidation designated company will not be available for any operational process except having consolidation entries posted in here.
Path: Dynamics Ax > Administration > Common Forms > Company accounts

GL Parameters setup:
Path: Dynamics Ax > General Ledger > Setup > Parameters > Ledger tab

Set value "Consolidated company accounts ' = True
System account:
Path: Dynamics Ax > General Ledger > Setup > Posting > System accounts
  • Balance account for consolidation differences
  • Profit & loss account for consolidation differences

Currency and Exchange Rates:
Path: Dynamics Ax > General Ledger > Setup > Exchange rates > Consolidate tab

The Exchange rates form displays an additional tab, Consolidate, when you select the consolidated company accounts field in the General ledger Parameters form. Closing rate field is used for balance sheet accounts and the value in the Average rate field is used for profit and loss accounts. Add exchange rates for each currency and specify 'Closing rate' & 'Average rate' for all currencies in this form (Overview tab will display all currencies, specify exchange rates & select each one of them and click Consolidate tab and consolidation rates).
Chart of Accounts:
Path: Dynamics Ax > General Ledger > Common Forms > Chart of accounts details

  • Closing (or) Average: Use Closing or Average options for utilizing rates specified in 'Consolidate tab' of the exchange rates form.
  • Historical : Use Historical to utilize exchange rates specified in the setup.
This process completes consolidation company setup for consolidations in Dynamics Ax 2009.

II) Subsidiary Company:
The subsidiary setup depends on chart of accounts setup, so following are possible alternative options.
Chart of Accounts Option 1: Identical Chart of Accounts
When this is the situation, the Consolidation account field is selected in the Consolidate Online form during the consolidation process to transfer the balances to the correct accounts.
Chart of Accounts Option 2: No Consolidated Chart of Accounts
In this scenario consolidated company does not have chart of accounts, here two alternatives to perform consolidation.
  • Enter a manual mapping on the Chart of Accounts in the subsidiary. This causes the mapped accounts to create automatically.
  • Do not enter any mapping. This causes the Chart of Accounts to be created in the consolidated company when data transfers from the subsidiary.
Note: This method is not appropriate for consolidation of a foreign currency subsidiary because conversion principles cannot be applied.
Chart of Accounts Option 3: Different Chart of Accounts
Having different chart of accounts in subsidiary & consolidated companies must be mapped to the consolidated company.
Map Chart of Accounts: (This process should be done for all subsidiary companies)
Path: Dynamics Ax > General Ledger > Common Forms > Chart of account details
Map Dimensions: (This process should be done for all subsidiary companies chart of accounts)
Path: Dynamics Ax > General Ledger > Common Forms > Dimensions

This completes subsidiary company setup and Consolidations. Please refer 'Financial Consolidations - Dynamics Ax 2009 (Part 2)' for next steps.
Note: This article has divided into 2 parts as first part describes about setup of consolidation & subsidiary companies and part 2 does contains 'Perform Consolidation' steps.

III) Perform a Consolidation:
Options to perform consolidation:
  • From the same database using the online option
  • From and, or to another database using the Import/Export option
Before you perform a consolidation at the close of a period, ensure that the period closing preparatory activities are performed, but do not close the subsidiary accounts until the consolidation is completed.
Consolidation, Online:
Path: Dynamics Ax > General Ledger > Periodic > Consolidate > Consolidation, Online

Dimension tab: Gives option to select none, dimension, group dimension, company accounts and account. Select 'Group dimension' to rollup dimension transactions to consolidation company dimension values (Group dimensions must be specified for all dimension values in all subsidiary companies for this option)
Companies tab:

Share: Indicate the percentage of the selected company accounts to be included in the consolidation. This is used if the consolidated company owns part of the subsidiary.
Note: Share field is not available or relevant on the consolidation, Export form
For the selected subsidiary company account - if the subsidiary company currency differs from that of the consolidated company - select the type of account that consolidation differences are posted to:
  • Profit & loss – Differences are posted to the consolidated company ledger account that is indicated for the Profit & loss account for consolidate Financial Consolidations - Dynamics Ax 2009 (Part 1)on differences value in the Posting type field on the System accounts form of the consolidated company.
  • Balance – Differences are posted to the consolidated company ledger account that is indicated for the Balance account for consolidation differences value in the Posting type field on the System accounts form of the consolidated company.
  • You must make an appropriate selection according to the accounting practice of the country/region of the consolidated company.
Eliminations tab:

Note: Elimination rules can be applied here.
Click button 'OK'
Then validate balances through General Ledger > Common Forms> Chart of account details (Select respective account and validate the balance of CEC & CEU companies, notice the balance in consolidation company).
Then validate balances through General Ledger > Common Forms> Chart of account details (Select respective account and validate the balance of CEC & CEU companies, notice the balance in consolidation company).
Questions & Answers:
Q1 : How do I start consolidation process?
Ans: Start with 'Financial Consolidations - Dynamics Ax 2009 (Part 1)' describes the setup part of consolidations following 'Financial Consolidations - Dynamics Ax 2009 (Part 2)' describes the consolidation execution process.
Q2: Our system does have setup of consolidation, but not sure how to start consolidation process?
Ans: Please follow the seteps below:
  • Validate existing consolidation setup in 'Consolidation company'
  • Validate/Identify subsidiary company setup
  • Perform consolidation
Q3: I've performed consolidation process but balances are not updated in consolidation company?
Ans: Please validate the consolidation & subsidiary company setup again and identify what option is considered for setup of subsidiary company.
Q4: We have consolidation differences in amounts 'Balance Sheet' & 'Profit & Loss' accounts, where do these balances update?
Ans: These balances can be found in the system accounts we have configured during consolidation company setup.
Q5: We understand the process but, performing consolidations process for the first time in Dynamics Ax, so need help?
Labels:

Popular posts from this blog

What does this mean: "The form datasource query object does not support changing its AllowCrossCompany property after the form has executed the query."?

I have made a form with datasources vendtable and vendtrans. Inside vendtable_ds.executequery() looks like this: QueryBuildDataSource queryBuildDatasource ,queryBDS_VendTrans_Invoice; ; queryBuildDatasource = this.query().dataSourceTable(tablenum(vendtable)); queryBDS_VendTrans_Invoice = this.query().dataSourceTable(tablenum(vendtrans)); if (curext() == "MASTERCOMP") { this.query().allowCrossCompany(true); } else { this.query().allowCrossCompany(false); } //FilterVendorName = stringedit control on form if (FilterVendorName.text()) { queryBuildDatasource.addRange(fieldNum(VendTable,Name)).value(strfmt("*%1*", FilterVendorName.text())); } else { queryBuildDatasource.clearRange(fieldNum(VendTable,Name)); } //FilterInvoiceNumber = stringedit control on form if (FilterInvoiceNumber.valueStr() == "") { queryBDS_VendTrans_Invoice.enabled(false); } else { queryBDS_VendTrans_Invoice.enabled(true); queryBDS_VendTrans_In...
Read more

Credit Note [Dynamics AX] using X++

This post will help to create credit note for a sales order based on the invent lot id. All the invoices raised for a particular sales line – Lot Id will be raised back as a credit note. Information on Credit Note: A credit note or credit memorandum (memo) is a commercial document issued by a seller to a buyer. The seller usually issues a Credit Memo for the same or lower amount than the invoice, and then repays the money to the buyer or sets it off against a balance due from other transactions Below Code will help to create credit note for all the invoices raised against the sales line -lot id. Please note: This code can be customized as per your requirements. This is just a template to help creating credit note using X++ code. Please test the code before use. static void SR_CreateCreditNote_Sales(Args _args) { // Coded by Sreenath Reddy CustInvoiceTrans custInvoiceTrans; Dialog dialog = new Dialog(“Create credit note – for sales.”); DialogField dfInv...
Read more