RE: Merging Companies

I too merged two companies while using MAPICS DB a long time ago.    I would
not want to try it using XA.   Consider keyed files which have the company
number as part of the key.  When you switch all your company 2 records to be
company 1 you may get duplicate key errors.   Does company 2 use a different
set of order numbers, invoice numbers, customer numbers, etc. that are
entirely different from company 1?   There are so many other fields that
need unique numbers that I would not even attempt this merge.

Perhaps at conversion time make a copy of your production environment and
freeze it.   Use it only for historical retrievals.   Merge company 2
accounts into the other environment as new accounts.  You may have to give
some of them new numbers.  This way there can be no conflicts.   After about
1 year or 2 most users will have no need to access the frozen environment.
It could be saved to tape and removed.

Greg     

-----Original Message-----
From: Pete Olshavsky [mailto:polshavsky@xxxxxxxxx] 
Sent: Thursday, March 04, 2004 7:52 AM
To: MAPICS ERP System Discussion
Subject: Re: Merging Companies

Phil, Yes are correct. THis is a big job. Especially with COM. I did
something like this in the old OE&I days. Something to watch out for is
Dulicate customer no between the 2 companies. Might want to consider using
offline load options where and when available.
And don't forget any side systems and custom code you may have.
 
Good luck
Pete Olshavsky
Ind Mapics Programmer/Systems Analyst

Phil Brewer <philbrewer@xxxxxxxxxxxxxxxxxx> wrote:
Hi All,

I'm new to this list and new to Mapics too.

Where I work use Mapics V6, COM, CAS, PUR, IM ....

We are in the process of installing IFM, we currently use CODA as our 
financial package.

Currently one of our environments has two companies 1 and 2. It has been 
decided that, before installing IFM, these companies need to merge i.e. 
all company 2 customers etc. will become company 1 and then company 2 will 
disappear. Has anybody else ever done this ? Any tips ? Is it feasible 
?

My current thinking is that i will have to manually change the company 
number from 2 to 1 on _every_ file that has a company field on it......not 
a simple task.

Thanks,

Phil

****************************************************************************
****************************************
This email message and its content are confidential and may contain
proprietary or privileged information. If you are not the intended
recipient, please notify the sender immediately, and do not read, copy,
disclose, distribute or use the information in any way. Any views expressed
in this message are those of the individual sender, except where the message
states otherwise. Barloworld Scientific Group Ltd. and its subsidiaries
("the company") does not accept responsibility for such views and opinions
and this message should not be read as representing the views and opinions
of the company. No liability shall attach to the company, except where the
message states otherwise and the sender is authorised to make such a
statement.

This e-mail has been swept for the presence of computer viruses, but no
warranty is given that this e-mail and any attachments are virus free. You
should undertake your own virus checking. The right to monitor e-mail
communications through our networks is reserved by us.
****************************************************************************
****************************************
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you're looking for faster.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.