xTuple ERP Reference Guide

The Synchronize Companies utility is designed to synchronize a parent database with child databases for the purpose of consolidated financial reporting. This utility will only be visible when external company consolidation is enabled on the Accounting Configuration screen—and then only when users have appropriate permissions.

When you elect to synchronize a child database with a parent, the application will check to make sure a currency exchange rate exists between the functional currency of the child and that of the parent for each accounting period to be imported. The system will also check for needed account assignments, including the unrealized gain/loss account tied to the child company's currency. If any requirements are missing, the process will stop and you will be presented with an error message describing the missing information.

Once all synchronization criteria are met, the synchronizer will import the trial balance of the child database to the trial balance table of the parent database in the parent's functional currency using the exchange rate defined for the end of the specified accounting period(s) in the parent database. The parent database will keep a record of the exchange rate used for the import. If the exchange rate for that date is subsequently changed, the exchange rate record will be marked as dirty—and on the next subsequent synchronization, the trial balance data of the child will be re-imported using the new exchange rate. A warning will be shown when running trial balances or financial reports having dirty exchange rate data.

To synchronize companies, go to Accounting > Utilities > Synchronize Companies. The following screen will appear:

Synchronize Companies

When synchronizing companies, you are presented with the following lists:

The following buttons are unique to this screen: