Feature - BOMP Integrity Check Utility

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



    • Related Articles

    • Feature - System Users File Integrity Check

      Release Date - 2/11/16 Added a new "Integrity Check" option to Util Setup-> Password Setup-> List-> Summary Report. See sample screen below: The Integrity Check option will check several conditions in the System Users File. If a record is on file ...

    • Feature - Bank Book Integrity Check Program

      Date Released - 5/18/16 A new utility program, Bank Book-> Util Setup-> Bankrec Integrity Report has been added to the Bank Book module. This utility program will look for Bank Book Reconciliation records that are marked with a reconciliation date ...

    • Feature - Check Bin Integrity on Physical Count Report by Item/Warehouse

      Release Date: 1/31/24 Version: 8.5 and Above Users now have the option to check bin integrity when printing the Physical Count Report by Item/Warehouse and running the multi-bin enhancement. A new report parameter is available from Inventory ...

    • Shipped Data Export Integrity Check

      Release Date: 04/14/2021 Version: 8.5 & Up COP, Utilities, Sales Order Export, Export, and Shipped Order Data Export are used to create an Advanced Ship Notice (ASN) to send to EDI trading partners. In cases where the box data is required, we ...

    • Avalara Setup Procedures - Integrity Check

      Release Date: 4/28/23 Date Revised: 6/10/24 Version: 8.6 and Above You should run Avalara integrity check on daily, weekly or monthly basis. The frequency depends on if you can commit resources for someone to look at the output of this report and ...