Fulfillment

Backorder Summary Report

Purpose: This is an aging report that shows you:

the number of orders that have not yet had any items shipped
the number of orders that have already had one or more shipments and are still open
the corresponding number of days since the order was entered on the system (the number of days that the order has been open)

This information helps you identify the number of days orders remain open waiting for shipment of backordered items. For example, the report shows that you have 383 open orders for which you have already made one shipment, that are still open four to seven days after order entry.

How to print: Select the B/O Summary Report field on the Submit Fill Rate Reports Screen.

For more information: See the sample report in PDF format.

Contents:

Aging buckets: Seven different aging buckets that show the number of days an order has been open on the system (the number of days since the order was entered) and the number of shipments that have been made to date on the order. The aging buckets are pre-defined to the following number of days:
- 0-3 days
- 4-7 days
- 8-14 days
- 15-21 days
- 22-30 days
- 31-45 days
- 46 or more days

(This information might indicate that you may not have much movement on orders that have been on the system for a period of time, which might point to a problem with your vendor, purchasing department or projecting demand for items sold in the offer.)

# of shipments: This column breaks out information on the report by the number of shipments that have already been made on each order that is still currently open. Once the order is closed, it is not included in the totals on this report. Ideally, you want to ship an order complete, in one shipment. Otherwise, you start losing money on shipping. The number of shipments reported here are: 1, 2, 3, 4, 5, 6 and 7 or more shipments on an order.

Batch Confirmed Report

Purpose: Use this report to review summary information for a batch of pick slips, such as the per unit meter charge and total pick slips confirmed.

Confirm picks by batch number at the Batch Confirmation Pop-up Window.

For more information: See the sample report in PDF format.

Contents:

Billing Date
Billing Batch Number
Ship via
Meter charge
Meter charge per unit (meter charge / total units in batch = meter charge per unit)
Total picks confirmed
Total units

Batch Item Pull Label

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.

Carryover Report

Purpose: This report displays unconfirmed pick slips whose date is on or before the pick print date you specify at the Print Carryover Report Screen.

The report groups pick slips by warehouse and sorts in batch number, pick control number sequence. A final total is at the end of the report.

How to print: Specify a date and select Submit to submit the CARRYOVER job at the Print Carryover Report Screen.

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:

Picks Printed on or before: The date you specified at the Print Carryover Report Screen.
Warehouse: The warehouse code and description where the picks were printed.

For each unconfirmed pick slip:

Batch Number: The billing batch number for the pick slip.
Pick Number: The pick control number for the pick slip.
Status: The status of the pick slip.
- The system includes pick slips whose status is blank (open), M (manifest submission), O (carryover), P (packed), or R (reprinted).
- The system does not include pick slips whose status is A (submitted to async), B (billing pending), C (confirmed), D (declined authorization), E (async processing error), G (generated no authorization), H (generated has authorization), S (suspended), V (void), W (waiting for authorization), or Z (authorized).
Type: The generation type for the pick slips, including R (regular), D (drop ship), S (special handling), and M (master pick slip).
Special Handling: Indicates if the pick slip includes one or more items with special handling. The system looks at the Additional charge code field in the Pick Control Detail table to determine if an item has special handling.
- Y indicates one or more items on the pick slip have special handling.
- blank indicates no items on the pick slip have special handling.
Print Date: The date when the pick slip was printed, from the Date printed field in the Pick Control Header table.
Print Time: The time when the pick slip was printed, from the Time printed field in the Pick Control Header table.
Order Number: The order number associated with the pick slip, from the Order # field in the Pick Control Header table.
Ship To: The order ship-to number.
Via: The ship via associated with the pick slip, from the Ship via code field in the Pick Control Header table.
Pick Total: The total value for the pick slip, from the Total order amount field in the Pick Control Header table. Includes merchandise, tax, freight, handling, and all other charges.
Cust Number: The number of the sold to customer on the pick slip, from the Customer # field in the Pick Control Header table.
Sold To: The name or company of the sold to customer on the pick slip, from the First, Last, and Company fields in the Pick Control Header table.
Date Total: The total number of unconfirmed pick slips that printed on a specific date and the total value for those pick slips.
Type Total: The total number of unconfirmed pick slips of a specific generation type and the total value for those pick slips.
Warehouse Total: The total number of unconfirmed pick slips for a specific warehouse and the total value for those pick slips.
Final Total: The total number of unconfirmed pick slips, across all print dates, generation types, and warehouses and the total value for those pick slips.

Cart Batch Recap

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.

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.

Drop Ship Batch Confirmation Report

Purpose: Use this report to review the total cost of items on drop ship pick slips when you confirm by billing batch number.

Confirm drop ship pick slips by billing batch number at the Batch Confirmation Pop-up Window.

For more information: See the sample report in PDF format.

Contents:

current system date (not the date you entered at the Interactive Confirmation Screen)
billing batch number for the group of drop ship pick slips
vendor number for the item(s). The vendor number must be assigned to the item in the Vendor field on the Create and Change Item screens. Also, there must be a vendor/item record for this item and vendor, with a price defined, for the item to be included in this vendor's drop ship confirmation totals.
name of the vendor
number of drop ship pick slips confirmed in the billing batch
total cost for drop shipments from this vendor, calculated by multiplying the unit vendor/item price for each item by the number of units confirmed in the billing batch
total special handling cost for this vendor, calculated by multiplying the default special handling cost defined for the custom special handling format by the number of units. Special handling costs defined as a percentage rather than a unit amount are not included in this calculation.

For more information:

Printing drop ship pick slips (fast path = MDSP): Selecting Vendors for Drop Ship Processing (MDSP)
Assigning vendors to drop ship items (fast path = MITM: Working with Existing Items (MITM)
Setting up vendor/items (fast path = WVNI): Working with Vendor Items (WVNI)
Setting up custom special handling formats (fast path = WSHF): Establishing Custom Special Handling Formats (WSHF)

Drop Ship Integration Items Confirmed Cancellation Report

Purpose: This report lists all drop ship items which you are fulfilling through integration with Order Orchestration’s Supplier Direct Fulfillment module and which have a confirmed cancellation from the vendor.

Each vendor prints on a separate page.

How to print: Select Drop Ship Items Confirmed Cancellation in the Report selection field at the Drop Ship Integration Reports Screen.

For more information: See the sample report in PDF format.

Contents:

From and To Dates: The date range, if any, you selected when generating the report. This is the date when the vendor accepted the cancellation request. The report displays all cancellations accepted within the date range, if specified, including starting and ending dates.
Vendor: The number and name of the vendor associated with the drop ship item that is pending cancellation.
Telephone: The vendor’s telephone number.
Vendor Cancellation Date: The date the vendor accepted the cancellation request for the drop ship item.
Sales Order: Sales order number and ship-to extension.
Line: The line number associated with the confirmed cancellation request.
Sold To: The sold to customer. If both name and company are entered on the order, the report lists the company, with the customer name after the label ATTN. The first twenty positions for combined company and customer name print.
Item: The item that has been cancelled.
SKU: The SKU code, if any, of the item.
Quantity: The quantity of the item associated with the confirmed cancellation request.
Extended Cost: The extended cost. This is the vendor’s price for the item, from the PO Detail, Vendor Item, or SKU table, in that order.
Extended Price: The extended price. This is the retailer’s price for the item (the price charged to the customer).
PO Number: The purchase order number and PO line number.
Telephone: The sold-to telephone number (day or evening). If the customer has both day and evening telephone numbers, the evening telephone number prints.
Item description (unlabeled): The description of the item.
Status: The status of the order line in Order Orchestration.
Email: The customer’s email address.

Totals:

Vendor Units: The number of drop ship items that have been cancelled for the vendor.
Total Units: The number of drop ship items that have been cancelled across all vendors.

Drop Ship Integration Items on Hold from Vendor Report

Purpose: This report lists drop ship items which you are fulfilling through integration with Order Orchestration’s Supplier Direct Fulfillment module which have been placed on hold by your vendors.

Each vendor prints on a separate page.

How to print: Select Drop Ship Items on Hold in the Report selection field at the Drop Ship Integration Reports Screen.

For more information: See the sample report in PDF format.

Contents:

From and To dates: The date range, if any, you selected when generating the report. This date range represents the date when the order line was put on hold by the vendor. The report displays all orders placed on hold from starting to ending dates, including starting and ending dates. Note: This is not the expected ship date or the revised expected ship date.
Vendor: The number and name of the vendor associated with the drop ship item that is on hold.
Telephone: The vendor’s telephone number.
Vendor Hold Date: The date the order line was placed on hold by the vendor. Note: This date is the date the vendor placed the order line on hold, not the expected ship date or revised expected ship date.
Sales Order: Sales order number and ship-to extension.
Line: The line number that has been placed on hold by the vendor.
Sold To: The sold-to customer on the order. If both the name and company are entered on the order, the report lists the company, with the customer name after the label ATTN. The first twenty positions for combined company and customer name print.
Item: The item that has been placed on hold by the vendor.
SKU: The SKU code, if any, of the item.
Quantity: The quantity of the item placed on hold.
Extended Cost: The extended cost. This is the vendor’s price for the item, from the PO Detail, Vendor Item, or SKU table, in that order.
Extended Price: The extended price. This is the retailer’s price for the item (the price charged to the customer).
PO Number: The purchase order number and PO line number.
Telephone: The sold-to telephone number (day or evening). If the customer has both day and evening telephone numbers, the evening telephone number prints.
Item description (unlabeled): The description of the item.
Status: The status of the order line in the integrated system.
Email: The customer’s email address.
Message (unlabeled): Additional information or hold reason entered by the vendor.

Totals:

Vendor Units: The number of drop ship items on hold for the vendor.
Total Units: The number of drop ship items on hold across all vendors.

Drop Ship Integration Items Pending Cancellation Report

Purpose: This report lists all drop ship items which you are fulfilling through integration with Order Orchestration’s Supplier Direct Fulfillment module for which you have sent cancel requests to the vendor, but have not yet received responses.

Each vendor prints on a separate page.

How to print: Select Drop Ship Items Pending Cancellation in the Report selection field at the Drop Ship Integration Reports Screen.

For more information: See the sample report in PDF format.

Contents:

From and To dates: The date range, if any, you selected when generating the report. The report displays all cancel requests sent within the date range, including starting and ending dates.
Vendor: The number and name of the vendor associated with the drop ship item that is pending cancellation.
Telephone: The vendor’s telephone number.
Cancellation Requested Date: The date a cancellation request was generated for the drop ship item.
Sales Order: Sales order number and ship-to extension.
Line #: The line number associated with the pending cancellation request.
Sold To: The sold to customer. If both name and company are entered on the order, the report lists the company, with the customer name after the label ATTN. The first twenty positions for combined company and customer name print.
Item: The item pending cancellation.
SKU: The SKU code, if any, of the item.
Quantity: The quantity of the item associated with the pending cancellation request.
Extended Cost: The extended cost. This is the vendor’s price for the item, from the PO Detail, Vendor Item, or SKU table, in that order.
Extended Price: The extended price. This is the retailer’s price for the item (the price charged to the customer).
PO Number: The purchase order number and PO line number.
Telephone: The sold-to telephone number (day or evening). If the customer has both day and evening telephone numbers, the evening telephone number prints.
Item description (unlabeled): The description of the item.
Status: The status of the order line in the integrated system.
Email: The customer’s email address.

Totals:

Vendor Units: The number of drop ship items for the vendor pending cancellation.
Total Units: The number of drop ship items across all vendors pending cancellation.

Drop Ship Integration Items Pending Shipment Report

Purpose: This report lists all drop ship items which are pending shipment in Order Orchestration’s Supplier Direct Fulfillment module.

Each vendor prints on a separate page.

How to print: Select Drop Ship Items Pending Shipment in the Report selection field at the Drop Ship Integration Reports Screen.

For more information: See the sample report in PDF format.

Contents:

From and To Dates: The date range, if any, you selected when generating the report. The report displays all purchase orders sent within the date range, including starting and ending dates.
Vendor: The number and name of the vendor associated with the drop ship item that is pending shipment in the integrated system.
Telephone: The vendor’s telephone number.
Order Date (unlabeled): The date when the order was sent to the integrated system.
Sales Order: Sales order number and ship-to extension.
Line: The line number that is pending shipment in the integrated system.
Sold To: The sold to customer. If both name and company are entered on the order, the report lists the company, with the customer name after the label ATTN. The first twenty positions for combined company and customer name print.
Item: The item that is pending shipment in the integrated system.
SKU: The SKU code, if any, of the item.
Quantity: The quantity of the item that is pending shipment in the integrated system.
Extended Cost: The extended cost. This is the vendor’s price for the item, from the PO Detail, Vendor Item, or SKU table, in that order.
Extended Price: The extended price. This is the retailer’s price for the item (the price charged to the customer).
PO Number: The purchase order number and PO line number.
Telephone: The sold-to telephone number (day or evening). If the customer has both day and evening telephone numbers, the evening telephone number prints.
Item description (unlabeled): The description of the item.
Status: The status of the order line in the integrated system.
Email: The customer’s email address.

Totals:

Vendor Units: The number of drop ship items that is pending shipment in the integrated system.
Total Units: The number of drop ship items that is pending shipment in the integrated system.

Drop Ship Integration Items Sent to Integrated System Report

Purpose: This report lists all drop ship items which were sent to Order Orchestration’s Supplier Direct Fulfillment module.

Each vendor prints on a separate page.

How to print: Select Drop Ship Items Send to Integrated System in the Report selection field at the Drop Ship Integration Reports Screen.

For more information: See the sample report in PDF format.

Contents:

From and To Dates: The date range, if any, you selected when generating the report. The report displays all purchase orders sent within the date range, including starting and ending dates.
Vendor: The number and name of the vendor associated with the drop ship item that was sent to the integrated system.
Telephone: The vendor’s telephone number.
PO Sent Date: The date the purchase order was sent to the integrated system.
Sales Order: Sales order number and ship-to extension.
Line: The line number that was sent to the integrated system.
Sold To: The sold to customer. If both name and company are entered on the order, the report lists the company, with the customer name after the label ATTN. The first twenty positions for combined company and customer name print.
Item: The item that was sent to the integrated system.
SKU: The SKU code, if any, of the item.
Quantity: The quantity of the item that was sent to the integrated system.
Extended Cost: The extended cost. This is the vendor’s price for the item, from the PO Detail, Vendor Item, or SKU table, in that order.
Extended Price: The extended price. This is the retailer’s price for the item (the price charged to the customer).
PO Number: The purchase order number and PO line number.
Telephone: The sold-to telephone number (day or evening). If the customer has both day and evening telephone numbers, the evening telephone number prints.
Item description (unlabeled): The description of the item.
Status: The status of the order line in Order Orchestration.
Email: The customer’s email address.

Totals:

Vendor Units: The number of drop ship items sent to the integrated system for the vendor.
Total Units: The number of drop ship items sent to the integrated system across all vendors.

Drop Ship Integration Items Shipped Report

Purpose: This report lists all drop ship items that have been shipped in Order Orchestration’s Supplier Direct Fulfillment module.

Each vendor prints on a separate page.

How to print: Select Drop Ship Items Shipped in the Report selection field at the Drop Ship Integration Reports Screen.

For more information: See the sample report in PDF format.

Contents:

From and To Dates: The date range, if any, you selected when generating the report. The report displays all purchase orders shipped within the date range, including starting and ending dates.
Vendor: The number and name of the vendor associated with the drop ship item that has been shipped in the integrated system.
Telephone: The vendor’s telephone number.
Shipped Date (unlabeled): The date when the vendor reported the item shipped.
Sales Order: Sales order number and ship-to extension.
Line: The line number that was reported shipped in the integrated system.
Sold To: The sold to customer. If both name and company are entered on the order, the report lists the company, with the customer name after the label ATTN. The first twenty positions for combined company and customer name print.
Item: The item that has been reported shipped in the integrated system.
SKU: The SKU code, if any, of the item.
Quantity: The quantity of the item that was reported shipped in the integrated system.
Extended Cost: The extended cost. This is the vendor’s price for the item, from the PO Detail, Vendor Item, or SKU table, in that order.
Extended Price: The extended price. This is the retailer’s price for the item (the price charged to the customer).
PO Number: The purchase order number and PO line number.
Telephone: The sold-to telephone number (day or evening). If the customer has both day and evening telephone numbers, the evening telephone number prints.
Item description: (unlabeled) The description of the item.
Status: The status of the order line in the integrated system.
Email: The customer’s email address.

Totals:

Vendor Units: The number of drop ship items that have been reported shipped in the integrated system.
Total Units: The number of drop ship items that have been reported shipped in the integrated system.

Drop Ship Integration Items with Revised Due Date Report

Purpose: This report lists all drop ship items which you are fulfilling through integration with Order Orchestration’s Supplier Direct Fulfillment module which have had their due dates revised by the vendor since the report was last generated.

Each vendor prints on a separate page.

How to print: Select Drop Ship Items with Revised Due Date in the Report selection field at the Drop Ship Integration Reports Screen.

For more information: See the sample report in PDF format.

Contents:

From and To dates: The date range, if any, you selected when generating the report. This is the date when the due date revision was entered by the vendor. The report displays all orders with due date revisions entered within the date range, inclusively. Note: This date range represents the date the revision was entered, not the revised expected ship date itself.
Vendor: The number and name of the vendor associated with the revised due date.
Telephone: The vendor telephone number.
Revised: The revised due date.
Original: The original due date.
Sales Order: The sales order number and ship-to extension.
Line: The order line number.
Sold To: The sold to customer. If both name and company are entered on the order, the report lists the company, with the customer name after the label ATTN. The first twenty positions for combined company and customer name print.
Item: The item whose due date has been revised by the vendor.
SKU: The SKU code, if any, for the item.
Quantity: The quantity of the item whose due date has been revised by the vendor.
Extended Cost: The extended cost of the item. This is the vendor’s price for the item, from the PO Detail, Vendor Item, or SKU table, in that order.
Extended Price: The extended price of the item. This is the retailer’s price for the item (the price charged to the customer).
PO Number: The purchase order number and PO line number.
Telephone: The sold-to telephone number (day or evening). If the customer has both day and evening telephone numbers, the evening telephone number prints.
Item description (unlabeled): The description of the item.
Status: The status of the order line in the integrated system.
Email: The customer’s email address.

Totals:

Vendor Units: The number of drop ship items for the vendor with a revised due date.
Total Units: The number of drop ship items across all vendors with a revised due date.

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

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 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. 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 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. See the Gift Acknowledgement for more information.

Drop Ship Purchase Order List

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 Orchestration 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 Orchestration’s Drop Ship Manager to process drop ship items with this vendor, the OROB flag is set to Y.

Fill Rate Report

Purpose: This report shows you the number and percentage of orders that you have stock for on the first shipment (therefore, shipping the order complete), plus the number and percentage of orders with backordered items.

The column on the left of the report shows you up to 8 weeks in the specified date range for the specified offer or all offers that are effective during these dates.

For example, in week 1, you had the ability to ship 7 orders complete, or 58.33% of all orders shipped in week 1. The calculation is:

7 / (7 + 3 + 2 + 0 + 0)

How to print: Select the Fill Rate Report field on the Submit Fill Rate Reports Screen.

For more information: See the sample report in PDF format.

Contents:

Date range: The dates for which you want to report on your backorder/fulfillment status. This date range is associated with the effective dates for the offer, as defined in the Offer date range fields in the Offer table. Only offers effective during this date range will be included on these reports.
Offer: The code for the catalog, space or television advertisement you want to report on. The report will reflect the backorder/fulfillment status for this offer only. Offer codes are defined in and validated against the Offer table.

Instock rate:

100% In Stock: This column shows the number and percentage of orders that had stock for all items on the first shipment. Because of this, you were able to ship these orders complete.
#-# lines B/O: lines backordered. These columns show the number and percentage of orders that did not have stock for all items on the order, so that one or more items were backordered and the order required more than one shipment.
Week # of Date Range: These rows on the report show the fill rate for each week in the offer. This information shows how well you forecasted demand for items in the offer.
Totals: The totals at the bottom of the report give the number and percentage of orders that were completely in stock or with varying degrees of backordered items.

Gift Acknowledgement

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 Administration (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 inthe Pick Message from Order Administration (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 the Pick Message from Order Administration (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 thethe Pick Message from Order Administration (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 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 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 inthe 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 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 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 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 thePick 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.
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 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 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 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 DAssigning 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 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 thethe 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 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 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 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. 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 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.
Gift Acknowledgment 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 gift acknowledgement. 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 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 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 gift acknowledgement. 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.
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 Administration (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 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 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 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 gift acknowledgement. From the selling_price attribute in the Pick Message from Order Administration (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 Administration (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 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 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 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 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 V 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 payment method. 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.

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.

Item Stock Allocation Errors

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.

Manifest Audit Report

Sorted by Scan Date/Pick Control Number

Purpose: Use this report to help you determine the shipment status of packages you have sent to the PC manifesting station. The system writes an audit record each time you receive an upload from the PC manifest or you manually confirm a pick slip by pick control number. The Print Manifest Audit Report menu option allows you to choose the format and other selection criteria for printing a report of manifest audit records.

How to print: Select Accept Save Dflt after completing the Manifest Audit Report Screen.

For more information: See the sample report in PDF format.

Contents:

the date the packages were scanned
pick control number
pick label number
order number
order ship-to number
ship via (the carrier or service to deliver the merchandise to your customer)
merchandise dollar total. Second and subsequent labels for the same pick slip will have a merchandise total of zero.
billing batch number
batch date (the date you generated the pick slips)
scan date
the time the package was scanned
invoice number. Second and subsequent labels for the same pick slip will have an invoice number of zero.
totals for the scan date, including:
- total number of unique pick control numbers for the billing batch
- total number of duplicate labels scanned. This number indicates the number of pick slips that shipped in more than one package.
- total number of records sent to billing. This total should equal the total number of pick slips, as second and subsequent labels would not normally go to billing.
- total number of records invoiced, or processed by billing. This total should not exceed the total number of pick slips.
- total merchandise dollars for the billing batch

Sorted by Scan Date/Order Number

How to print: Select Accept Save Dflt after completing the Manifest Audit Report Screen.

For more information: See the sample report in PDF format.

Contents: See Manifest Audit Report.

Sorted by Batch Date

How to print: Select Accept Save Dflt after completing the Manifest Audit Report Screen.

For more information: See the sample report in PDF format.

Contents: See Manifest Audit Report Screen.

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.

Pick Slip

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 Administration (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.

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

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.
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 Administration (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 Pick Message from Order Administration (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 Administration (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 Administration (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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).
Generation Date (unlabeld)	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.
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 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 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.
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 Administration (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 Administration (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 Administration (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, `00037c02` 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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).
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 Administration (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 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 on the pick. 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 on the pick. 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 on the pick. 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 on the pick. 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 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 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 on the pick. From the ship_to_country_name attribute in the Pick Message from Order Administration (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 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 (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 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.
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 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 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 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. 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.
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 Administration (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 dAdd 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 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 pick slips for gift orders. From the selling_price attribute in the Pick Message from Order Administration (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 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.
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 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.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.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.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.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.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.V 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 payment method. 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. 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 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. 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 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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).
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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

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.

Pick Unit 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.

Picking Pullsheet

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.

Purchase Order

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.

Amount: 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.

Shipment Summary Report

Purpose: This report shows you the number and percentage of orders with single and multiple shipments during a particular date range (during the offer). This information helps you identify where you are losing money on multiple shipments, which may indicate a problem forecasting demand for items advertised in an offer.

For example, if you shipped 92 pick slips in week 1, 73.01% of the orders have had just one shipment. The calculation is:

92 / (92 + 12 + 18 + 1 + 1 + 0 + 2)

Note:

This report presents totals for all orders with shipments in the selected period, regardless of status. Of the 92 orders for which you made single shipments in the sample report, an unknown percentage may still be open due to backorders.

How to print: Select the Shipment Summary Report field on the Submit Fill Rate Reports Screen.

For more information: See the sample report in PDF format.

Contents:

Date range: The dates for which you want to report on your backorder/fulfillment status. This date range is associated with the effective dates for the offer, as defined in the Offer date range fields in the Offer table. Only offers effective during this date range will be included on these reports.
Offer: The code for the catalog, space or television advertisement you want to report on. The report will reflect the backorder/fulfillment status for this offer only. Offer codes are defined in and validated against the Offer table.
Shipments: The number and percentage of shipments on orders during the specified date range. This report provides totals for orders that have generated one shipment, plus orders that have required 2, 3, 4, 5, 6, 7 or more shipments. Multiple shipments indicates that the order included items that were not in stock and had to be backordered.

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.

Vendor Drop Ship Worksheet

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 Orchestration’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