Consolidation Code Maintenance

Access this form from the System > Consolidations menu. Codes are system-wide and can be set up from within any company using consolidations.

Each company in the consolidation needs a parent/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 long. The consolidation code

will appear in the narration of consolidated transactions.

Description

A consolidation description must be entered, and can be of unlimited length.

Consolidation Level

Select one of these options:

Summary

When consolidating the subsidiary company's information into the consolidation company, one journal line is generated per general ledger account per period.

Transaction

When consolidating the subsidiary company's information into the consolidation company, one journal line is generated 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.

Information The first consolidation run always be at Summary level. If transaction level is required for the first run then a dummy consolidation run must be performed 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, shown in the Consolidation Structure sheet.

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.