Taking out old part numbers -- soft deletes vs. hard delete s

Hi Don ... <vendor>

Item Undertaker finds and reports the specific location of all the instances that
require manual attention on the very first pass. Some things do deserve manual
attention ... e.g. an obsoleted part number in a BOM structure.

Once Item Undertaker determines that all the manual attention items have been
removed, it presents the item for a final deactivation decision. A user green light
then unleashes Item Undertaker to a-u-t-o-m-a-t-i-c-a-l-l-y remove all the other
instances.

As we were designing Item Undertaker, we overcame very subtle BPCS
rules and hang-ups that make it almost impossible for INV100 to actually
deactivate an item. If you used INV100 to perform the soft delete you report
below, your choice of a first item to experiment with was fortuitous.

Moving from soft delete to hard delete is a second step and good discipline
requires simultaneous archival of all non-current-year transactions associated
with that item.

More comprehensive information about the process:

Step A: Item deactivation -->
http://www.unbeatenpath.com/software/iu/ItemUndertaker.pdf

Step B: Master file archiving -->
http://www.unbeatenpath.com/software/locksmith/archiving.pdf


By the way, since so many enterprises have invented custom ways to employ
item numbers, we deliver Item Undertaker with an exit point that permits
execution of custom code designed to clean up non-vanilla-BPCS instances of
an obsolete item.

If you've got 10,000 items to deactivate, Item Undertaker will save a least a
man-year of effort and also greatly enhance internal control over the process.
There's a free demo.



Warm regards,
Milt Habeck
Unbeaten Path International

(888) 874-8008
+(262) 681-3151
www.unbeatenpath.com/compass
</vendor>






From: Don Cavaiani
To: BPCS ERP System
Sent: Monday, June 15, 2009 7:47 AM
Subject: Re: [BPCS-L] Taking out old part numbers


I'm on cd405. I tried to delete one part #, and got a MBM message.
After deleting the MBM records, I got a FRT message. After deleting the
FRT records, I got a CMF message. After using SQL to get of the CMF
records, the delete (IIM) went through, BUT, the record is only flagged
as "IZ" and not really removed from the file.

Don