Perform an online consolidation


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

An online consolidation is a consolidation where the subsidiary legal entities are in the same database as the consolidated legal entity.


We recommend that you use Management Reporter for Microsoft Dynamics ERP to combine the financial results for multiple legal entities in a consolidated format. Management Reporter lets you create consolidated financial reports across legal entities, use Microsoft Excel to import consolidation data from other sources, and translate amounts into any number of reporting currencies without having to run the consolidation process in Microsoft Dynamics AX.

For more information about how to consolidate transactions by using Management Reporter, see Financial consolidations and currency translation.

Follow these steps to do an online consolidation:

  1. Set up the consolidated legal entity and the accounts of the subsidiaries, which are the legal entities to be consolidated. For information, see Prepare a legal entity for use in the consolidation process and Set up a subsidiary legal entity for consolidation.

  2. Click General ledger > Periodic > Consolidate > Consolidate [Online].

  3. In the Consolidate [Online] form, prepare the transfer of subsidiary data to the consolidated legal entity.

  4. On the Criteria tab, specify the details of the consolidation. If the same criteria apply, you can transfer data from several subsidiaries to the consolidated legal entity by using a single operation.

  5. Click the Financial dimensions tab, and specify the financial dimension information to transfer from the transactions in the subsidiary accounts to the transactions in the consolidated legal entity.

  6. Click the Legal entities tab, and create a line for each subsidiary legal entity whose data is being imported into the consolidated legal entity. Specify the following information for each subsidiary:

    • If the consolidated legal entity owns part of a subsidiary, specify the share of the subsidiary accounts to import.

    • If you are consolidating subsidiaries that use foreign currencies, in the Account type of conversion differences field, specify whether consolidation exchange differences are posted to a balance account or to a profit and loss account in the consolidated legal entity.

  7. Click Batch to set up the consolidation to run as a batch job at the time that you prefer, or click OK to run the consolidation immediately.

    The transactions and balances that were specified for consolidation in the subsidiaries are added to the appropriate accounts in the consolidated legal entity.


If there are previous consolidation transactions for the same legal entity, date, and account range, the transactions will be removed and consolidated again.