Backorder Report by Warehouse with SKU Details

How to print: Enter Y in the By whse/item and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and press F9. The system submits the program BORWHSITMS. Backorder totals are provided for each SKU and each warehouse.

CWDirect Rel 2.0 Backorder Report by Warehouse w/SKU KAREN_L INR0824 10/17/96 9:35:24 Page 1

The Mail Order Company

S/O Item SKU Description Qty on Qty on Qty on Qty on

B/O P/O Hand Reserve

Warehouse 10 THE MAIN WAREHOUSE

BATHTUB OLD CLAW FOOT TUB 5 10 5 5

Item BATHTUB totals 5 10 5 5

CP10000 DELUXE COFFEE POT 21 610 0 0

Item CP10000 totals 21 610 0 0

LAMP METAL DOME READING LAMP 2 0 30 3

Item LAMP totals 2 0 30 3

RING COPPER LEAF BAND 3 100 122 2

Item RING totals 3 100 122 2

01 SW10000 YELW SMLL LADY'S MOHAIR SWEATER 1 50 0 0

Item SW10000 totals 1 50 0 0

Warehouse 10 totals 33 570 158 11

Final totals 33 570 158 11

Contents:

• Soldout control (a code indicating when the system should consider the item sold out)1

• Item number

• SKU

• Item description

• Warehouse code

• Warehouse description

• Quantity on backorder (cumulative total of all backordered SKUs for the item)

• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)

• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)

• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)

• Subtotals for each base item

• Subtotals for each warehouse

• Final totals across all warehouses




  1. Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; 03 = exclude on order quantity in sold-out calculation.

CS06_01r CWDirect 18.0 August 2015 OTN