You can access this utility from Global Setup -> 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
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 10 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