Drop Ship Pick Slip/Invoice

Purpose: The drop ship pick slip/invoice lists item and retail price information for a drop ship order.

How to print: The system generates the drop ship pick slip/invoice when you process drop ship pick slips or drop ship purchase orders at the Select Vendors for Drop Ship Screen. Purchase order receiving also generates a drop ship pick slip/invoice if the Print Drop Ship Invoice at time of Purchase Order Receiving (F10) system control value is selected.

Working with forms: See Forms Management (My Forms) for information on displaying or printing drop ship pick slips and other forms.

Note:

The information presented here is included on your drop ship pick slip/invoice only if your print program supports it. The Drop Ship Pick Print Program (E92) system control value identifies the pick slip printing program to use for drop ship orders. The standard program for drop ship pick slips is the same as the standard program for regular pick slips (PICKG for the graphical pick slip).

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Sample pick slip: See the Pick Slip.

Contents: The INPUT_TYPE setting for your pick slip form in Working with Customer Properties (PROP) indicates the means by which your drop ship pick printing program obtains the data to print on the pick slip form. Each option is available only if your drop ship pick printing program supports it. Valid values are:

XML = The program uses the Pick Message from Order Administration (CWPickOut) to generate the drop ship pick slip.
DB = The program queries the database to generate the drop ship pick slip. The INPUT_TYPE setting for the standard printing program PICKG is DB.

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Drop Ship Pick Slip Sold To Label (ORDERED By)	Comments
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.
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 Administration (CWPickOut) or the Order # and Ship to # fields 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 and PICKDBG (graphical pick slip) settings in Working with Customer Properties (PROP) controls whether the system prints a barcode on the drop ship pick slip. From the CMP Company, PCH Control #, and PCL Label Number fields in the Pick Control Label table.
Generation Date	The date the drop ship pick slip was generated. From the date_printed attribute in the V 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 drop ship 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 Administration (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 Administration (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 Administration (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 Administration (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 drop ship 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 Administration (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 Administration (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.
Drop Ship Pick Slip Ship To Label	A separate drop ship pick slip prints for each ship to customer on the order.
Logo	See Setting Up Company Logos for Forms for setup 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 and PICKDBG (graphical pick slip) settings 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	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 Administration (CWPickOut) or the Order # and Ship to # fields in the Pick Control Header table.
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 Administration (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 Administration (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 Administration (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 Administration (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 Administration (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 drop ship 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 Administration (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 Administration (CWPickOut) or the Country description field in the Country table. NOTEThe 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`
Generation Date	The date the pick slip was generated. From the date_printed attribute in the Pick Message from Order Administration (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 Administration (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 Administration (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 Administration (CWPickOut) for msg_type OH or the OMS Message field in the Order Message table.
Drop Ship Pick Slip Header Information
Date Of Order	The date the order was placed. From the order_date attribute in the Pick Message from Order Administration (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 Administration (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 Administration (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 Administration (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 Administration (CWPickOut) or the CST Customer # field in the Pick Control Header table.
Order No.	The order number associated with the drop ship pick slip. From the order_nbr attribute in the Pick Message from Order Administration (CWPickOut) or the Order # field in the Order Ship To table.
Page No.	The number of this drop ship pick slip page.
Drop Ship 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. NOTE: Each item prints on a separate drop ship pick slip if the Allow Only Single Line on Drop Ship Pick (C82) system control value is selected. Also, if the Print One Drop Ship Invoice per Ship Alone Item (E38) system control value is selected, a separate drop ship pick slip prints for each unit of a ship-alone item.
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 Administration (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 Administration (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. If this is a ship-alone item and the Print One Drop Ship Invoice per Ship Alone Item (E38) system control value is selected, a separate drop ship pick slip prints for each unit. From the qty_printed attribute in the Pick Message from Order Administration (CWPickOut) or the PCD Original qty printed field in the Pick Control Detail table.
Backordered	This field is not currently used for drop ship pick slips.
Location Code	The location in the warehouse where the item is picked. Included only for items shipping on this pick slip. From the whse_location attribute in the Pick Message from Order Administration (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 Administration (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 Administration (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 drop ship pick slips for gift orders, or if the Print Amounts on Drop Ship Picks (C81) system control value is unselected. selling_price
Extension	The item price times the quantity shipped on this pick slip. Not included on drop ship pick slips for gift orders, or if the Print Amounts on Drop Ship Picks (C81) system control value is selected. From the selling_price_extended attribute in the Pick Message from Order Administration (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.
Drop Ship Pick Slip Totals	Totals print on every page of multi-page drop ship pick slips. No totals print on drop ship pick slips for gift orders or if the Print Amounts on Drop Ship Picks (C81) system control value is unselected.
Total Merchandise	The total merchandise value of all items on the drop ship pick slip, after applying any discounts or repricing. This total does not include items shipping from your warehouse, backordered items, canceled or soldout items, items shipped separately, or items with stock allocation errors. From the merch_amt attribute in the Pick Message from Order Administration (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. From the freight_amt + addl_freight_amt + addl_charge_amt + hand_charge_amt attributes in the Pick Message from Order Administration (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 Administration (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 Administration (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. From the amt_paid attribute in the Pick Message from Order Administration (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 Administration (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 Administration (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 Administration (CWPickOut) or the PCH Total Order Amount field in the Pick Control Header table.

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 drop ship 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.