Consolidation Code Maintenance

Open this form under the System > Consolidations menu. Codes are system-wide and you can set them up from within any company using consolidations.

Each company in the consolidation needs a parent to subsidiary mapping. If a parent is also a subsidiary, it must have its own consolidation mapping.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Consolidation code

Enter or select the consolidation code, up to 40 characters. The consolidation code displays in the narration of consolidated transactions.

Description

Enter a description of the consolidation.

Consolidation Level

Select one of these options:

Summary - When consolidating the subsidiary company's information into the consolidation company, one journal line generates per general ledger account per period.
Transaction - When consolidating the subsidiary company's information into the consolidation company, one journal line generates per transaction per general ledger account per period.

GL account

When consolidating the subsidiary company's information into the consolidation company, the balance or transaction level is determined by the setting on each general ledger account in the subsidiary company.

Note: The first consolidation run is always at summary level. If transaction level is required for the first run, you must perform a dummy consolidation run in the previous period (even if no transactions are consolidated).

Set up

Click this button to open the Consolidation Company Mapping Maintenance form.

Refresh

Click this button to refresh the tree diagram of the company consolidation hierarchy.

Consolidation Structure

This form displays a tree diagram of the active company mappings set up for the selected consolidation code, starting from the highest level parent company the user has access to. Click + to expand parent company trees. Click - to collapse parent company trees.

Elimination Tree Codes

Use this form to set up transaction tree analysis codes to define the elimination process.