Consolidate (form)
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Click General ledger > Periodic > Consolidate > Consolidate [Export to].
–or–
Click General ledger > Periodic > Consolidate > Consolidate [Import from].
–or–
Click General ledger > Periodic > Consolidate > Consolidate [Online].
Use this form to import, export, or transfer data when you consolidate accounts for subsidiary legal entities into the accounts for a consolidated legal entity.
You can open the form in the various ways, depending on the purpose:
Consolidate [Export to] – Prepare to export data from a Microsoft Dynamics AX database to an external file that is sent or presented to the consolidated legal entity.
Consolidate [Import from] – Prepare to import data from an external file into the database of the consolidated legal entity.
Consolidate [Online] – Prepare to transfer data from one or more legal entities in a database to a consolidated legal entity in the same database.
You must create a legal entity that is used for consolidation before you can import data from other legal entities. The consolidated legal entity is not used for daily transactions. Instead, the consolidated legal entity is used to store consolidated data, inquiries, and reports, such as consolidated financial statements. You can enter entries in elimination journals, and run processes such as currency revaluation and opening transactions.
If you create accounts in the consolidated legal entity before you import subsidiary data, you can use the options for consolidation conversion to select the translation method that is required by the country/region of the consolidated legal entity.
You can also consolidate transactions for subsidiary legal entities into a consolidation legal entity and process an elimination rule to transfer the information from the consolidation legal entity to an elimination legal entity.
Tasks that use this form
Perform an online consolidation
Perform an export or import consolidation
Process elimination transactions using the Consolidation, Online form
Navigating the form
The following tables provide descriptions for the controls in this form.
Tabs
Tab |
Description |
---|---|
Criteria |
Set the criteria that govern this part of the consolidation process. For example, specify whether consolidation should involve realized, or current, transactions or budget register entries. You can limit the transactions that are consolidated by main account, period, and budget model. If no limits are set, all subsidiary accounts are consolidated. |
Financial dimensions |
Specify the dimension information that is transferred from transactions in subsidiary accounts to the transactions in the consolidated legal entity. Note This tab is not available in the Consolidate [Import from] form. |
Legal entities |
Create a line for each subsidiary legal entity that is included in the export, import, or online consolidation. In the Consolidate [Export to] and Consolidate [Import from] forms, indicate the name of the file and the folder where it is located. In the Consolidate [Import from] and Consolidate [Online] forms, indicate the accounts that are imported for each subsidiary. Indicate whether differences that occur due to the consolidation exchange are posted to a profit and loss account or to a balance account in the consolidated legal entity. By default, differences are posted to a profit and loss account. |
Description |
Enter a brief description of the consolidation that you are working on. You can view this information in the Consolidations inquiry form. Note This tab is not available in the Consolidate [Export to] form. |
Elimination |
Enter an elimination rule to generate elimination transactions during the consolidation process. Note This tab is available only in the Consolidate [Online] form. |
Currency translation |
Enter information about currency exchange rates for the consolidation process. Note This tab is not available in the Consolidate [Export to] form. |
Button
Button |
Description |
---|---|
Batch |
Set up and run the consolidation export or import as a batch job. |
Fields
Field |
Description |
---|---|
From: |
The first account, date, or budget model to include in the consolidation. |
To: |
The last account, date, or budget model to include in the consolidation. |
Use consolidation account: |
If this check box is selected, the transactions and balances are transferred to the specified main account in the consolidated legal entity. This main account is specified in the Consolidation account field in the Main accounts - chart of accounts: %1 form for each subsidiary main account. If this check box is cleared, the transactions and balances of each subsidiary main account are transferred to the account in the consolidated legal entity that has the same account number as the subsidiary account. If the corresponding main account does not exist in the consolidated legal entity, the main account is created automatically during consolidation. |
Select consolidation account from |
Select the consolidation account to use:
This field is available only when the Use consolidation account: field is selected. |
Consolidation account group |
Select the consolidation account group to use for the ledger consolidation. This field is available only when Consolidation account group is selected in the Select consolidation account from field. |
Include actual amounts |
Select this check box to include journal entries from the general ledger in the export or import of data. |
Include budget amounts |
Select this check box to include only budget register entries in the export or import of data. |
Perform foreign currency revaluation |
Select this check box to revalue the transactions in the subsidiary main accounts during consolidation. The exchange rate on the date that is specified in the To: field is used. |
Financial dimension |
The financial dimension in the consolidated legal entity that can receive data from subsidiary account records. The dimension in the consolidated legal entity contains the kind of data that is specified in the Specification field. |
Specification |
Select the kind of data that is transferred to the Financial dimension field on transactions in the consolidated legal entity when subsidiary account records are imported:
|
Segment order |
Enter the order of the financial dimensions in the destination legal entity. This field provides the display order of the ledger account in the consolidation legal entity. |
Source legal entity |
Select the legal entities that are used in the consolidation. |
Share |
Enter the percentage of the selected legal entity accounts to include in the consolidation. This field is used if the consolidated legal entity owns part of the subsidiary. Note This field is not available in the Consolidate [Export to] form. |
Account type of conversion differences |
If the currency of the selected subsidiary legal entity differs from the currency of the consolidated legal entity, select the type of account that consolidation differences are posted to:
Important Your selection must be appropriate for the accounting practices of the country/region of the consolidated legal entity. |
File name |
Specify the file name and path that are used to import or export comma-delimited files of the selected legal entities in a consolidation that is not centralized. Note This field is not available in the Consolidate [Online] form, because this form is used in consolidations where the subsidiary legal entities and the consolidated legal entity are in the same database. |
Description |
Enter a description of the consolidation. You can view this information in the Consolidations inquiry form. |
Proposal options |
Select Proposal only to create a proposal for elimination transactions. Select Post only to post elimination transactions. |
GL posting date |
Select the date on which to post the elimination journal to the general ledger. |
Release date |
To put the elimination journal on hold until a specified date, enter the date. You still can modify the elimination journal, and it can be posted on or after that date. If this field is blank, the elimination journal can be posted at any time. Note You can clear this field to remove the hold. |
Rule |
Select the elimination rule. |
Description |
The description for the selected elimination rule. |
Journal name |
The elimination journal that is used. |
Date last run |
The date that the elimination rule was last processed and distributions were successfully created. |
Reason code |
Select the reason for the elimination journal. Reasons that have an account type of Ledger are available in the list. For more information, see About financial reason codes. |
Reason comment |
Enter a reason description. If you select a reason before you enter a reason comment, the default comment that is set up for the reason is displayed. You can change the default comment. |
Source legal entity |
Select a legal entity to use the accounts in that legal entity for currency translation. |
Source accounting currency |
The code for the accounting currency of the source legal entity. This currency is converted to the accounting currency of the consolidation legal entity by using the exchange rate that is specified in the Exchange rate type field. |
From account |
Select the first main account to include in the currency translation. |
To account |
Select the last main account to include in the currency translation. |
Exchange rate type |
Select the type of currency exchange rate that is used during the consolidation process. |
Exchange rate date |
Select the date that is used to determine the exchange rate:
You cannot modify this field value if the accounting currencies for the source legal entity and the consolidation legal entity are the same. |
Exchange rate |
Enter the currency exchange rate that is used for conversion during the consolidation process. You cannot modify this field value if the accounting currencies for the source legal entity and the consolidation legal entity are the same, or if Transaction date is selected in the Exchange rate date field. |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).