Setting Up a Consolidation Reporting Structure

The system allows you to set up or modify the hierarchical structure of your entities and sites. We recommend that you carefully plan the relationship between entities and sites before using the system. We suggest that you contact our Professional Services group to help with your implementation.

Note: Appropriate rules must be set up between the sites and entities.

Sites must have the same base (domestic) currency as the entity they will report to. If a chart of accounts or accounting periods have been set up at the site, they must match those established for the entity.

Changing Currency Replication Rules

If the Change Reports To Entity utility is performed at a site (not an entity), and that site includes a replication rule for shared currency to and from the entity that it was previously reporting to, that replication rule should be deleted. Then a new replication rule for shared currency should be set up between that site and the new entity. Regenerate replication triggers and run manual replication of the Shared Currency category.

This ensures that users at the site will be viewing the currency records of their new financial entity instead of their old one.

Removing a Site from the Hierarchy

The Change Reports To Entity utility can also be run if a site is sold and needs to be removed from the financial consolidation structure. In this case you would run the utility with the Reports To field blank.

Reconsolidation

The Set Ledger Consolidated Flag utility rebuilds an entity database. Use it to reconsolidate entities whose data was lost, corrupted or discarded due to a complete change in corporate structure.

After running this utility, you should then run the Change Reports To Entity utility to correct the current site structure, using the option to not post the closing balances. You can then run the Ledger Consolidation activity to consolidate into the new structure. In this case, it is assumed that the entity databases into which you are consolidating are new and thus empty of ledger records.