Freezing When Printing Costed Bill of Materials

Freezing When Printing Costed Bill of Materials

Release Date: 5/24/17

Q -  Would you have any idea what would cause the Total Cost Buildup (BOMP -> Processing -> Print Costed Bill of Material) to always freeze and be unable to complete on a certain part number?

A - The most likely situation is due to a BOMP integrity issue. This can happen when you try to:

  • BOMP -> Processing -> Reset Low Level Codes; or
  • BOMP -> Processing -> Print Costed Bill of Material and you answer "Y" to "Reset Low Level Codes"; or
  • BOMP -> Maintenance -> Cost Master File and you answer "Y" to "Reset Low Level Code First" in "Current Total Cost Build-up" Function.
  • I/M -> Processing -> Reset Allocated Quantities;
The integrity issue can occur when a particular needed item (component) or inventory location record is deleted.  For example: For Mfg Item # 34014, the BOM is set as Item # 34014 = A + B +C +D, but unfortunately somehow item # B has been deleted from Item Master file or the Inventory Location file. When the system tries to update item B or the inventory location record for item B, and the corresponding record is not found, the system can fall into an infinite loop. 

Solution 

Run integrity checking to remove the ghost components (i.e., item # B) from the BOM structure.
From Elliott Main Menu -> System Utilities -> Global Setup --> Utilities --> BOMP Utilities --> BOMP Integrity Check. Please see example shown below. 


You may run this utility by answer "N" first to "5. Delete Invalid Record ?"  Then this utility will give you a list of integrity problems found without altering the Elliott database and you can perform research to confirm the integrity problem.

If you agree with the integrity problem identified by this utility, then you can proceed to answer "Y" to "Delete Invalid Record" from the BOMP product structure automatically and resolve the integrity issue. But since the proper solution may be to add back the deleted item or inventory location record, there's no guarantee that answering "Y" will result in the best action.

Since the integrity problem is often caused by deleting an item or inventory location record, we suggest that you make an item "Obsolete" instead of deleting it.  You can do so by going to the Item Master record and changing field "6. Activity Code" to "O" = Obsolete.  If you don't like the obsoleted item showing up when you perform an F7/F8 search, then you can go to Global Setup -> Dist -> I/M Global Control -> Screen 2, answer "Y" to "3. Exclude Obsolete Item in Item Search ?"

EMK




    • Related Articles

    • BM1000 Bill of Material Print Costed Bill of Material

      BM1000 Bill of Material Print Costed Bill of Material ← Bill of Material / Work Order Plus Print Costed Bill of Material Application Overview Print Costed Bill Of Material prints a selected range of parent items and "rolls up" their costs from the ...
    • 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 ...
    • Feature - Ability to Move Bill of Materials from One Operation to Another in Plus Work Order

      Release Date: 02/12/2024 Version: 8.5 and Above You can now move your Bill of Materials between operations. A move essentially consists of copying your Bill of Materials to the target operation and deleting the Bill of Materials from your current ...
    • Feature - Disable Print Costed Bill of Material to Update Parent Cost

      Release Date: 07/07/2017 We are now introducing a Global Setup flag in Dist -> BOMP Global Control, screen 6: Flag "11. Disable Print Costed Bill of Material to Update Cost?" The default value is "N." If this flag is set to "Y," then in BOMP -> ...
    • BM0000 Bill of Material Package Overview

      BM0000 Bill of Material Package Overview ← Bill of Material / Work Order Plus Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when ...