Feature - BOMP Integrity Check Utility

Release Date: 07/22/2011

You can access this utility from Global Setup -> Utilities -> BOMP Utilities-> Utilities-> BOMP Integrity Check.  



The purpose of this utility is check the integrity of two database tables:
  • Bill of Material Product Structure
  • Bill of Material Production Work Order
This utility will check to see if the parent or component item is still defined in item master. If not, then the corresponding BOMP Product Structure record will be deleted.  For a material work order, the corresponding records in the BMORDOPT table will be deleted.  For a plus work order, the corresponding records in the BMORDMTL table will be deleted.

For a production work order, it will also check to see if the corresponding inventory location record (IMINVLOC) exists. If not, the system will delete the corresponding BMPRDSTR, BMORDOPT and BMORDMTL records.

The primary reason behind this is to address the situation that occurs when a user performs "Reset Qty Allocation" or "Reset Low Level Code," and the user gets a Btrieve error code 010 when a parent or component item is no longer in item master or an inventory location.  Usually, when you try to delete an item master record that is referenced by the BOMP product structure, Elliott will try to prevent you from deleting this record.  But Elliott can't check all conditions for performance reasons. Therefore, when the item or inventory location record is deleted, this causes a data integrity problem in Elliott.

Generally speaking, we do not recommend that our users delete an item master record.  If an item is no longer used, we suggest making the item "Obsolete" instead of deleting it.

Modified Programs: BMORDCHK, BMORDCHS
EMK

Feedback and Knowledge Base