Import Consolidation from DB Batch Job

Imports entries from the business units that will be included in a consolidation. You can use the batch job if the business unit comes from the same database in Microsoft Dynamics NAV as the consolidated company. Before a business unit can be included in the batch job, it must be set up in the Business Unit table and the Consolidate field must be selected.

Business units that come from other databases in Microsoft Dynamics NAV must be imported with the Import Consolidation from File batch job.

The batch job processes all the entries in the business unit that must be included in the consolidation. The entries in the consolidated company are created from the entries in the business units. When the batch job has begun, a status message on the screen indicates which business unit, account number, and date are 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 sheet accounts. All exchange rate differences are calculated and posted to 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

Starting Date

Enter the first date in the period from which entries are imported. 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 are imported. If you use a closing date, the starting date and ending date must be the same.

Copy Dimensions

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

Document No.

Enter the document numbers on all the entries that are imported.

Parent Currency Code

This field contains the currency code for the parent company. It is copied from the LCY Code field in the General Ledger Setup. It should only be changed if the business unit's Currency table refers to the parent company's currency using a different currency code.

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

Other Resources

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