Re: Duplicate Customers

["Bob Tenney" <bobtenney@xxxxxxxxxxxxx>]

Ted, Don't even think of doing this! It is almost as bad as combining item
numbers. You have to change every file where the customer number occurs
(probably 200-300 + history). If you are using IFM, you have to make the
same change with entities and this adds at least 50 more files.

A better approach is to eliminate duplicate customers by disabling all
customers other than the one that you want to keep going forward. There is
an Enterprise Code in the customer master that you can use to link the
duplicates and then report / query as if they were one customer. IFM has an
Entity Group field that does the same thing.

Bob Tenney
Bob Tenney Solutions, LLC
MAPICS - FRx - Presence - Crystal Reports
828-526-8976

Visit www.tenneypubs.com for books about
IFM, COM, G/L Interfaces
Info WorkPlace, Cost Accounting, and FRx
----- Original Message -----
From: "Hendricks, Ted" <Ted.Hendricks@xxxxxxxxxxxxxxxxxxx>
To: "'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
Sent: Friday, April 11, 2003 12:35 PM
Subject: Duplicate Customers


> Hello.
>
> We are wanting to clean up our customer master and rid ourselves of
> duplicates.  Has anyone done this before?  What related tables will I need
> to be concerned with.
>
> Thanks in advance,
>
> Ted
> _______________________________________________
> 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.
>
>