Report Desk - How to Add Where Condition for Orders Qualifying for Pick Ticket without User Interface
Release Date: 03/29/2024
Version: 8.6 & Up
Q - In Report Desk, I would like to modify the existing Order Edit List to develop a Pre Pick Ticket List. These are the orders and line items that qualify to print pick tickets. Therefore, I am only interested in "O" type of open orders. Also, I want only the line item quantity to ship greater than zero. I want these conditions to always be included in the WHERE condition, but I don't want any user interface in the selection criteria screen. How do I do that?
A - The method to accomplish this requires using the "Hide this CheckBox from the user" feature in the WHERE condition. For more details on how to use a check box in WHERE condition, please see the following KB article:
The hidden check box in this example would be like the following sample screen:
To construct this WHERE condition, you need to have some understanding of the Elliott database.
(1) ORDER_SELECTION_CODE can have the following values:
I - Order is incomplete (in the middle of order entry)
C - Order is complete (including both open order and order pick ticket printed)
S - Order is selected (order is selected for billing)
N - Order invoice is printed but not OK (a temporary status)
X - Order is invoiced (order invoice is printed)
Z - Order is posted
We need to specify ORDER_SELECTION_CODE = "C" to get our qualified order.
(2) In addition, we want to find those orders for which the pick ticket has not yet been printed. Therefore, we need to add the condition ORDER_DATE_PICKED = 0.
(3) Since we are only interested in "O" type orders, we specify ORDER_TYPE = "O."
(4) Lastly, if the line item quantity to ship is not filled (backorder), then we don't want to print. So we add the condition LINE_ITM_QTY_TO_SHIP > 0.
These conditions will be added to the WHERE condition of the SELECT SQL statement when selecting the records. Users will not see this check box in the selection window user interface.
EMK
Related Articles
Printing Pick Ticket to Put Order on Hold if Missing Purchase Order Number
Release Date: 1/15/22 Version: 8.5 & Up In EDI Profile, screen 6, there's a flag to prevent a sales order without a PO Number: 6. Is Purchase Order Number Required? See sample screen below This flag is important for EDI purposes since most trading ...How to Add System Date and Time on Laser Pick Ticket
Q: I recently changed from a regular pick ticket to a laser form pick ticket. I like the more professional look of the laser form ticket, but one thing I had before on the regular pick ticket was the system date/time printed on the top line. The date ...Developing a New Elliott V8.6 Report Desk User Defined Report (UDR)
'Release Date: 6/20/2018 Version: 8.6 & up This document is written for licensed Elliott Software developers. It is not relevant for regular Elliott users. Overview With proper licensing, Elliott developers can follow these three steps to create a ...Feature - Pick Ticket FFL Address Mismatch Event
Release Date: 3/5/2018 In the Elliott firearms industry vertical solution, the user can import the FFL master database from the BATF website. The Elliott system can then match the customer, ship-to and order address against this FFL master database. ...Feature - Pick Ticket/Packing List - Print Orders with WO Line Item Only Flag
Release Date: 04/19/21 Version: 8.5 & uU In Pick Ticket Printing, there is this flag: 10. Print Orders with WO Line Item Only? The possible value for this flag was "Y" and "N" where: Y=WO Line Item Only (all line items in the order must be work order ...