What Other Programs Can Update Order Date Picked Field?

What Other Programs Can Update Order Date Picked Field?

Q - This has happened mysteriously a few times over the past few months. Someone will go to print a pick ticket, and the system responds with a "nothing in range" message. When that user tries again with a different number, the same thing happens. Then someone runs a B/O report and orders show that pick tickets were printed, but they were not.

They find that the orders are marked with today's date in Order-Date-Picked, but no one printed the orders. They do not typically print "All" -- each customer service rep enters an order then prints his/her order. Sometimes they will enter a few and print a small batch, but not usually.

You see from the image below an example of a back order that printed today,  yet no one actually changed the Qty To Ship, so they wouldn't have printed the B/O.


What possible program could have printed - or at least set the Picked date - to cause this problem? Needless to say, this is how their back orders would slip through the cracks.

A - In addition to a pick ticket program that will update "Order Date Picked" field, the following are two other possible reasons why this field might have updated:

  1. If the user prints a packing list before printing a pick ticket, then the order date picked value will be updated.
  2. If the user prints a legacy bill of lading, it can optionally update the order date picked value per Global Setup ->  Cop-Ctl -> Legacy Bill of Lading, field "6. Update Order Picking Date After Printing."

If you want to find out when and who performed a function that resulted in an updating of the Order Date Picked field, you can implement Audit Master to track it down.

EMK




    • Related Articles

    • Feature - Calculate Order Total Sales Amount for Open Non-Picked Orders

      Release Date - 2/20/19 This feature gives the user the ability to calculate the Order Total Sales Amount. This ability has been added to the Order Integrity Check utility program. It is available from Global Setup-> Utilities-> COP Utilities-> ...

    • Feature - Order Inquiry Pick Date Status Notation

      Release date: 9/29 Currently, Order Inquiry only shows if the order is picked (after the picking ticket is printed), billed or invoiced. Many users desire to know more details of an order after the pick ticket is printed, before it is selected for ...

    • Feature - Sales Order Import Request Date Warning

      Release Date: 6/13/19 Version: 8.2 and Up Previously users would control whether the message "Request Date Has Already Passed" was a warning or just a standard attention message through Global Setup-> Add-Ons-> Sales Order Import field 20, Ship Date ...

    • Presales Update

      Release Date: 3/1/24 Version: 8.6 and Above The Presales Update application allows the user to add, change, or delete Presales transactions. The application will bring up a window similar to F8 search where it will prompt for the starting description ...

    • What Is The Purpose of Field CPORDHDR_FRT_ENT_MTHD in COP Order Header?

      Release Date: 2/23/2021 Version: 7.5 & Up Q - Can you explain the purpose/functionality of the ORDER_FRT_ENT_MTHD field in the CPORDHDR table? A - The purpose is to record how the order header freight amount is determined. The possible values can be: ...