Export Consolidation Batch Job
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
For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.
See Also
Reference
Import Consolidation from File