Drop Ship 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 different 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:

Date range: The date range you selected at the Drop Ship Integration Reports Screen. 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.

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

Qty: The quantity of the item associated with the pending 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 for the vendor pending cancellation.

Total units: The number of drop ship items across all vendors pending cancellation.

FU07_05r OROMS 17.0 2018 OTN