There are a number of other files that could be affected as well such as the
inventory files ILI (location level), IWI, (warehouse level), purchasing
files HPH (P.O. Header), HPO (P.O. lines), etc.
Not only the files that have item number fields must be kept in sync but
other related files as well. For instance if the item to be inactivated is
on an open order, not only does the order line ECL need to be corrected but
the quantity and dollar amounts on the order header ECH must be updated and
the open order amount on the customer master RCM must also be updated.
UPI has a product called Item Undertaker which will handle all the edits
performed by he INV100-Item Master Maintenance delete process. It will
automatically remove those records that it can such as costs, notes, etc.
and identify all records that need some manual intervention.
These would include things like the item is on an open PO. Was the item
totally discontinued or was it replaced with a different item. A live
person needs to determine if the PO line should be closed or if a substitute
item should be ordered. Item Undertaker Identifies all such records that
need manual attention. Once these records have been addressed, Item
Undertaker can be used to automatically process the records not needing
manual attention and to inactivate the item master record.
For more information on Item undertaker go to:
Dean A. Olson
Director of Software Technology
Unbeaten Path International
Sent: Tuesday, June 16, 2009 7:52 AM
Subject: Re: [BPCS-L] Taking out old part numbers
There are a number of files that need to be kept in sync when trying to
remove old part numbers. The best thing would be to write a program that
checks the associated files, reports if the part is still in use and then
removes the part # associated records at the same time. Files to check if
the part is still active are:
ECL (customer orders)
KFP (planned order)
KMR (material requirement)
MBM (check both if the item is a parent or a child on a bill) MPB (check
both if the item is a parent or a child on a planning bill) IPH (physical
inventory) FMA (component requirement on SO) FSO (shop order) EIX (customer
xref) It is best to use standard BPCS procedures to remove data from these
files. Example, deleting a bill needs to reset the low level code on the
item master. Once everything has been cleaned up, then the records can by
physically deleted from all the files listed above including the CMF
(costmaster) and IIM (item master).
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact