Re: Taking out old part numbers

We are on BPCS 405CD We have a program we run about every 6 months. First
check last transaction, IIM ( older than three years ), check where
used, MBM.

If older than two years, produce list of finish good items, with customer
from SSD or SSH. Sales review list to authorize deletion. We
created an item type of "I" for inactive to identify inactive items. "I"
means no new orders. Different customers / sales people have different
ideas what is an old item.

If Purchase Raw item "R" type, then the last transaction (older than two
years) and no where used, then we delete the item and cleanup several
files.

Addition files to consider cleaning up: IWI, MPN, SSD, SSH, CMF, LBR,
EIX, SIL, SIH
Cleanup PO's HPO, HPH, AVM, APO,
APG,

Item numbers are in file SIL, Invoices, and ECL orders. How far back
do you keep for order history and invoice reprints?


Roger Henady
Thorco Industries
(417) 682-1340



From:
"Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
To:
<bpcs-l@xxxxxxxxxxxx>
Date:
06/11/2009 04:02 PM
Subject:
[BPCS-L] Taking out old part numbers



No vendors please.

Any warnings/caveats regarding use of strsql to delete very old part
numbers out of the database -e.g., IIM/CIC/HPO/MBM/ITH/ECH/ECL/FSO/FOD/FRT
.....???

TIA

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman