What Does Global Setup BOMP Utility Reset Order Transaction Data Do?

What Does Global Setup BOMP Utility Reset Order Transaction Data Do?

Release Date: 10/07/2023
Version: 8.2 & Up

Q - In Global Setup, we can find the following utility in BOMP Utilities -> BOMP Utilities -> Utilities -> Reset Order Transaction Data.  What does it do?


A - In some situations, the transactional accumulated total fields in the BMORDRTG table may get out of sync with the data in BMPTXFIL. This utility will reset those fields in the BMORDRTG table from BMPTRXFIL (the unposted plus work order routing data).

The BMORDRTG table contains both the posted and transaction (not posted) accumulated totals for various fields. In various Plus Work Order Operations, it may need to evaluate each operation by adding up both the posted and transaction values to determine if certain operations can proceed. This is because the posting of production transactions may not happen right away.

In some situations, the transactional accumulated data in BMORDRTG can get out of sync with data in BMPTXFIL (unposted transaction routing data.) We can imagine this happening in a scenario where the Plus Work Order Time Clock operation needs to update both BMORDRTG and BMPTXFIL, along with other tables. It may not go through as a complete transaction set due to record locking or other data IO errors.

Hence, it is necessary to have a utility to reset the accumulated transaction fields in BMORDRTG based on data in BMPTRXFIL. This program will print the order and its routing. Even though you can hit ENTER for all orders, but it will only print those plus orders that contain the corresponding BMPTXFIL records.  If everything matches, it will look like a Plus Work Order Production Transaction Edit List.  However, if it does not match, it will show the data from the accumulated total in BMPTRXFIL.  You may choose to update BMORDRTG or not to update to work as a preview mode.

Related Programs: BMRESETP

EMK


    • Related Articles

    • 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 ...
    • Global Setup Fields Added for the Warehouse Management System

      Warehouse Management Global Setup We have deprecated the Take an Order Interface option on the Global Setup-> Add-ons menu. The option Warehouse Management System will replace the old option. This new application is available: 1. Enable Warehouse ...
    • BM1300 Bill of Material BOMP Setup

      BM1300 Bill of Material BOMP Setup ← Bill of Material / Work Order Plus BOMP Setup Application Overview BOMP Setup, like Company Setup, is not an application that you will need to run frequently. Through this application you will answer some ...
    • Feature - Utility to Reset Item PTD Fields from Location History

      Release Date: 02/04/2016 A new utility has been developed to reset item PTD fields from I/M Location History (IMLOCHST). IMLOCHST is a better database to keep track of item history, however some users are used to looking at the data in the Item ...
    • Presales Interface Setup

      Release Date: 3/1/24 Revised: 3/21/24 Version: 8.6 and Above Alpha Document Number Support If using alpha document numbers, set up alpha document number support for the Presales Generated Order. This option is available from System Utilities-> Global ...