How to print: See Streamlined Pick Slip Generation (WSPS) for instructions.
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the streamlined pick slip generation process does not generate pick slips. See that system control value for more information.
Working with forms: See Forms Management (My Forms) for information on displaying or printing pick slips and other forms.
Note: The information presented here is included on your pick slip only if your print program supports it. The Pick Printing Program (C37) system control value identifies the pick slip printing program to use. The standard graphical pick printing program is PICKG. You would use this program if you print pick slips onto plain paper and want the pick printing program to include your logo and supply the text boxes and other graphical elements.
Sample pick slip: See the graphical pick slip sample.
Contents: The INPUT_TYPE setting defined for the PICK property for your pick slip form in Working with Customer Properties (PROP) indicates the means by which your pick slip printing program obtains the data to print on the pick slip form. Each option is available only if your pick slip printing program supports it. Valid values are:
• XML = The program uses the Pick Message from Order Management System (CWPickOut) to generate the pick slip.
• DB = The program queries the database to generate the pick slip. The INPUT_TYPE setting for the standard printing program PICKG is DB.
|
Logo |
You can include a company logo or an entity logo. See Setting Up Company Logos for Forms and the Print Entity Image (K35) system control value for background and setup information. |
|
Ship via Indicia Description (unlabeled) |
The first line of the indicia description if a ship via indicia applies. From the indicia_desc attribute in the Pick Message from Order Management System (CWPickOut) or the SVI description 1 field in the Ship Via Indicia table. See the Work with Ship Via Indicia Screen for more information. |
|
Ship Via Indicia Number (unlabeled) |
The indicia number specified for the ship via indicia, if any. From the indicia attribute in the Pick Message from Order Management System (CWPickOut) or the SVI number field in the Ship Via Indicia table. See the Work with Ship Via Indicia Screen for more information. |
|
Order Number and Ship To Number (unlabeled) |
The order number and the ship-to number, separated by a hyphen. The ship to number is set to 1 if there is only one shipping address. From the order_nbr and order_shipto_nbr attributes in the Pick Message from Order Management System (CWPickOut) or the Order # and Ship to # fields in the Pick Control Header table. |
|
Billing Batch Number (unlabeled) |
The billing batch number assigned to the pick slip. The system assigns a billing batch number to a pick slip generation run; you can use the billing batch number to confirm all of the pick slips in the batch at one time. From the billing_batch_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Billing batch # field in the Pick Control Header table. |
|
Barcode |
Formatted as 012-0003702-02, where 012 is the company number, 0003702 is the pick control number, and 02 is the label number. The BARCODE_IMAGE value for the PICKG (graphical pick slip) setting in Working with Customer Properties (PROP) controls whether the system prints a barcode on the pick slip. From the CMP Company, PCH Control #, and PCL Label Number fields in the Pick Control Label table. |
|
Generation Date (unlabeld) |
The date the pick slip was generated. From the date_printed attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Date printed field in the Pick Control Header table. |
|
Ordered By |
The sold-to name and address is enclosed in a rounded box on the base graphical pick slip. Includes the following: • Company name: The company name for the address of the sold to customer. From the sold_to_company attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Company name field in the Customer Sold To table. • First name, middle initial, last name: The first name, middle initial, and last name of the sold to customer. From the sold_to_fname, sold_to_initial, and sold_to_lname attributes in the Pick Message from Order Management System (CWPickOut) or the NAM First name, NAM Initial, and NAM Last name fields in the Customer Sold To table. • Address line 1 and Apartment: The street address and apartment for the address of the sold to customer. From the sold_to_addr1 and sold_to_apt attributes in the Pick Message from Order Management System (CWPickOut) or the NAM Street address and NAM Apartment fields in the Customer Sold To table. • Address line 2: The second address line for the address of the sold to customer. From the sold_to_addr2 attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Address line 2 field in the Customer Sold To table. • Note: Address lines 3 and 4 do not print on the pick form. • City, state, postal code: The city, state code, and zip code for the address of the sold to customer. From the sold_to_city, sold_to_state, and sold_to_postal_code attributes in the Pick Message from Order Management System (CWPickOut) or the NAM City, NAM State, and NAM Zip fields in the Customer Sold To table. • Country description: The country name for the address of the sold to customer. From the sold_to_country_name attribute in the Pick Message from Order Management System (CWPickOut) or the Country description field in the Country table. Note: The country name prints only if you are shipping to a country other than the default specified in the Default Country for Customer Address (B17) system control value. |
|
Pick slip message (unlabeled) |
A message that prints on all pick slips in the pick slip generation batch. You can enter a pick slip message in the Pick message code/text field for a pick slip generation template. From the msg attribute in the Pick Message from Order Management System (CWPickOut) for msg_type PM or the PSM Message line 1, PSM Message line 2, and PSM Message line 3 fields in the Pick Slip Message table. |
|
Pick Slip Ship To Label A separate pick slip prints for each ship to customer on the order. |
|
|
Logo |
See Setting Up Company Logos for Forms for setup information. |
|
Ship Via Indicia Description (unlabeled) |
The first line of the indicia description if a ship via indicia applies. From the indicia_desc attribute in the Pick Message from Order Management System (CWPickOut) or the SVI description 1 field in the Ship Via Indicia table. See the Work with Ship Via Indicia Screen for more information. |
|
Ship Via Indicia Number (unlabeled) |
The indicia number specified for the ship via indicia, if any. From the indicia attribute in the Pick Message from Order Management System (CWPickOut) or the SVI number field in the Ship Via Indicia table. See the Work with Ship Via Indicia Screen for more information. |
|
Barcode |
Formatted as 012-0003702-02, where 012 is the company number, 0003702 is the pick control number, and 01 is the label number. The BARCODE_IMAGE value for the PICKG (graphical pick slip) setting in Working with Customer Properties (PROP) controls whether the system prints a barcode on the pick slip. From the CMP Company, PCH Control #, and PCL Label Number fields in the Pick Control Label table. |
|
Order Number and Ship To Number (unlabeled) |
The order number and the ship-to number, separated by a hyphen. The ship to number is set to 1 if there is only one shipping address. From the order_nbr and order_shipto_nbr attributes in the Pick Message from Order Management System (CWPickOut) or the Order # and Ship to # fields in the Pick Control Header table. |
|
B# (Billing Batch Number and Cart Batch Number) |
The billing batch number assigned by the system to a group of pick slips and the cart batch number assigned to the pick slip. See Using Cart/Bin Picking. From the billing_batch_nbr and cart_batch_nbr attributes in the Pick Message from Order Management System (CWPickOut) or the PCH Billing batch # and PCH Cart batch # fields in the Pick Control Header table. |
|
Ship To ship to name and address |
The ship to name and address can be an order-level shipping address, a permanent customer ship to address, a recipient sold to customer, or the sold to customer on the order. See Assigning an Order Shipping Address, Using a Permanent Shipping Address in Order Entry, Adding a Recipient Order in Order Entry, and Entering Orders for more information. Includes the following: • Company: The company name for the address of the ship to customer on the pick. From the ship_to_company attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Company name in the Pick Control Header table. • First name, middle initial, last name: The first name, middle initial, and last name of the ship to customer on the pick. From the ship_to_fname, ship_to_initial, and ship_to_lname attributes in the Pick Message from Order Management System (CWPickOut) or the NAM First Name, NAM Initial, and NAM Last Name fields in the Pick Control Header table. • Address line 1 and Apartment: The street address and apartment for the address of the ship to customer on the pick. From the ship_to_addr1 and ship_to_apt attributes in the Pick Message from Order Management System (CWPickOut) or the NAM Street Address and NAM Apartment fields in the Pick Control Header table. • Address line 2: The second address line for the address of the ship to customer on the pick. From the ship_to_addr2 attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Address Line 2 field in the Pick Control Header table. • Note: Address lines 3 and 4 do not print on the pick form. • City, state, postal code: The city, state code, and zip code for the address of the ship to customer on the pick. From the ship_to_city, ship_to_state, and ship_to_postal_code attributes in the Pick Message from Order Management System (CWPickOut) or the NAM City, NAM State, and NAM Postal Code Scan fields in the Pick Control Header table. |
|
|
• Country description: The country name for the address of the ship to customer on the pick. From the ship_to_country_name attribute in the Pick Message from Order Management System (CWPickOut) or the Country description field in the Country table. Note: The country description prints only if you are shipping to a country other than the default specified in the Default Country for Customer Address (B17) system control value. If the Default Country for Customer Address (B17) system control value is blank and the country for the ship to address is the United States of America, the system truncates the country to United States of. • Attention: The label Attention displays followed by the information entered in the Attention field on the order header. The Attention label does not display if information is not entered in the Attention field on the order header. |
|
Generation Date (unlabeled) |
The date the pick slip was generated. From the date_printed attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Date printed field in the Pick Control Header table. |
|
Customer # |
The number assigned by the system to identify the sold-to customer on the order. From the sold_to_customer_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the CST Customer # field in the Pick Control Header table. |
|
Ship Via Description (unlabeled) |
The first 10 positions of the ship via description, such as UPS or Fed Ex. From the ship_via_desc attribute in the Pick Message from Order Management System (CWPickOut) or the VIA Shipper Name field in the Ship Via table. |
|
Order Level Message |
The first four order level messages on the order whose Print flag is set to Print on Both or Print on Picks. See the Work with Order Messages Screen for more information on order level messages. From the msg attribute in the Pick Message from Order Management System (CWPickOut) for msg_type OH or the OMS Message field in the Order Message table. |
|
Pick Slip Header Information |
|
|
Date Of Order |
The date the order was placed. From the order_date attribute in the Pick Message from Order Management System (CWPickOut) or the OHD Order date field in the Order Header table. |
|
Purchase Order No. |
The purchase order number, if any, that was provided by the sold-to customer. You can enter a purchase order number on the Work with Order screen in order entry. From the po_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the PCH PO # field in the Pick Control Header table. |
|
Source Code |
The source code from the order header. From the source attribute in the Pick Message from Order Management System (CWPickOut) or the OHD SRC Source code field in the Order Header table. |
|
Packer |
Not currently implemented. |
|
Shipped Via |
The first 10 positions of the ship via description, such as UPS or Fed Ex. From the ship_via_desc attribute in the Pick Message from Order Management System (CWPickOut) or the VIA Shipper Name field in the Ship Via table. |
|
Customer No. |
The number assigned by the system to identify the sold-to customer. From the sold_to_customer_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the CST Customer # field in the Pick Control Header table. |
|
Order No. |
The order number associated with the pick slip. From the order_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the Order # field in the Order Ship To table. |
|
Page No. |
The number of this pick slip page. |
|
Pick Slip Detail Information The system uses the Pick Location table to determine the sequence in which to display the pick slip details on the pick slip. Pick slip details print on the pick slip in zone, location picking sequence number, location, line number sequence. |
|
|
Line No. |
A unique number to identify the pick slip line number for the item. From the pick_line_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Line # field in the Pick Control Detail table. |
|
Items Ordered |
The number of units ordered on the order line. From the qty_ordered attribute in the Pick Message from Order Management System (CWPickOut) or the ODT qty ordered field in the Order Detail table. |
|
Items Shipped |
The quantity of the item to ship on this pick slip. Note: The system highlights the quantity if it is greater than 1. From the qty_printed attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Original qty printed field in the Pick Control Detail table. |
|
Back Ordered |
The quantity of the item that is currently unavailable. A backorder quantity displays if the item in on backorder, held, a drop ship item, or a future arrival item. From the qty_bo attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Qty Backordered field in the Pick Control Detail table. Drop ship items: The pick slip lists drop ship items as backordered until you generate a drop ship pick slip or purchase order for the drop ship items. However, the pick slip still lists drop ship items as backordered even after a drop ship pick slip or purchase order has been generated for the drop ship items if the Add Printed Drop Ship Lines as Backordered on Pick (E93) system control value is selected. Held lines: Order lines that are held are listed as backordered. You can put an item on hold by selecting the Hold option at the Work with Order Line Screen (Changing/Adding an Item) or by Putting a Line on Hold through a Special Handling Format. |
|
Location Code |
The location in the warehouse where the item is picked. Included only for items shipping on this pick slip. Non-inventory and main set items: The system prints a location for non-inventory and main set items if a primary location is defined for the item. From the whse_location attribute in the Pick Message from Order Management System (CWPickOut) or the Location field in the Pick Location table. |
|
Item Number |
A code that represents a unit of inventory. A SKU code, such as RED MEDM, prints below the item number if the item contains SKUs. Note: The item may have been ordered using a different item number if it is part of a set, or if it was ordered by alias. From the item and sku attributes in the Pick Message from Order Management System (CWPickOut) or the ITM Number and SKU Code in the Pick Control Detail table. Set items: If the main set item or its component items are flagged as ship alone items, a separate pick slip prints for each item included in the set with the message **Other Items Shipped Separately**. The system includes the main set item with a component item that is assigned to the same ship via in order to avoid printing the main set item on its own pick slip. If the main set item and its component items are not flagged to ship alone, the main set item and components print on the same pick slip as the other items. The total for the set prints on one pick slip. For more information on set items, see Entering Set Information (WSET). Gift wrap: The message GIFT WRAP prints on a separate line if the item is flagged for gift wrap. The gift wrap charge is indicated in the Unit price and Extension columns. Special handling instructions: A detailed description of any special handling option, such as color, material, monogramming, engraving, style, or size prints underneath any item to receive special handling. The special handling charge is included in the Shipping & Handling total on the pick slip. Custom special handling information that prints on the pick slip is the special handling option, the customer response, and the special handling charge. Standard special handling instructions are preceded by the description of the additional charge code you use to identify standard special handling. Item or SKU comments: Only comments flagged to Print on picks and invoices or Print on picks only print on the pick slip. Comments can be entered at the base item level or SKU level by selecting Comments for an item at the Work with Items Screen. Order line message: Order line messages flagged to Print on Both or Print on Picks print on the pick slip. You can enter an order line message by selecting Messages for an item at the Work with Order Lines screen. |
|
Description |
A description of the item. A description of the SKU is also included if the item contains SKUs. From the item_desc and sku_desc attributes in the Pick Message from Order Management System (CWPickOut) or the Description field in the Item table and Description field in the SKU table. |
|
Unit Price |
The amount the customer pays for each unit of the item. Included only for items on this pick slip. Not included on pick slips for gift orders. From the selling_price attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Price field in the Pick Control Detail table. |
|
Extension |
The item price times the quantity shipped on this pick slip. Not included on pick slips for gift orders. From the selling_price_extended attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Extension field in the Pick Control Detail table. |
|
Shipped Separately Message |
The message **Other Items Shipped Separately** prints above the pick slip totals if other items on the order shipped on a separate pick slip. See Splitting an Order Across Multiple Picks for more information on when the system splits an order into more than one pick. |
|
Pick Slip Totals Pick slip totals print at the bottom of every page of a multi-page pick slip. No totals print on pick slips for gift orders. |
|
|
Total Merchandise |
The total merchandise value of all items shipping on the pick slip, after applying any discounts or repricing. This total does not include backordered, held, or drop ship items, even if they are printed on the pick slip, because they are not included in this shipment. Also, this total does not include canceled or soldout items, items shipped separately, or items with allocation stock errors. From the merch_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Merch field in the Pick Control Header table. |
|
Shipping/Handling |
The total shipping and handling for this shipment, including any freight, additional freight, duty, additional charges, and special handling. If the Prorate Freight Charges (D39) system control value is unselected, the system charges all freight charges on an order with the first shipment; in this situation, all freight charges are added to the first pick slip generated for the order. If the Prorate Freight Charges (D39) system control value is selected, the system charges a proportional amount of freight for partial shipments on an order. However, if the Prorate Freight Charges (D39) system control value is selected and all of the items on the order are exempt from freight, the system applies any item and weight charges defined for the ship via to the first pick slip generated for the order. Note: If a negative additional charge is applied to the order, the system deducts the amount from the shipping and handling total. Note: From the freight_amt + addl_freight_amt + addl_charge_amt + hand_charge_amt attributes in the Pick Message from Order Management System (CWPickOut) or the PCH Freight + PCH Add’l Freight + PCH Add’l Charges + PCH Handling fields in the Pick Control Header table. |
|
Sales Tax |
The total tax for all items shipping on the pick slip. This total may include tax on shipping and handling, additional charges, and GST (Goods and Service tax) and PST (Provincial Service tax) tax rates which are specific to companies that operate in Canada and orders shipped to and within Canadian boundaries. For more information on GST and PST tax rates, see Setting Up Order Entry Values. Note: Sales tax does not include VAT (Value Added Tax), a taxing method that applies in only certain states and countries and includes the tax in the price of the item. For more information on VAT, see the description of the Tax Included in Price (E70) system control value. From the tax_amt + gst_amt + pst_amt attributes in the Pick Message from Order Management System (CWPickOut) or the PCH Tax + PCH GST + PCH PST fields in the Pick Control Header table. |
|
Order Total |
Total merchandise, shipping and handling, additional charges, and tax, for this shipment. From the total_order_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Total Order Amount field in the Pick Control Header table. |
|
Total Paid |
The amount the customer prepaid. This total is zero if the customer used a credit card payment method. From the amt_paid attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Amount Paid field in the Pick Control Header table. |
|
Refund |
The amount you owe the customer if the prepaid amount is more than the amount due. If this amount is greater than zero, *Refund Due* displays above the field. From the balance_due_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Balance Due field in the Pick Control Header table. |
|
Bal. Due |
The amount the customer owes you if the prepaid amount is less than the amount due. This amount is zero if the total balance was prepaid or a credit card was applied to the order. If this amount is greater than zero, *Balance Due* displays above the field. From the balance_due_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Balance Due field in the Pick Control Header table. |
|
Total |
Total merchandise, shipping and handling, tax, and additional charges. From the total_order_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Total Order Amount field in the Pick Control Header table. |
|
Order Barcode |
Formatted as 012-00000306-01, where 012 is the company number, 00000306 is the order number, and 01 is the ship to number. The ORDER_BARCODE_IMAGE value for the PICKG (graphical pick slip) setting in Working with Customer Properties (PROP) controls whether the system prints an order barcode on the pick slip. |
Gift order: You can define an order as a gift order by selecting the Gift field on the Work with Order screen in Order Entry. When you generate pick slips for the order, the system also generates a gift acknowledgement for the sold-to customer, with the message ****Gift Acknowledgement**** after all of the items. See the Gift Acknowledgement for more information.
Cart/Bin Batch Picking Pullsheet
How to print: The system generates this list when you generate pick slips if you are Using Cart/Bin Picking (the Use Cart/Bin Picking? (B38) system control value is selected) and a print program has been defined in the Cart/Bin Batch Pull Sheet Printing Program (C39) system control value.
Note: The information presented here is included on your picking pullsheet only if your print program supports it. The Cart/Bin Batch Pull Sheet Printing Program (C39) system control value identifies the picking pullsheet print program to use. The base print program is JFLR0393.
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the streamlined pick slip generation process does not generate this report. See that system control value for more information.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents: This report page breaks on cart batch number. Within cart batch number, the report sorts items to pick in zone, pick sequence number, location, item/SKU, pick control number sequence.
Picking Pullsheet Header:
• Warehouse: A code for the warehouse where the items are located. From the Warehouse field in the Pick Sort GH table.
• Batch/Cart #: The billing batch number is a system-generated number assigned to each pick slip run. The cart batch number is a system-generated number assigned to each cart for cart/bin picking. From the Billing batch # and Cart batch # fields in the Pick Sort GH table.
• Total Cube: The cube size of all of the items in the specified cart, calculated based on the per-unit cube factor defined for each item or SKU. The system sums the Cube of Pick field for all records in the Pick Sort GH table for the specified Cart batch #.
• Total Picks: The total number of picks associated with the cart. Based on the number of records in the Pick Sort GH table for the specified Cart batch #.
• Total Lines: The total number of separate lines associated with the cart, each line for one or more units of an item. Based on the number of records in the Pick Location table for the specified Cart Batch #.
• Total Units: The total number of units associated with the cart. The system sums the Qty Allocated field for all records in the Pick Location table for the specified Cart Batch #.
• Bin Number: The cart bin number assigned to one or more of the items on the cart. From the Cart bin # field in the Pick Location table for the specified Cart Batch #.
• Slots Needed: The number of slots required to pick the items on the cart. From the PGH Nbr of Bins field in the Pick Sort GH table.
• Control Number: The pick control number associated with the cart. From the PCH Control # field in the Pick Sort GH table for the specified Cart Batch #.
• Order Number: The order number and ship to number associated with the cart. From the Order # and Ship to # fields in the Pick Control Header table for the specified Cart Batch #.
• Order Line Message: Any order line messages that are flagged to print on the pick prints above the report details, preceded by the line number and item and SKU codes. From the Message field in the Order Line Message table whose Print field is P or B.
Picking Pullsheet Details:
• Location: The location in the warehouse where the item should be picked. From the Location field in the Pick Location table, or if not defined (for example, a non-inventory item), from the Location field in the SKU table.
• Total For Location: The total number of units of the item to pick from the location. From the PDL Qty Allocated field in the Pick Location table. Note: The system highlights the total if it is greater than 1.
• Order Quantity: The original quantity ordered for the order detail line. From the PCD Qty Ordered field in the Pick Control Detail table. Note: The system highlights the quantity if the Total For Location is greater than 1.
• Bin Number: The cart bin number assigned to the item. From the Cart bin # field in the Pick Location table. Note: The system highlights the bin number if the Total For Loc is greater than 1.
• Item: The item and SKU to pick. From the ITM Number and SKU Code fields in the Pick Location table.
• Item Description: The first 25 characters of the item description. From the Description field in the Item table.
• Control Number: The pick control number associated with the cart. From the PCH Control # field in the Pick Location table for the specified Cart Batch #.
• Order Number: The order number and ship to number associated with the cart. From the Order # and Ship to # fields in the Pick Location table for the specified Cart Batch #.
• Cart Batch Number: The billing batch number is a system-generated number assigned to each pick slip run. The cart batch number is a system-generated number assigned to each cart for cart/bin picking. The cart number is used to sort pull sheets. From the Billing batch # and Cart batch # fields in the Pick Location table.
• Billing Batch #: The billing batch number assigned to the pick slip run. From the Billing batch # field in the Pick Location table.
• Totals:
• Total Cube: The total cube of all of the items associated with the billing batch # that print on this report. The system sums the Cube of Pick field for all records in the Pick Sort GH table that print on the report for the specified Billing batch #.
• Total Picks: The total number of picks associated with the billing batch # that print on this report. Based on the number of records in the Pick Sort GH table that print on the report for the specified Billing batch #.
• Total Lines: The total number of lines associated with the billing batch # that print on this report. Based on the number of records in the Pick Location table that print on the report for the specified Billing Batch #.
• Total Units: The total number of units associated with the billing batch # that print on this report. The system sums the Qty Allocated field for all records in the Pick Location table that print on the report for the specified Billing Batch #.
• Special Handling Status: Y prints if the entire batch of pick slips consists of special handling items.
How to print: The system generates this list when you generate pick slips if you are NOT Using Cart/Bin Picking (the Use Cart/Bin Picking? (B38) system control value is unselected) and a print program has been defined in the Batch Pull Sheet Printing Program (C38) system control value.
Note: The information presented here is included on your picking pullsheet only if your print program supports it. The Batch Pull Sheet Printing Program (C38) system control value identifies the picking pullsheet print program to use. The base print program is JFLR0397.
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the streamlined pick slip generation process does not generate this report. See that system control value for more information.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents: This report sorts items to pick in billing batch number, location, item/SKU sequence.
• Warehouse: A code for the warehouse where the items are located. From the Warehouse field in the Pick Location table.
• Billing Batch #: The billing batch number assigned to the pick slip run. From the Billing batch # field in the Pick Location table.
• Location: The location in the warehouse where the item should be picked. From the Location field in the Pick Location table, or if not defined (for example, a non-inventory item), from the Location field in the SKU table.
• Total For Location: The total number of units of the item to pick from the location. From the Qty Allocated field in the Pick Location table.Note: The system highlights the total if it is greater than 1.
• Order Quantity: The original quantity ordered for the order detail line. From the PCD Qty Ordered field in the Pick Control Detail table. Note: The system highlights the quantity if the Total For Loc is greater than 1.
• Item: The item and SKU to pick. From the ITM Number and SKU Code fields in the Pick Location table.
• Item Description: The first 25 characters of the item description. From the Description field in the Item table.
• Control Number: The pick control number. From the PCH Control # field in the Pick Sort GH table.
• Order Number: The order number and ship to number associated with the pick slip. From the Order # and Ship to # fields in the Pick Sort GH table.
Item Stock Allocation Error Report
Purpose: This report lists items that were ordered but not picked and the reason why the inventory was not picked. The Item Stock Allocation Error report sorts by warehouse/location/item/error sequence.
Possible errors on the Item Stock Allocation Error report include:
• Itm whs rsv frz (item warehouse reservation freeze)
• Itm loc rsv frz (item location reservation freeze)
• Loc unpickable (location is not a pickable location; for example a temporary location)
• Loc frozen (location freeze)
• No stock in pck (no stock in pickable location)
• No prime loc (no primary location specified on the item/SKU)
• Neg pend qty (negative pending quantity exists)
If an item or order has multiple locations that cannot be selected: If an item or order has multiple locations that cannot be picked, the system includes the item/order multiple times on the report in warehouse/location sequence.
How to print: The system generates this report when you generate pick slips if you have items on the orders which are not printed. See Performing Pick Slip Generation for more information.
For more information: See the sample report in PDF format.
Contents:
• Warehouse: The warehouse where the item stock allocation error exists.
• Billing batch number
• Location: The location where the item stock allocation error exists; if the system tried to allocate from more than one location, but could not allocate stock from any of the locations, the system prints each location where the allocation error occurred.
• Item stock allocation error description: See Item Stock Allocation Errors for a list of possible errors.
• Pick number
• Order number
• Item/SKU
• Order quantity: This is the quantity reserved on the order, not the quantity ordered.
• Available quantity: The total available across all locations for the specific warehouse, item and SKU.
How to print: The system prints a batch item pull label when you are Generating and Printing Pick Slips if a print program name has been defined in the Batch Item Pull Label Printing Program (F63) system control value. See Performing Pick Slip Generation for more information on generating pick slips.
A label prints for each item/location in the pick ticket batch, sorted in location/item sequence, so pickers can attach the label to the picking cart. Once the batch item pull labels are attached to the picking cart, the packers can pick from the cart to fulfill each order. If you use a unique print program, the information in the sample will be included on your labels only if your unique print program supports the information.
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the streamlined pick slip generation process does not generate these labels. See that system control value for more information.
The base batch item pull label print program is FLR0747.
For more information: See the sample report in PDF format.
Contents:
• the date the label printed
• the quantity to pick
• location
• first 5 positions of the item number
• first 4 positions of the SKU
• item description
• SKU description
Batch Pull Sheet Item Summary Report
How to print: The system generates this report when you generate pick slips if the Print Batch Pull Sheet Item Summary (C59) system control value is selected. See Performing Pick Slip Generation for more information on generating pick slips.
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the streamlined pick slip generation process does not generate this report. See that system control value for more information.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Selected/Unselected field: Select to print the Batch Pull Sheet Item Summary report automatically when printing pick slips. This report lists the items, picking locations, total quantity to pick, and item descriptions for each item printed on the pick slips.
This is a convenient way of picking the total quantity required of a single item from a location without first sorting through all pick slips containing this item.
Deselect if you do not wish to print this report when printing pick slips.
Contents:
• Warehouse
• Billing Batch #
• Item # and SKU
• Location
• Quantity to Pick
• Description
Invalid ship via: The system includes pick slips that did not generate due to invalid ship via on this report.
Purpose: This report summarizes the number of pick slips, units, and total dollar value of single-line and multi-line pick slips in a billing batch.
How to print: The system generates this report automatically when you generate pick slips. See Performing Pick Slip Generation for more information on generating pick slips. (Note: There is no other way to generate this report, or reprint it after you generate pick slips.)
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the streamlined pick slip generation process does not generate this report. See that system control value for more information.
For more information: See the sample report in PDF format.
Contents:
• Pick Template: The name of the pick slip generation template used to generate the pick slips.
• Billing Batch #: The billing batch number for the pick slip run.
• Total Picks: The total number of pick slips printed for the billing batch. This total does not include memberships, non-inventory items and subscriptions, since these types of items bill automatically when you generate pick slips and do not actually appear on printed pick slips. This total does not include virtual stored value card items. See Performing Initial Item Entry (MITM) for more information on these types of items.
• Units/All Picks: The total number of units on all items for the printed pick slips.
This total includes:
• regular items
• components of set items
• accompanying items; set up through the Work with Accompanying Item Screen).
• promotional inserts set up through Package Insert Processing (WPIP) if they are inventory items
This total does not include:
• main set items
• non-inventory items Note: The system includes any dollar value for non-inventory items in the correct Value buckets.
• promotional inserts set up through Package Insert Processing (WPIP) if they are non-inventory items
• virtual stored value card items
• memberships
• subscriptions
• Value/All Picks: The total dollar value of all the printed pick slips, including all tax, charges, freight, and handling. This total is calculated the same way as the total number of pick slips in the batch.
• Single Line Picks: The total number of pick slips consisting of a single order line. This total is calculated the same way as the total number of pick slips in the batch.
• Units/Single Line Picks: The total number of units on single-line pick slips. This total is calculated the same way as the total number of units for the batch.
• Value/Single Line Picks: The total dollar value of all single-line pick slips. This total is calculated the same way as the total dollar value of the batch.
• Multi Line Picks: The total number of pick slips consisting of more than one order line. This total is calculated the same way as the total number of pick slips in the batch.
• Units/Multi Line Picks: The total number of units on multi-line pick slips. This total is calculated the same way as the total number of units for the batch.
• Value/Multi Line Picks: The total dollar value of multi-line pick slips. This total is calculated the same was as the total dollar value of the batch.
Invalid ship via: The system includes pick slips that did not generate due to invalid ship via on this report.
How to print: Generated through:
• Streamlined Pick Slip Generation (WSPS) and Selecting Vendors for Drop Ship Processing (MDSP) (drop ship pick slips) if the Automatic Generation of Gift Acknowledgement (B92) system control value is set to P.
• billing if the Automatic Generation of Gift Acknowledgement (B92) system control value is set to B.
See the Automatic Generation of Gift Acknowledgement (B92) system control value for more information.
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, no gift acknowledgements are generated through the streamlined pick slip generation process or through billing async. See that system control value for more information.
What if there are multiple pick slips for a gift order? The system generates a separate gift acknowledgement for each generated pick slip, so if some items on the order ship separately, both a separate pick slip and a separate gift acknowledgement are generated. Similarly, if you print drop ship pick slips for any items on the order, the system generates a separate drop ship pick slip for the items on the drop ship pick slip.
File naming: The system uses the print program, the user ID of the person who started the async jobs, the job date and time stamp, and the document sort number to name the gift acknowledgement PDF file. For example, a file named GIFTACKG.KBROWN.20090828.163639681_002.pdf indicates this is a gift acknowledgement PDF document generated by user KBROWN on August 28, 2009 and the document is the second document for a specific gift acknowledgement sort. Note: The user ID of the person who started the async jobs may not be the user ID of the person who generated pick slips or billed the order associated with the gift acknowledgement.
Sorting gift acknowledgements into separate PDF files: The PICKS_IN_SPOOL_FILE setting in Working with Customer Properties (PROP) indicates the maximum number of gift acknowledgement in a single PDF document. If the number of gift acknowledgements in a PDF document reaches the number defined in the PICKS_IN_SPOOL_FILE setting, the system creates a new PDF document.
Working with forms: See Forms Management (My Forms) for information on displaying gift acknowledgements and other forms.
Note: The information presented here is included on your gift acknowledgement only if your print program supports it. The Gift Order Acknowledgement Print Program (B90) system control value identifies the gift acknowledgement printing program to use. The standard graphical gift acknowledgement printing program is GIFTACKG. You would use this program if you print gift acknowledgement onto plain paper and want the gift acknowledgement printing program to include your logo and supply the text boxes and other graphical elements.
Sample gift acknowledgements: See the graphical gift acknowledgement sample .
Contents: The INPUT_TYPE setting for your gift acknowledgement form in Working with Customer Properties (PROP) indicates the means by which your gift acknowledgement printing program obtains the data to print on the form. Each option is available only if your gift acknowledgement program supports it. Valid values are:
• XML = The program uses the Pick Message from Order Management System (CWPickOut) to generate the gift acknowledgement.
• DB = The program queries the database to generate the gift acknowledgement. The INPUT_TYPE setting for the standard printing program GIFTACKG is DB.
|
Gift Acknowledgement Sold To Label (ORDERED BY) |
|
|
Logo |
Company logo. See Setting Up Company Logos for Forms for setup information. The gift acknowledgement does not include an entity logo regardless of the setting of the Print Entity Image (K35) system control value. |
|
Order Number and Ship To Number |
The order number and the ship-to number, separated by a hyphen. The ship to number is set to 1 if there is only one shipping address. From the order_nbr and order_shipto_nbr attributes in the Pick Message from Order Management System (CWPickOut) or the Order # and Ship to # fields in the Pick Control Header table. |
|
Billing Batch Number |
The billing batch number assigned to the associated pick slip. The system assigns a billing batch number to a pick slip generation run; you can use the billing batch number to confirm all of the pick slips in the batch at one time. From the billing_batch_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Billing batch # field in the Pick Control Header table. |
|
Date |
The date the gift acknowledgement was generated. From the date_printed attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Date printed field in the Pick Control Header table. |
|
Sold To sold to name and address |
The sold-to name and address has the label ORDERED BY: and is enclosed in a rounded box on the base graphical gift acknowledgement. Includes the following: • Company name: The company name for the address of the sold to customer. From the sold_to_company attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Company name field in the Customer Sold To table. • First name, middle initial, last name: The first name, middle initial, and last name of the sold to customer. From the sold_to_fname, sold_to_initial, and sold_to_lname attributes in the Pick Message from Order Management System (CWPickOut) or the NAM First name, NAM Initial, and NAM Last name fields in the Customer Sold To table. • Address line 1 and Apartment: The street address and apartment for the address of the sold to customer. From the sold_to_addr1 and sold_to_apt attributes in the Pick Message from Order Management System (CWPickOut) or the NAM Street address and NAM Apartment fields in the Customer Sold To table. • Address line 2: The second address line for the address of the sold to customer. From the sold_to_addr2 attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Address line 2 field in the Customer Sold To table. • Note: Address lines 3 and 4 do not print on the pick form. • City, state, postal code: The city, state code, and zip code for the address of the sold to customer. From the sold_to_city, sold_to_state, and sold_to_postal_code attributes in the Pick Message from Order Management System (CWPickOut) or the NAM City, NAM State, and NAM Zip fields in the Customer Sold To table. • Country description: The country name for the address of the sold to customer. From the sold_to_country_name attribute in the Pick Message from Order Management System (CWPickOut) or the Country description field in the Country table. Note: The country name prints only if you are shipping to a country other than the default specified in the Default Country for Customer Address (B17) system control value. |
|
Gift Acknowledgement Ship To Label |
|
|
Logo |
Company logo. See Setting Up Company Logos for Forms for setup information. |
|
Order Number and Ship To Number |
The order number and the ship-to number, separated by a hyphen. The ship to number is set to 1 if there is only one shipping address. From the order_nbr and order_shipto_nbr attributes in the Pick Message from Order Management System (CWPickOut) or the Order # and Ship to # fields in the Pick Control Header table. |
|
Billing Batch Number and Cart Number |
The billing batch number assigned by the system to a group of pick slips and the cart batch number assigned to the associated pick slip. See Using Cart/Bin Picking. From the billing_batch_nbr and cart_batch_nbr attributes in the Pick Message from Order Management System (CWPickOut) or the PCH Billing batch # and PCH Cart batch # fields in the Pick Control Header table. |
|
Ship To ship to name and address |
The ship to name and address can be an order-level shipping address, a permanent customer ship to address, a recipient sold to customer, or the sold to customer on the order. See Assigning an Order Shipping Address, Using a Permanent Shipping Address in Order Entry, Adding a Recipient Order in Order Entry, and Entering Orders for more information. Includes the following: • Company: The company name for the address of the ship to customer. From the ship_to_company attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Company name in the Pick Control Header table. • First name, middle initial, last name: The first name, middle initial, and last name of the ship to customer. From the ship_to_fname, ship_to_initial, and ship_to_lname attributes in the Pick Message from Order Management System (CWPickOut) or the NAM First Name, NAM Initial, and NAM Last Name fields in the Pick Control Header table. • Address line 1 and Apartment: The street address and apartment for the address of the ship to customer. From the ship_to_addr1 and ship_to_apt attributes in the Pick Message from Order Management System (CWPickOut) or the NAM Street Address and NAM Apartment fields in the Pick Control Header table. • Address line 2: The second address line for the address of the ship to customer. From the ship_to_addr2 attribute in the Pick Message from Order Management System (CWPickOut) or the NAM Address Line 2 field in the Pick Control Header table. • Note: Address lines 3 and 4 do not print on the pick form. • City, state, postal code: The city, state code, and zip code for the address of the ship to customer. From the ship_to_city, ship_to_state, and ship_to_postal_code attributes in the Pick Message from Order Management System (CWPickOut) or the NAM City, NAM State, and NAM Postal Code Scan fields in the Pick Control Header table. • Country description: The country name for the address of the ship to customer. From the ship_to_country_name attribute in the Pick Message from Order Management System (CWPickOut) or the Country description field in the Country table. Note: The country description prints only if you are shipping to a country other than the default specified in the Default Country for Customer Address (B17) system control value. If the Default Country for Customer Address (B17) system control value is blank and the country for the ship to address is the United States of America, the system truncates the country to United States of. |
|
Date |
The date the gift acknowledgement was generated. From the date_printed attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Date printed field in the Pick Control Header table. |
|
Customer # |
The number assigned by the system to identify the sold-to customer on the order. From the sold_to_customer_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the CST Customer # field in the Pick Control Header table. |
|
Ship via description |
The first 10 positions of the ship via description, such as UPS or Fed Ex. From the ship_via_desc attribute in the Pick Message from Order Management System (CWPickOut) or the VIA Shipper Name field in the Ship Via table. |
|
Order Level Message |
The first four order level messages on the order whose Print flag is set to Print on Both or Print on Picks. See the Work with Order Messages Screen for more information on order level messages. From the msg attribute in the Pick Message from Order Management System (CWPickOut) for msg_type OH or the OMS Message field in the Order Message table. |
|
Gift Acknowledgment Header Information |
|
|
Date of Order |
The date the order was placed. From the order_date attribute in the Pick Message from Order Management System (CWPickOut) or the OHD Order date field in the Order Header table. |
|
Purchase Order No. |
The purchase order number, if any, that was provided by the sold-to customer. You can enter a purchase order number on the Work with Order screen in order entry. From the po_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the PCH PO # field in the Pick Control Header table. |
|
Source Code |
The source code from the order header. From the source attribute in the Pick Message from Order Management System (CWPickOut) or the OHD SRC Source code field in the Order Header table. |
|
Packer |
Not currently implemented. |
|
Shipped Via |
The first 10 positions of the ship via description, such as UPS or Fed Ex. From the ship_via_desc attribute in the Pick Message from Order Management System (CWPickOut) or the VIA Shipper Name field in the Ship Via table. |
|
Customer No. |
The number assigned by the system to identify the sold-to customer. From the sold_to_customer_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the CST Customer # field in the Pick Control Header table. |
|
Order No. |
The order number associated with the gift acknowledgement. From the order_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the Order # field in the Order Ship To table. |
|
Page No. |
The number of this gift acknowledgement page. |
|
Gift Acknowledgement Detail Information |
|
|
Line No. |
A unique number to identify the pick slip line number for the item. From the pick_line_nbr attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Line # field in the Pick Control Detail table. |
|
Items Ordered |
The number of units ordered on the order line. From the qty_ordered attribute in the Pick Message from Order Management System (CWPickOut) or the ODT qty ordered field in the Order Detail table. |
|
Items Shipped |
The quantity of the item to ship on this gift acknowledgement. From the qty_printed attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Original qty printed field in the Pick Control Detail table. |
|
Back Ordered |
The quantity of the item that is currently unavailable. A backorder quantity displays if the item in on backorder, held, a drop ship item, or a future arrival item. From the qty_bo attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Qty Backordered field in the Pick Control Detail table. Drop ship items: The gift acknowledgement lists drop ship items as backordered until you generate a drop ship pick slip or purchase order for the drop ship items. However, the gift acknowledgement still lists drop ship items as backordered even after a drop ship pick slip or purchase order has been generated for the drop ship items if the Add Printed Drop Ship Lines as Backordered on Pick (E93) system control value is selected. Held lines: Order lines that are held are listed as backordered. You can put an item on hold by selecting the Hold option at the Work with Order Line Screen (Changing/Adding an Item) or by Putting a Line on Hold through a Special Handling Format. |
|
Location Code |
The location in the warehouse where the item is picked. Included only for items shipping on this gift acknowledgement. From the whse_location attribute in the Pick Message from Order Management System (CWPickOut) or the Location field in the Pick Location table. |
|
Item Number |
A code that represents a unit of inventory. A SKU code, such as RED MEDM, prints below the item number if the item contains SKUs. Note: The item may have been ordered using a different item number if it is part of a set, or if it was ordered by alias. From the item and sku attributes in the Pick Message from Order Management System (CWPickOut) or the ITM Number and SKU Code in the Pick Control Detail table. Set items: If the main set item or its component items are flagged as ship alone items, a separate gift acknowledgement prints for each item included in the set with the message **Other Items Shipped Separately**. The system includes the main set item with a component item that is assigned to the same ship via in order to avoid printing the main set item on its own gift acknowledgement. If the main set item and its component items are not flagged to ship alone, the main set item and components print on the same gift acknowledgement as the other items. The total for the set prints on one gift acknowledgement. For more information on set items, see Entering Set Information (WSET). Gift wrap: The message GIFT WRAP prints on a separate line if the item is flagged for gift wrap. The gift wrap charge is indicated in the Unit price and Extension columns. Special handling instructions: A detailed description of any special handling option, such as color, material, monogramming, engraving, style, or size prints underneath any item to receive special handling. The special handling charge is included in the Shipping & Handling total on the gift acknowledgement. Custom special handling information that prints on the gift acknowledgement is the special handling option, the customer response, and the special handling charge. Standard special handling instructions are preceded by the description of the additional charge code you use to identify standard special handling. Item or SKU comments: Only comments flagged to Print on picks and invoices or Print on picks only print on the gift acknowledgement. Comments can be entered at the base item level or SKU level by selecting Comments for an item at the Work with Items Screen. Order line message: Order line messages flagged to Print on Both or Print on Picks print on the gift acknowledgement. You can enter an order line message by selecting Messages for an item at the Work with Order Lines screen. |
|
Description |
A description of the item. A description of the SKU is also included if the item contains SKUs. From the item_desc and sku_desc attributes in the Pick Message from Order Management System (CWPickOut) or the Description field in the Item table and Description field in the SKU table. |
|
Unit Price |
The amount the customer pays for each unit of the item. Included only for items on this gift acknowledgement. From the selling_price attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Price field in the Pick Control Detail table. |
|
Extension |
The item price times the quantity shipped on this gift acknowledgement. From the selling_price_extended attribute in the Pick Message from Order Management System (CWPickOut) or the PCD Extension field in the Pick Control Detail table. |
|
Gift Acknowledgment Message |
The message **** Gift Acknowledgement **** prints after all of the items on the gift acknowledgement. |
|
Shipped Separately Message |
The message **Other Items Shipped Separately** prints above the totals if other items on the order printed on a separate gift acknowledgement. See Splitting an Order Across Multiple Picks for more information on when the system splits an order into more than one pick. |
|
Gift Acknowledgment Totals Totals print on the last page of a multi-page gift acknowledgement. |
|
|
Total Merchandise |
The total merchandise value of all items shipping on the gift acknowledgement, after applying any discounts or repricing. This total does not include backordered, held, or drop ship items, even if they are printed on the gift acknowledgement, because they are not included in this shipment. Also, this total does not include canceled or soldout items, items shipped separately, or items with allocation stock errors. From the merch_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Merch field in the Pick Control Header table. |
|
Shipping/Handling |
The total shipping and handling for this shipment, including any freight, additional freight, duty, additional charges, and special handling. If the Prorate Freight Charges (D39) system control value is unselected, the system charges all freight charges on an order with the first shipment; in this situation, all freight charges are added to the first gift acknowledgement generated for the order. If the Prorate Freight Charges (D39) system control value is selected, the system charges a proportional amount of freight for partial shipments on an order. However, if the Prorate Freight Charges (D39) system control value is selected and all of the items on the order are exempt from freight, the system applies any item and weight charges defined for the ship via to the first gift acknowledgement generated for the order. Note: If a negative additional charge is applied to the order, the system deducts the amount from the shipping and handling total. Note: From the freight_amt + addl_freight_amt + addl_charge_amt + hand_charge_amt attributes in the Pick Message from Order Management System (CWPickOut) or the PCH Freight + PCH Add’l Freight + PCH Add’l Charges + PCH Handling fields in the Pick Control Header table. |
|
Sales Tax |
The total tax for all items shipping on the gift acknowledgement. This total may include tax on shipping and handling, additional charges, and GST (Goods and Service tax) and PST (Provincial Service tax) tax rates which are specific to companies that operate in Canada and orders shipped to and within Canadian boundaries. For more information on GST and PST tax rates, see Setting Up Order Entry Values. Note: Sales tax does not include VAT (Value Added Tax), a taxing method that applies in only certain states and countries and includes the tax in the price of the item. For more information on VAT, see the description of the Tax Included in Price (E70) system control value. From the tax_amt + gst_amt + pst_amt attributes in the Pick Message from Order Management System (CWPickOut) or the PCH Tax + PCH GST + PCH PST fields in the Pick Control Header table. |
|
Order Total |
Total merchandise, shipping and handling, additional charges, and tax, for this shipment. From the total_order_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Total Order Amount field in the Pick Control Header table. |
|
Total Paid |
The amount the customer prepaid. This total is zero if the customer used a credit card payment method. From the amt_paid attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Amount Paid field in the Pick Control Header table. |
|
Refund |
The amount you owe the customer if the prepaid amount is more than the amount due. From the balance_due_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Balance Due field in the Pick Control Header table. |
|
Bal Due |
The amount the customer owes you if the prepaid amount is less than the amount due. This amount is zero if the total balance was prepaid or a credit card was applied to the order. From the balance_due_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Balance Due field in the Pick Control Header table. |
|
Total |
Total merchandise, shipping and handling, tax, and additional charges. From the total_order_amt attribute in the Pick Message from Order Management System (CWPickOut) or the PCH Total Order Amount field in the Pick Control Header table. |
Purpose: Use this recap to track the cart batches generated during a pick slip run, including the picker, the packer, and the date and time when each batch was completed.
How to print: The system produces this recap listing when you generate pick slips if you are Using Cart/Bin Picking.
Bypass printing? If the Bypass Creation of Pick Forms during WSPS Pick Generation (K55) system control value is selected, the streamlined pick slip generation process does not generate this report. See that system control value for more information.
For more information: See the sample report in PDF format.
Contents:
• For each warehouse included in the batch:
• Warehouse: The number identifying the warehouse where the cart batch should be picked. See Creating and Maintaining Warehouses (WWHS) for information on setting up warehouses.
• Batch: A unique number to identify the billing batch number for the pick slip run.
• For each cart batch:
• Cart Batch Number: A unique number to identify the cart batch.
• Priority: The Priority (Ship via priority) for the ship vias selected to ship the pick slips included in the cart batch. The system assigns pick slips to the same cart batch only if they have the same ship via priority. For example, a cart batch might include a pick slip for ship via 33 and a pick slip for ship via 47 if both these ship vias have a ship via priority of 3. The ship via on the pick slip is derived from the order detail line if the item has a ship via override; otherwise, it is derived from the order header. See Ship Via Override Hierarchy for more information on how the system might override a ship via for an order or order detail line.
• Picks: The number of pick slips included in the cart batch.
• Quantity: The total number of units to be picked for the cart batch. For example, if a cart batch includes an order detail line with a quantity of 1 and an order detail line with a quantity of 50, the quantity indicated here is 51. This total includes main set items and non-inventory items; however, it does not include membership items, subscriptions, or virtual gift cards.
• Items: The total number of unique items included in the cart batch. For example, if a cart batch includes a pick slip with 10 units of item AB100, a pick slip with 7 units of item CD200, and a third pick slip with 1 unit of item AB100, the total number of unique items in the cart batch is 2 (AB100 and CD200).
• Picker: A blank line for you to enter the picker.
• Pick Date: A blank line for you to enter the pick date.
• Pick Time: A blank line for you to enter the pick time.
• Packer: A blank line for you to enter the packer.
• Total for Warehouse: The report includes subtotals for each warehouse included in the pick slip run:
• Picks: The total number of pick slips in all cart batches in the warehouse.
• Quantity: The total number of units to be picked in the warehouse.
• Items: The total number of unique item/cart batch combinations. For example, if item AB100 is included in cart batch 100 and in cart batch 105 in the same pick slip run, it counts as 2 total items.
• Final Totals: The report includes final totals for all warehouses included in the pick slip run:
• Picks: The total number of pick slips in all cart batches in all warehouses.
• Quantity: The total number of units to be picked in all warehouses.
• Items: The total number of unique item/cart batch combinations for all warehouses. For example, if item AB100 is included in cart batch 100 and in cart batch 105 in the same pick slip run, it counts as 2 total items.
Invalid ship via: The system includes pick slips that did not generate due to invalid ship via on this report.
Unmatched Reserved/Remaining Qty Report
Purpose: Use this report to review order lines that did not print on a pick slip because:
• The Qty remaining in the Reserved Order Line table is greater than the Qty reserved in the Order Detail table - the Qty printed in the Order Detail table, and
• The Qty printed in the Reserved Order Line table is greater than the Qty printed in the Order Detail table.
• The Qty printed - the Qty remaining in the Reserved Order Line table is greater than the Qty reserved in the Order Detail table.
The system also writes an order transaction history message for order lines whose Qty remaining or Qty printed in the Reserved Order Line table does not tie correctly to the Qty reserved or Qty printed in the Order Detail table. For example: ROL ERROR Pick not printed Ln # 001 qty mismatch.
If the order is not flagged to ship complete, the pick slip program generates a pick slip for the remaining order lines; similarly, if the remaining set component items are on an order that is not flagged to ship complete, the pick slip program generates a pick slip for the remaining set components.
How to print: The system generates this report when you perform Streamlined Pick Slip Generation (WSPS) if you have one or more order lines whose Qty remaining and Qty printed in the Reserved Order Line table does not tie correctly to the Qty reserved or Qty printed in the Order Detail table.
For more information: See the sample report in PDF format.
Contents:
• Cmp: The code for the company where pick slips were generated.
• Order #: The order number associated with the order line in error.
• Ship to #: The order ship to number associated with the order line in error.
• Ln #: The order line number that contains the item in error.
• Item Number: A code for the item in error.
• SKU Code: The SKU for the item in error.
• ODT Qty Ordered: The Qty ordered in the Order Detail table.
• ODT Qty Printed: The Qty printed in the Order Detail table.
• ODT Qty Reserved: The Qty reserved in the Order Detail table.
• ROL Qty Printed: The Qty printed in the Reserved Order Line table.
• ROL Qty Reserved: The Qty reserved in the Reserved Order Line table.
• ROL Qty Remaining: The Qty remaining in the Reserved Order Line table.
• Reserved: The date when the order line was reserved, in company date format.
• Ship Via: A code for the ship via assigned to the order line.
Pick Authorization Error Report
Purpose: This report indicates that records exist in the CC Authorization Transaction table for the company for which you ran Streamlined Pick Slip Generation (WSPS).
If records exist in the CC Authorization Transaction table, the system does not continue with pick slip generation and instead generates this report and a Order Management System Support Notification. Review the records in the CC Authorization Transaction table to determine if you need to use the Reprocess Authorizations Screen (RPAA) to reprocess authorizations and clear the records from the CC Authorization Transaction table.
How to print: The system generates this report when you perform Streamlined Pick Slip Generation (WSPS) if the CHECK_AUTHS_IN_PICKS setting in Working with Admin Properties (CPRP) is Y and records exist in the CC Authorization Transaction table for the company for which you are generating pick slips.
For more information: See the sample report in PDF format.
Contents: The report displays the following message: Cannot run picks -- pending authorizations exists.
________________________________
Contents SCVs Reports XML Messages Glossary
Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
Legal Notices