Fw: Purging Mapics Files

["Dave Shaw" <dhshaw99@xxxxxxxxxxxxx>]

Oops, had a problem with the handling of this one. Forwarded for Wayne.

Dave Shaw
MAPICS-L Moderator
Simpsonville, SC
 
----- Original Message ----- 
From: <Wayne.Baldwin@xxxxxxxxxxxxxxxxxxxx>
To: <Mapics-L@xxxxxxxxxxxx>
Sent: Monday, February 24, 2003 7:43 PM
Subject: Purging Mapics Files


> We have a unique situation here as we are a "job" shop.
> Programs have been developed over years which will take an
> item and create a "job item" for use in a job. The common
> factor is the engineering number which identifies it as the
> same part to all jobs. Here is a brief example:
> 
> Part ABC       for job 10001, the part is called: 10001/0001
>                      for job 10002, the part is called: 10002/0002
>  
> and so on.......
> As you can imagine, over the years the database is now quite 
> large. We have item balance, product structure, requirements,
> manufacturing orders, etc. that now need to be purged as we 
> are embarking on a Procurement Management installation.
> 
> Does anyone have programs to check and delete related items
> across the various master files??  If not programs, then possible
> pitfalls for purging master files?? The last thing I want to be left
> with is manufacturing components without item master or item
> balance records.
> 
> Thanks in advance..................................
> 
> 
> Wayne R. Baldwin
> Senior Programmer/Analyst
> Smiths Aerospace Electronic Systems - LI
> 1000 MacArthur Memorial Highway
> Bohemia,  NY  11716
> Telephone: (631) 467 - 5500  Extension: 258
> Fax: (631) 467 - 5943
> 
>