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 ...

    • 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 ...

    • NSCTLMN3 Purchase Order Global Control Setup 1

      Global Setup P/O Global Control Setup 1. Select Util-Setup from the Elliott Main Menu. 2. Select Global Setup 3. Select Dist. 4. Select P/O Global Control Fig. 3D.1 P/O Enhancement Setup Screen Display Total Weight/Volume/Amount During Po Entry ...

    • NSCTLMN3 Purchase Order Global Control Setup 2

      Purchase Order Requisition Application Overview This Enhancement is a preprocessing function for creating purchase orders by allowing you to enter requisition data from various modules into the PO Requisition Trx File. It will allow the purchasing ...

    • NSCTLMN3 Bill of Material and Production Order Global Control Setup

      Global Setup BOMP Global Control Elliott Main > Global Setup > Dist > BOMP Global Control Figure 3A.1 shows the setup screen BOMP Global Control 1. Copy Regular Cop Orders Into BOMP This enhancement allows you to copy a regular order with ...