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

    • 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 ...
    • APINVIMS Accounts Payable Invoice Import Utility

      A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...
    • 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 ...
    • Deleting Location in Location or Inventory Location Control Files May Cause Referential Integrity Error

      Release Date: 03/14/2025 Version: 7.x & Up Q - We no longer have our warehouse in Tulsa, OK (TL), and I would like to delete the location “TL” in Elliott. The Stock Status Report shows there is no inventory on hand in the TL location. Is it as simple ...
    • 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 ...