Report Desk - How to Add Where Condition for Orders Qualifying for Pick Ticket without User Interface
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