Elimination Tree Codes

You can access this form from the Elimination Tree Codes form within the Consolidation Code Maintenance form.

Setup

To eliminate using transaction trees, the transaction tree Elimination Level must be set in GF Module Control and an elimination tree must be selected. 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. See errors outlined in Generate Consolidation.

warning When eliminating by Transaction tree, in order for the transaction code to be included in the consolidation, the consolidation must be transaction level. This can be set either against Consolidation Code or, if the consolidation code is set to consolidate at the general ledger account, selected accounts can be set to transaction level in GL Account Maintenance. Opening balance consolidations do not bring through transaction codes, as 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.