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

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

    • BM1800 Bill of Material Production Transaction Processing

      BM1800 Bill of Material Production Transaction Processing ← Bill of Material / Work Order Plus Production Transaction Processing Application Overview The Production Transaction Processing application allows for reporting progress made toward ...

    • CPFRMMNT Customer Order Processing Invoice Form Setup

      Invoice Form Setup Application Overview We are constantly striving to develop flexible and compatible business applications. The Invoice Form Setup application and Design Your Own Invoice enhance this objective, by combining Elliott's standard ...

    • CP0800 Customer Order Processing COP Setup

      Utilities Setup COP Setup Application Overview COP Setup allows you to customize the package to some degree. You will run this application once while you are converting from your former Order Processing system. You will rarely need to refer to it ...

    • CPSETCUS Customer Order Processing Reset Customer Sales/Cost

      Reset Customer Sales/Cost Application Overview This feature is a safety feature if you forget to clear your A/R accumulators at month or year-end. Running it updates the Customers Period To date and Month To Date based on information stored in the ...