Backorder Summary Report

Purpose: This is an aging report that shows you:

• the number of orders that have not yet had any items shipped

• the number of orders that have already had one or more shipments and are still open

• the corresponding number of days since the order was entered on the system (the number of days that the order has been open)

This information helps you identify the number of days orders remain open waiting for shipment of backordered items. For example, the report shows that you have 383 open orders for which you have already made one shipment, and which are still open four to seven days after order entry.

How to print: Enter Y in the B/O Summary Report field on the Submit Fill Rate Reports Screen.

CWDirect Rel 1.2 B/O Summary Report LEE_H FRR0007 3/08/96 14:07:02 Page 1

Mail Order Company

Aging of:

---------------------------- Days Open ----------------------------

0 - 3 4 - 7 8 - 14 15 - 21 22 - 30 31 - 45 46 +

0 Shipment Orders 1569 214 362 121 152 150 990

1 Shipment Orders 231 383 683 256 399 288 776

2 Shipment Orders 8 26 93 63 109 97 413

3 Shipment Orders 0 0 9 9 31 25 157

4 Shipment Orders 0 0 2 1 3 6 62

5 Shipment Orders 0 0 0 0 1 1 33

6 Shipment Orders 0 0 0 0 0 0 10

7+ Shipment Orders 0 0 0 0 0 0 15

Contents:

Aging buckets: Seven pre-defined aging buckets show the number of days an order has been open on the system (the number of days since the order was entered) and the number of shipments that have been made to date on the order:

• 0-3 days

• 4-7 days

• 8-14 days

• 15-21 days

• 22-30 days

• 31-45 days

• 46 or more days

(This information might indicate that you might not have much movement on orders that have been on the system for a period of time, which might point to a problem with your vendor, purchasing department or projecting demand for items sold in the offer.)

# of shipments: This column breaks out information on the report by the number of shipments that have already been made on each order that is still currently open. Once the order is closed, it is not included in the totals on this report. Ideally, you want to ship an order complete, in one shipment. Otherwise, you start losing money on shipping. The number of shipments reported here are: 1, 2, 3, 4, 5, 6 and 7 or more shipments on an order.

Note: If you pre-bill items: An order that includes a pre-billed item increases the shipment total when the pre-billing occurs. See Pre Billed Amount Item (J72) for a discussion.

FU03_06r CWDirect 18.0 August 2015 OTN