BATF Regen Error Message: "Cannot Find An Acq. Rec For This Disp. Rec"

BATF Regen Error Message: "Cannot Find An Acq. Rec For This Disp. Rec"

Q - We received the following error message on the BATF Regen report this morning:       
E: Cannot Find An Acq. Rec For This Disp. Rec
If you go to Serial/Lot History Inquiry to look up the corresponding serial number, you will see the following activities:



What causes this error message to appear?

A - First, let us explain how the BATF Regen utility works.  For each serial number the Regen utility expects to see the serial history in a chronological order that makes sense. It expects to see the acquisition record first, then the disposition record can follow.  The system needs to match each disposition record to the acquisition record so the BATF bound book can present the information correctly.  The chronological order is established based on the “posting date/time,” which is not necessarily the “document date/time.”  When you go to Serial/Lot History Inquiry, the sequence you see is the serial history ”posting date/time” sequence.  In this particular case, for serial number RS03694W,  if you look at the chronological order the last four entries show as follows:
            5/12/15, it is invoiced to ALEX MALDONAD with pickup pending
            6/05/15, it is credited and received back from ALEX MALDONAD
            5/22/15, it is pickup by ALEX MALDONAD with the “D” disposition record
            6/8/15, it is invoiced to ALEX MALDONAD

As you can see, the third entry is clearly out of place.  Based on this sequence, the BATF Regen utility concludes:
  1. The 5/12/15 entry is ignored by BATF Regen because it is a pickup pending record. 
  2. The 6/5/15 entry establishes the acquisition record because the serial number is returned.
  3. The 5/22/15 entry establishes the disposition side for the 6/5/15 entry.
  4. The 6/8/15 entry makes no sense to our system because it is a disposition without the acquisition record since the 6/5/15 entry is already consumed by the 5/22/15 record.  Hence, you receive the error “Cannot Find An Acq. Rec For This Disp. Rec” 
The proper sequence should be as follows:
            5/12/15, it is invoiced to ALEX MALDONAD with pickup pending
            5/22/15, it is pickup by ALEX MALDONAD with the “D” disposition record
            6/05/15, it is credited and received back from ALEX MALDONAD
            6/8/15, it is invoiced to ALEX MALDONAD.

If our system displays the serial history in the above sequence, then the BATF Regen utility will be happy.  So why does our system display the 5/22/15 entry after the 6/05/15 entry?  

If you highlight the 5/22/15 entry, you will see the “post date/time” is “6/8/15 11:20:27.”  As I mentioned earlier, the BATF Regen utility uses the “post date/time” to establish the chronological sequence.  We think someone mistakenly changed this entry’s post date/time and disturbed the natural chronological sequence.  So the BATF Regen utility complains.  If you can change the 5/22/15 entry’s posting date back to 5/22/15, then BATF Regen will not complain.

The ability we introduced to our users to edit the “posting date/time” of a serial history record is a double-edged sword. While it allows you to fix certain serial history problems that require back date entries, if you don’t use it correctly it can cause this kind of problem as well.



    • Related Articles

    • How Using Serial Lot History Edit Function Impacts BATF Bound Book

      Release Date: 04/17/2018 Q - In I/M -> Processing -> Serial/Lot Processing -> Processing -> Change Serial Lot History Record, you can use F5 key to modify the following fields: Document Date Posted Date Posted Time Customer No Job No (4473) What ...

    • Feature - ATP Regen to Consider Order Multiple and Economic Order Qty

      Release Date: 03/09/2016 Revision Date: 01/20/2021 Version: 8.5 & Up When running the ATP Regen to create plan orders, the program only creates enough plan order quantity to make sure there will be no negative inventory in the future. The program ...

    • BATF Report Selection by FFL

      Release Date: 4/5/2016 Added FFL selection criteria to the BATF report. Entered FFL may be 8 or 15 characters and should not contain "-" between the different segments of the FFL. Selecting by FFL number is an alternative to selecting by customer or ...

    • Feature - Print Error Message If Inventory Transaction Distributions Are Missing

      Date Released: 9/24/19 Version: 8.5 and up The Inventory Transaction Edit List and Inventory Transaction Posting Journal now check for missing Inventory Transaction Distribution records. An error message is printed if distributions are missing, and ...

    • What Causes Load Error 198?

      Modified Date: 6/7/2019 Q - One of our computers received an error 198 load error randomly. The message looked like the following sample screen: Load error: file "SYCONSEL" error code: 198, pc=0, call=15, seq=0 or Load error: file "SYACTCHK" error ...