Drop Ship Items Confirmed Cancellation Report

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

Each vendor prints on a different 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:

• Date range: The date when the vendor accepted the cancellation request. The report displays all cancellations accepted 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.

• Vnd Can 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.

• Qty: The quantity of the item associated with the confirmed cancellation request.

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

• Ext Price: The extended price. This is the retailer’s price for the item (the price charged to the customer).

• PO#: The purchase order number and PO line number.

• Tel#: 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: The description of the item.

• Status: The status of the order line.

• Email: The customer’s email address.

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