RE: Duplicate Customers

["Hendricks, Ted" <Ted.Hendricks@xxxxxxxxxxxxxxxxxxx>]

Thanks.  That is what I was thinking we would have to do.  We don't have
IFM, but I was curious if there was a way to rid ourselves completely of a
number of customers that were dumped into our system from an acquision.  You
answered my question, I appreciate it a lot.

-----Original Message-----
From: Bob Tenney [mailto:bobtenney@xxxxxxxxxxxxx] 
Sent: Friday, April 11, 2003 9:51 AM
To: MAPICS ERP System Discussion
Subject: Re: Duplicate Customers


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.
>
>

_______________________________________________
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.