Elimination Tree Codes

You can open this form from the Consolidation Code Maintenance form.

Setup

To eliminate using transaction trees, the transaction tree Elimination Level must be set on the Global Finance Module Control form. You must select an elimination tree. The elimination tree is a system wide setting. There may only be one elimination tree per system.

The elimination tree must be assigned to each company that intends to use the tree, and the consolidation company.

Assigning for both transactions and general ledger account will allow for reporting by tree in the general ledger reports.

Posting branches must be available for both the subsidiary and consolidation companies and the tree must be available to the general ledger accounts in the consolidation company for posting.

When eliminating by transaction tree, for the transaction code to include in the consolidation, the consolidation must be transaction level. You can set this either with the consolidation code or, if the consolidation code is set to consolidate at the general ledger account, you can set selected accounts to a transaction level on the GL Account Maintenance form.

Opening balance consolidations do not bring through transaction codes. They are summaries of transactions.

Recommendation

Assign only the branches that each company may use for elimination in the Transaction Tree Maintenance posting levels.

Elimination Tree Codes (accessed using Consolidation Code Maintenance)

Each combination of company and transaction code listed is available to be exported in the Export Elimination Transactions process.

Only companies with the elimination tree assigned is available in the Company code dropdown list.
Only transaction tree codes which are valid posting level branches for that company may be selected.

If a transaction is not to be eliminated at the first consolidation level, the transaction code will still be exported to the consolidation company and may be part of a later elimination by setting the consolidation company code with the tree code as an elimination combination in that consolidation code.