Consolidate (form) [AX 2012]

Updated: October 17, 2012

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.

The following tables provide descriptions for the controls in this form.

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.

NoteNote

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 
(On the Elimination tab)

Enter a brief description of the consolidation that you are working on. You can view this information in the Consolidations inquiry form.

NoteNote

This tab is not available in the Consolidate [Export to] form.

Elimination

Enter an elimination rule to generate elimination transactions during the consolidation process.

NoteNote

This tab is available only in the Consolidate [Online] form.

Currency translation

Enter information about currency exchange rates for the consolidation process.

NoteNote

This tab is not available in the Consolidate [Export to] form.

Button

Description

Batch

Set up and run the consolidation export or import as a batch job.

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:

  • Main account – The consolidation uses the default consolidation account for the main account that is selected in the Main accounts - chart of accounts: %1 form. If there is no default consolidation account, the main account is used.

  • Consolidation account group – The consolidation uses the consolidation account from the consolidation account group that is specified in the Consolidation account group field.

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:

  • None – No financial dimension information is transferred.

  • Dimension – The financial dimension on the subsidiary general ledger transaction is transferred.

  • Group dimension – The financial dimension value that is entered in the Group dimension field in the Financial dimension values form of the subsidiary is the financial dimension value that receives the subsidiary financial dimension amounts in the consolidated legal entity.

  • Company accounts – The identifier of the subsidiary legal entity is the financial dimension that is attached to subsidiary amounts in the consolidated legal entity. This option lets you identify the subsidiary origin of each transaction in the consolidated legal entity, but no other financial dimension information is transferred.

  • Account – The identifier of the ledger account in the subsidiary accounts is transferred to the consolidated account as a financial dimension.

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 
(On the Legal entities tab)

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.

NoteNote

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:

  • Profit and loss – Differences are posted to the consolidated main account that is specified for the Profit and loss account for consolidation differences posting type in the Accounts for automatic transactions form of the consolidated legal entity.

  • Balance – Differences are posted to the consolidated main account that is specified for the Balance account for consolidation differences posting type in the Accounts for automatic transactions form of the consolidated legal entity.

ImportantImportant

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.

NoteNote

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 
(On the Description tab)

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.

NoteNote

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 
(On the Currency translation tab)

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:

  • Consolidation date – The date of the consolidation.

  • Transaction date – The date of the transaction.

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).

Community Additions

Show: