Skip to Content
Feb 09, 2009 at 12:42 AM

Merge multiple separate companies (databases) into one



I have a customer running approx 7 separate legal entities (7 sep databases) at the moment. They are having problems / complaints from their users logging in and out of the db in order to process data. These company db are all in the one country but some have different local currencies (end users login from overseas) -

They wish to merge the companies into one database, using BP prefixes to define Bp's relevant to each company and link individual control accounts to each BP to track Accounts Receivable and Accounts Payable. Deloittes have given them the okay to have an out of balance balance sheet etc., (they say they will tidy things up at the end)

Item GL Setup will be done at Item Level only so a separate set of GL Codes can be defined for each Item Code -- companies do not sell the same type of items.

I am not keen for them to do this for many reasons however - has anyone who has been working with SBO for a number of years out there already done this with success.......Version 2007A .....