RE: MAPICS -- Warehouse going away

Bob,

When we delete a warehouse we just use query to verify that the quantity on
hand is zero.   Then use SQL or a small RPG program to delete the Item
Balance records.

Unless there is some very good reason to delete them, I would leave the PDM
and Item Master records.   There are many occasions when you way need the
item description for sales reports or other various reports.  After a year
or two goes by and they are no longer needed, then delete them.

Just my opinion,
Greg  

-----Original Message-----
From: Bob Anderson [mailto:banderson@xxxxxxxxxxxxxxxxxxx] 
Sent: Thursday, April 28, 2005 9:03 AM
To: MAPICS ERP System Discussion
Subject: MAPICS -- Warehouse going away

Good Morning,
        We have a warehouse we have closed and we want to delete all of the
data
that is associated with it.  What is the best way to do a Mass delete all of
the PDM structures and Item Balances that associated with that warehouse.

Bob Anderson
IT Guy
Kent Sporting Goods Inc.
New London OH
Ph: 419-929-7021 x315
Fax: 419-929-1380

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.4 - Release Date: 4/27/2005

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