Drop Ship Integration Items on Hold from Vendor Report

Purpose: This report lists CWCollaborate or Locate drop ship items put on hold by the vendor. Only items that are currently on hold are included in the report.

How to print: Enter 1 in the selection field at the Drop Ship Integration Reports Screen.

CWDirect Rel 17.0 Drop Ship Integration Items EKAPLAN FLR1009 1/22/14 8:19:26 Page 1 EZK Mail Order ON HOLD FROM VENDOR From: 12/31/13 To: 1/22/14 Vendor 3 AVIAN SUPPLY Telephone (508) 111-1111 Vnd Hld Date Sales Order# Line# Sold To Item SKU Qty Ext Cost Ext Price 1/17/14 200808 - 001 1 MITTENS, JACK MILLET 1 10.01 5.00 PO# 2209 - 1 Tel#: 6 OZ. PACKAGE MILLET SPRAYS Status: Held Email: reason description entered by vendor ------------------------------------------------------------------------------------------------------------------------------- Vendor units: 1 Total units: 1

Contents:

• Date range: The date range, if any, entered at the Drop Ship Integration Reports Screen. If you enter a range of dates, the report includes items on purchase orders put on hold within that date range and that are still on hold.

• Vendor number and name

• Vendor telephone number

• Date when the vendor put the line on hold. If the line was on hold more than once, this is the most recent date.

• Sales order number and ship-to extension

• Order line number

• Sold-to customer. The customer’s company name or name (last, first). If the customer has both name and company name, the report lists the company name, with the customer name after the label ATTN. Up to twenty positions.

• Item code

• SKU code, if any

• Quantity

• Extended cost: The vendor’s price for the item, from the PO Detail, Vendor Item, or SKU file, in that order, times the quantity

• Extended price. The retailer’s price for the item (the price charged to the customer), times the quantity

• Purchase order number

• Purchase order line number

• Tel #: The sold-to customer’s evening phone number, if any; otherwise, the daytime phone number

• Item description

• Status of the line: Always Held

• Customer’s email address

• Additional information or hold reason description entered by the vendor. If the vendor has entered multiple reason descriptions, this is the most recent entry.

• Total number of vendor units and purchase order units. These quantities should be the same for Locate, since the Locate Supplier Direct Fulfillment module does not support unit of measure conversion.

Each vendor’s orders start on a new page.