> > >

> > >

> > >

Use this form to import, export, or transfer data when you consolidate subsidiary company accounts into a consolidated company account.

You can open the form in three ways for different purposes:

  • - Prepare the export of data from an Microsoft Dynamics AX database to an external file that is sent or presented to the consolidated company.

  • - Prepare the import of data from an external file into the consolidated company database.

  • - Prepare the transfer of data from one or more companies in a database to a consolidated company in the same database.

You must create a company for consolidation purposes before you can import data from other companies. The consolidated company is not used for daily transactions; it is used for storage of consolidated data, inquiries, and reports, including consolidated financial statements.

If you create accounts in the consolidated company before you import subsidiary data, you can use the consolidation conversion options to select the translation method required by the country/region of the consolidated company. For more information, see About consolidation translation methods.

Or, you can enable the imported subsidiary data to create the ledger structure of the consolidated company. In this case, the consolidation uses the default consolidation conversion principle that appears when an account is created in the consolidated company. The default for this field is currently .

You also can consolidate subsidiary company's transactions into a consolidation company and process an elimination rule to transfer the information from the consolidation company to an elimination company.

Tasks that use this form

Navigating the form

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

Tabs

Tab

Description

Set the criteria that govern this part of the consolidation process.

For example, determine whether consolidation should involve realized (current) transactions and/or budget transactions. You can limit the transactions being consolidated by ledger account, period, and budget model. If no limits are set, all subsidiary accounts are consolidated.

Specify the dimension information that is transferred from subsidiary account transactions to the transactions in the consolidated company.

(This tab does not appear in the form.)

Create a line for each subsidiary company that is included in the export, import, or online consolidation.

In the and forms, indicate the name of the file and the folder in which it is located.

In the and forms, indicate the accounts that are imported for each subsidiary. Indicate whether consolidation exchange differences are posted to a account (default for integrated subsidiaries) or a account in the consolidated company.

To identify various consolidations in the inquiry, enter a brief description of the consolidation that you are working on.

(This tab does not appear in the form).

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

Buttons

Button

Description

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

Fields

Field

Description

The first account in a range of accounts to be included in the consolidation.

The first date in the period for which transactions are included in the consolidation.

The first budget model in a range of budget models to be included in a budget model consolidation.

The last account, date, or budget model to be included in the consolidation.

If this check box is selected, the transactions and balances are transferred to the consolidated company ledger account that is specified in each subsidiary ledger account in the [Field: LedgerTable, CompanyGroupAccount] field in the [EMenuItem: Display, LedgerTable] form.

If this check box is cleared, the transactions and balances of each subsidiary ledger account are transferred to the consolidated company account with the same account number as the subsidiary account. If the corresponding ledger account does not exist in the consolidated company, it is created automatically during consolidation.

Select to include all ledger transactions in the export or import of data.

Select to include only budget transactions in the export or import of data.

Select this check box if the transactions in the subsidiary ledger accounts will be exchange adjusted during consolidation using the exchange rate on the date specified in the field.

A dimension in the consolidated company that can receive data from subsidiary account records.

The consolidated company dimension will contain the kind of data that is specified in the field.

Select the kind of data that is transferred to the field on consolidated company transactions when subsidiary account records are imported:

  • - No dimension information is transferred.

  • - The dimension on the subsidiary ledger transaction is transferred.

  • - The dimension value that is entered in the field in the form of the subsidiary is the consolidated company dimension value that receives the subsidiary dimension amounts.

  • The subsidiary company accounts identifier (ID) is the dimension that is attached to subsidiary amounts in the consolidated company. This option enables you to identify the subsidiary origin of each transaction in the consolidated company at a glance, but other dimension information is not transferred.

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

A description of the consolidation.

Select the subsidiary company accounts to be used in the consolidation.

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 Note

This field is not available or relevant on the form.

Specify the file name and path for the import or export of comma-delimited files of the selected company accounts in decentralized consolidation.

Note Note

This field is not available or relevant on the form, which is used in consolidations where subsidiaries and consolidated companies are in the same database.

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:

  • – Differences are posted to the consolidated company ledger account that is indicated for the value in the field on the form of the consolidated company.

  • – Differences are posted to the consolidated company ledger account that is indicated for the value in the field on the form of the consolidated company.

  • You must make an appropriate selection according to the accounting practice of the country/region of the consolidated company.

Identifies if the elimination transactions will create a proposal or if the transactions will be posted.

Select the date to post the elimination journal to the general ledger.

To put the elimination journal on hold until a specified date, enter that date. You still can modify the elimination journal, and it can be posted on or after this date.

If this field is blank, the elimination journal can be posted at any time.

NoteYou can clear this field to remove the hold.

Select the elimination rule.

Displays the description for the selected elimination rule.

Displays the elimination journal that will be used.

Displays the date that the elimination rule was last processed and distributions were successfully created.

Select the reason for the elimination journal.

Reasons with an account type of appear in the list. For more information, see About financial reason codes.

Enter a reason description (optional).

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.

See Also