Import Consolidation from File Batch Job

Imports entries from the business units that are included in a consolidation if the business units come from a different database than the one that contains the consolidated company. Before this can be done, the entries from the business units must first be exported to a file with the Export Consolidation batch job. The only business units that can be imported are those that are set up in the Business Unit table and that have the Consolidate field selected.

Business units that come from the same database in Microsoft Dynamics NAV as the consolidated company can be imported with the Import Consolidation from DB batch job.

The batch job processes all the entries in the file and imports them to the consolidated company. When the batch job has begun, a status message on the screen indicates which business unit, account number, and date, is being processed.

The date on the new entries in the consolidated company is either the period's ending date or the exact date if the historical rate is used as the Consol. Translation Method. The amounts on the new entries in the consolidated company are converted from the business units' amounts by means of the information on the business unit in the following fields:

  • Consolidation %, Income Currency Factor, and Balance Currency Factor on the Business Unit table.

  • Consol. Translation Method on the G/L Account table for each consolidated account.

When individual general ledger accounts in the business unit are linked to the consolidated company’s account numbers for both Consol. Debit Acc. and Consol. Credit Acc., the batch job transfers debit and credit balances from the business units on the accounts in the consolidated company. If there are already entries for the business unit in the consolidated company, they are overwritten and the following text is attached: Changed by consolidation on (work date).

When you import Closing-Rate balance sheet accounts that already have a balance from a prior period's consolidation, it may be necessary to adjust the opening balance. Any exchange rate differences between the last import and the current import can be verified by using the Balance Currency Factor and Last Balance Currency Factor fields. If there is a difference, the opening balance on the balance sheet accounts is adjusted to the applicable exchange rate for the balance accounts. All exchange rate differences are calculated and posted on the accounts for exchange rate gains and losses that are set up in the Business Unit table. A possible remaining amount is calculated for all the imported entries and posted to the Residual account in the consolidated company.

Options

Field Description

File Format

Select the file format that you want to use for the consolidation. If the business unit whose data you are importing also has Microsoft Dynamics NAV 4.0 or later versions, select the .xml format. Otherwise, select the .txt format.

Document No.

Enter the document number to be used on all new ledger entries created from 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

Export Consolidation
Import Consolidation from DB

Other Resources

Business Unit
Consolidation %
Income Currency Factor
Income Currency Factor
Balance Currency Factor
Last Balance Currency Factor