Drop Ship Integration Items Revised Due Date Report

Purpose: This report lists open CWCollaborate or Locate drop ship items waiting to be fulfilled which have had their due dates revised by the vendor.

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

CWDirect Rel 17.0 Drop Ship Integration Items EKAPLAN FLR1009 1/22/14 10:23:09 Page 1

EZK Mail Order

REVISED DUE DATES

From: To:

Vendor 3 AVIAN SUPPLY Telephone (508) 111-1111

Revised Original Sales Order# Line# Sold To Item SKU Qty Ext Cost Ext Price

1/26/13 12/26/13 5933 - 001 4 COMMERCIALWARE ATTN: MOUS BR123 LRGE 1 1.68 3.60

PO# 1093 - 2 Tel#: BIRDIE BREAD Status: In Process

Email: mmouse@commercialware.com

-------------------------------------------------------------------------------------------------------------------------------

2/06/14 2/01/14 200783 - 001 1 DECKER INDUSTRIES ATTN: D MILLET 1 10.01 5.00

PO# 2181 - 1 Tel#: 6 OZ. PACKAGE MILLET SPRAYS Status: In Process

Email:

-------------------------------------------------------------------------------------------------------------------------------

2/28/14 2/05/14 200808 - 001 1 MITTENS, JACK MILLET 1 10.01 5.00

PO# 2209 - 1 Tel#: 6 OZ. PACKAGE MILLET SPRAYS Status: Held

Email:

------------------------------------------------------------------------------------------------------------------------------

Vendor units: 3

Total units: 3

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 originally submitted to Locate for processing within the range of dates.

• Vendor number and name

• Vendor telephone number

• Revised due date

• Original due 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. A blank status on the report indicates that the line is currently in New Order status in Locate.

• Customer’s email address

• Additional information or change reason description, if any, 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.

FU07_05r CWDirect 18.0.x 2018 OTN