RE: Merging Companies -- MAPICS-L

I have done the exact opposite.. I have actually taken one env and extracted 
companies and warehouses and put them into 2 environments. I would say that 
this is a little easier since I didn't have to worry about duplicates 
(customers), but I would say that this is completely doable. Since you haven't 
installed IFM it is a lot easier if you do have IFM. 
 
I basically dumped all the files/fields into a database and then extracted any 
field that was 2 bytes in length.  I then went through manually and determined 
which fields were actually company # (warehouse as well).. Once I did that, I 
knew which files I had to merge/delete/or change.
 
If your customer#s are different, then it is not bad, if they are the same then 
you will have to make a decision. You should probably re-number the customer, 
which would entail changing other files for the customer #. You can use the 
same logic as above looking for fields that were 8 in length.

        -----Original Message----- 
        From: mapics-l-bounces@xxxxxxxxxxxx on behalf of Greg Wenzloff 
        Sent: Thu 3/4/2004 8:46 AM 
        To: 'MAPICS ERP System Discussion' 
        Cc: 
        Subject: 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.
        _______________________________________________
        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.