A question recently was asked in the Sage City online discussion area about whether there was a tool available to automatically consolidate multiple separate Sage 100 company codes into one.
At the time I’d forgotten that there is indeed a tool available and it’s from Accounting Systems Incorporated.
From their product specification sheet:
Company Consolidation can merge separate companies into one consolidation company. Once the basic setup is complete,
the actual process can be run from the menu or from an outside shortcut started by scheduling software. The consolidation starts
by copying the first source company to the consolidation company. If divisions are turned on for any source company,
they are turned on for the consolidation company. General Ledger accounts are matched based upon the formatted account
number. Any accounts missing in the consolidation company are automatically added. Matching customers and vendors are
merged, but customers and vendors missing from the target are automatically added. Detail data, such as transactions, invoices,
and orders, are not added together but are renumbered if necessary to maintain their unique identity. All companies must
have the same G/L account format and the same fiscal year in order for the consolidation to work.
The utility is available for Sage 100 ERP versions v4.40, v4.50 and v2013.