How to print: The system generates this list when you process drop ship purchase orders at the Select Vendors for Drop Ship Screen.
For more information: See the sample report in PDF format.
Contents:
• Vendor number and description
For each drop ship order:
• Item code and description
• Order number
• Ship-to number
• Order date
• Sold-to customer number
• Sold-to name and address
• Ship-to name and address
• Date printed
• Ship-to phone number
• Drop Ship Output. Valid values are:
• D/S LOCATE (You process drop ship orders for this vendor using the interface with Order Broker’s Drop Ship Manager.)
• D/S PICK (You process drop ship orders for this vendor using drop ship pick slips.)
• D/S PO (You process drop ship orders for this vendor using drop ship purchase orders generated through Order Management System.)
• Order detail line number
• Item code
• SKU, if any
• Item description
• Quantity
• Price
• Extended price
• Source code for the order
• Total quantity
• Total price
For each vendor item:
• Total quantity
• Total price
Purpose: This report lists vendors for whom you have generated drop ship purchase orders using the Selecting Vendors for Drop Ship Processing (MDSP) menu option, the order number and purchase order number for each drop ship order, and whether the purchase order will be automatically processed through the Order Broker Drop Ship Integration.
This report does not include vendors whose Drop ship output field is set to Drop ship pick, since you do not produce purchase orders (instead you produce pick slips) for these vendors.
How to print: The system generates this list when you process drop ship purchase orders at the Select Vendors for Drop Ship Screen.
For more information: See the sample report in PDF format.
Contents:
• Purchase order number. The system automatically assigns purchase order numbers when you generate drop ship purchase orders.
• Vendor number
• Due Date. The system calculates this date by adding the number of days in the vendor item table to the order date, except when the arrival date on the order is later than the calculated date; in this case the due date is the arrival date.
• Order number
• Customer number and name
• OROB flag: if you use Order Broker’s Drop Ship Manager to process drop ship items with this vendor, the OROB flag is set to Y.
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).
Sample pick slip: See the graphical drop ship pick slip sample.
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 Management System (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.
|
Drop Ship Pick Slip Sold To Label (ORDERED By) |
|
|
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 Management System (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 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 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 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 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 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. |
|
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 Management System (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 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 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 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. |
|
Generation Date |
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 |
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. |
|
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 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 drop ship 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 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 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. • 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 Management System (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 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 drop ship pick slips for gift orders, or if the Print Amounts on Drop Ship Picks (C81) system control value is unselected. 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 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 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. |
|
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 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. 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. 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. |
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.
How to print: The system generates the drop ship purchase order when you complete the Select Vendors for Drop Ship Screen (MDSP) if the vendor’s Drop ship output flag is set to Drop Ship Purchase Order.
In addition, you can complete the:
• Print P/O Window in PO maintenance or inquiry
• Print PO Selection Screen in Print Purchase Orders (MPRP)
Print program: You use the PO Print Program (C64) and the PO Print Program for PO Print in PO Sequence (C76) system control values to indicate the print program to use. The default graphical print program is PURCHORDG. If you use a different print program, your purchase order will differ from the samples.
Working with forms: See Forms Management (My Forms) for information on displaying or printing purchase orders and other forms.
Sample drop ship purchase orders: See the graphical drop ship purchase order sample .
Amounts: The system truncates and does not round amounts that are greater than 2 positions to the right of the decimal place.
Contents:
• Logo. See Setting Up Company Logos for Forms for setup information.
• The words Purchase Order are in the upper right.
• Page number, preceded by the label Page in blue.
• Vendor Fax No: From the Vendor record. No phone number formatting applies.
• Purchase order number.
• Revision Number. Set to 0 if the purchase order was generated when you completed the Select Vendors for Drop Ship Screen.
• Date: Purchase order creation date.
• Terms: The first 22 positions of the terms description from the Vendor record. Blank if no terms specified for the vendor.
• Ship Via: The description of the purchase order ship via on the purchase order header. The purchase order ship via defaults from the ship via on the order header. See Drop Ship Purchase Order Setup for Purchase Order Ship Vias for a discussion.
• F.O.B: The FOB city from the purchase order. Included only if you added this information after drop ship purchase order generation.
• Date Required: The due date from the purchase order. The system calculates this date by adding the number of days in the vendor item table to the order date, except when the arrival date on the order is later than the calculated date; in this case the due date is the arrival date.
• Ship Date: The promise date from the purchase order.
• Cancellation Date: The cancel date from the purchase order. Included only if you added this information after drop ship purchase order generation.
• Vendor information, including:
• Vendor number, preceded by the label Vendor # in blue.
• Vendor name.
• Vendor contact name.
• Vendor address (all entered address lines).
• Vendor city, state, postal code, and country code.
Note: If you update the vendor record before printing the purchase order, the updated vendor information prints.
• Ship to (customer) name and address, including:
• Company name.
• Customer title, first name, middle initial, last name, and suffix.
• Customer address (all entered address lines).
• Customer city, state, postal code, and country code.
Note: If you update the customer record before printing the purchase order, the updated customer information prints.
• Shipping Instructions: The order number that originated the drop ship purchase order. For example, if the purchase order is required to fulfill order 2875, the shipping instructions read DRP SHP ORD#00002875.
• For each detail line on the purchase order:
• Item Number/Vendor Item Number: The two item numbers are separated by a slash (/) if a vendor item number has been defined. The item number includes the SKU, if any.
• Qty: The quantity in the vendor’s unit of measure, as defined for the vendor item. For example, if the vendor’s unit of measure is 12, and you order 48, the quantity is 4 (4 dozen). Otherwise, if there is no vendor item unit of measure, this is the quantity is in the item’s unit of measure.
• UOM: The unit of measure used by the vendor, if specified. Otherwise, if there is no vendor item unit of measure, this is the item’s unit of measure.
• Item description/Vendor item description: The two descriptions are separated by a slash (/) if a vendor item number has been defined. The first 38 positions of the item description display and do not include information at the SKU level.
• Date Required: From the purchase order due date.
• Unit Price: The unit price in the vendor’s unit of measure. For example, if the unit of measure is 12, and the unit price is $120.00, the price for each individual unit is $10.00 ($120.00 / 12).
• Extended Amount: The extended price in the vendor’s unit of measure, calculated by multiplying the vendor’s quantity by the vendor’s unit price.
Note: Discounts you have set up through the Work with Vendor Discounts Screen do not apply to drop ship purchase orders.
• Vendor item notes that are flagged to print on the PO.
• Custom special handling instructions. The system truncates the instructions if they cannot fit on one line.
Note: Standard special handling instructions do not print on the drop ship purchase order.
• Total Units: The total in the vendor’s unit of measure. Included on every page of a multi-page purchase order.
• Purchase Order Total. Included on every page of a multi-page purchase order.
• Special Instructions: Purchase order header messages and vendor notes that are flagged to print, if any exist. A maximum of 5 lines of each message type can print. Included on every page of a multi-page purchase order.
• Prepared By: The description of the default buyer for the item.
• Authorized By: The name of hte user who authorized the purchase order. Not currently implemented.
________________________________
Contents SCVs Reports XML Messages Glossary
Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
Legal Notices