Open the Export Consolidation window.

Exports entries from a business unit to a consolidated company. When the consolidated company is set up, all the entries must be imported from the Business Unit table in the consolidated company with the Import Consolidation from File batch job.

All the entries in every general ledger account are processed. For every combination of global dimensions and date, the contents of the entries' Amount fields are totaled and exported. Then the next combination of global dimensions and date with the same account number is processed; then the combinations in the next account number are processed, and so on.

The exported entries contain the following fields: G/L Account No., Posting Date, Debit Amount, Credit Amount, Add.-Currency Credit Amount, and possibly dimension codes.

The date used is either the period's ending date or the exact date of the transaction if the historical rate is used as the Consol. Translation Method for the account.

Options

Field Description

File Format

Select the file format that you want to use for the consolidation. If the parent company that will perform the consolidation also has Microsoft Dynamics NAV 4.0 or later versions, select the .xml format. Otherwise, select the .txt format.

Starting Date

Enter the first date in the period from which entries will be exported. If you use a closing date, the starting date and ending date must be the same.

Ending Date

Enter the last date in the period from which entries will be exported. The period defined in the Starting Date and Ending Date fields cannot be longer than 500 days. If you use a closing date, the starting date and ending date must be the same.

Copy Dimensions

Select dimensions if you want the entries to be classified by dimensions when they are transferred.

Parent Currency Code

Select the currency code of the company that will perform the consolidation.

Tip

See Also