Backorder Report by Vendor with SKU Details

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

CWDirect Rel 2.0 Backorder Report by Vendor w/SKU KAREN_L INR0843 10/17/96 10:46:42 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

Vendor # 1 MIRANDA

RING COPPER LEAF BAN 3 100 122 2

Item RING totals 3 100 122 2

Vendor # 1 totals 3 100 122 2

Vendor # 2 BERNADETTE

BATHTUB OLD CLAW FOOT TUB 4 10 35 5

Item BATHTUB totals 4 10 35 5

LAMP METAL DOME READING LAMP 1 0 30 3

Item LAMP totals 1 0 30 3

Vendor # 2 totals 6 10 36 9

Vendor # 10002 2ND VENDOR

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

Item SW10000 totals 1 50 0 0

Vendor # 10002 totals 1 50 0 0

Vendor # 10003 3RD VENDOR

CP10000 DELUXE COFFEE POT 21 610 0 0

Item CP10000 totals 21 610 0 0

Vendor # 10003 totals 21 610 0 0

Contents:

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

• Vendor number

• Vendor description

• Item number

• SKU

• Item 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 vendor

• Final totals across all vendors




  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