Drop Ship Integration Items Pending Cancellation Report

Purpose: This report lists all drop ship items which you are fulfilling through integration with Order Broker’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.


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.


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.

FU07_05r OMSCS 19.0 December 2019 OHC