PO Expected Delivery Report

Purpose: Use this report to review open purchase order lines that are due to be received within a specified date range.

This report sorts in warehouse/vendor #/PO #/Item/SKU code/due date sequence.

How to print: Press F9 at the PO Expected Delivery List Prompt Screen.

CWDirect Rel 8.5 Expected Delivery KBOTTGER POR0381 6/16/04 13:34:03 Page 1 KAB Co. 6/15/04 thru 6/16/04 Warehouse 10 THE MAIN WAREHOUSE Vendor # Vendor Name P/O # Item SKU Item Desc SKU Description Due Date Open Extension Quantity 9782723 BOTTGER COLLABO 1316 2004IT3M1 WHITE BONE TEACUP 6/16/04 100 500.00 Warehouse 10 Totals 100 500.00 Warehouse 50 RETAIL STORE WAREHOUSE Vendor # Vendor Name P/O # Item SKU Item Desc SKU Description Due Date Open Extension Quantity 9782723 BOTTGER COLLABO 1316 BU76Y 4OZ GLASS TUMBLER 6/16/04 50 250.00 Warehouse 50 Totals 50 250.00 Warehouse 204 204 NE WAREHOUSE Vendor # Vendor Name P/O # Item SKU Item Desc SKU Description Due Date Open Extension Quantity 202 ACME SUPPLIES 1315 2004IT871 SINGLE BUD VASE 6/16/04 1 5.00 202 ACME SUPPLIES 1317 2004S551 RED WMNS LRGE GARDEN GLOVES W COTTON SURE GRI 6/16/04 90 450.00 202 ACME SUPPLIES 1317 2004S551 RED WMNS MEDM GARDEN GLOVES W COTTON SURE GRI 6/16/04 80 400.00 202 ACME SUPPLIES 1317 2004S551 RED WMNS SMLL GARDEN GLOVES W COTTON SURE GRI 6/16/04 70 350.00 202 ACME SUPPLIES 1317 2004S551 YELW WMNS LRGE GARDEN GLOVES W COTTON SURE GRI 6/16/04 60 300.00 202 ACME SUPPLIES 1317 2004S551 YELW WMNS MEDM GARDEN GLOVES W COTTON SURE GRI 6/16/04 50 250.00 202 ACME SUPPLIES 1317 2004S551 YELW WMNS SMLL GARDEN GLOVES W COTTON SURE GRI 6/16/04 40 200.00 Warehouse 204 Totals 391 1955.00

Contents:

• Date range: The date range you entered at the PO Expected Delivery List Prompt Screen, limiting the report to open purchase order lines whose Due date falls within this date range.

• Warehouse: The code and description of the warehouse expected to receive the inventory on the purchase order line. This is the Whs field in the PO Detail file.

For each purchase order line in the PO Detail file whose Status is O (open) and whose Due date falls within the report’s PO due date range.

• Vendor #: The vendor number associated with the open purchase order line. This is the Vendor # field in the PO Detail file.

• Vendor name: The name of the vendor associated with the open purchase order line.

• P/O #: The purchase order number containing the open purchase order line. This is the P/O # field in the PO Detail file.

• Item: The code for the item on the open purchase order line. This is the ITM number field in the PO Detail file.

• SKU: The SKU code for the item on the open purchase order line. This is the SKU code field in the PO Detail file. Note: This field displays only if you selected to Print SKU details at the PO Expected Delivery List Prompt Screen.

• Item description: The first 25 positions of the description of the item on the purchase order line. If you selected to Print SKU detail, only the first 15 positions of the item description displays.

• SKU description: The first 15 positions of the description of the SKU on the purchase order line. Note: This field displays only if you selected to Print SKU details at the PO Expected Delivery List Prompt Screen.

• Due date: The date the open purchase order line is due to be received. This is the Due date field in the PO Detail file.

• Open qty: The open quantity on the open purchase order line that is expected to be received within the report’s date range. The system uses this calculation for open purchase order lines in the PO Detail file whose Date date falls within the report’s date range: order qty - rec qty = open qty. Note: If you did not select to Print SKU details, the Open qty represents the quantity on all open purchase order lines in the PO Detail file for the same P/O #, Vendor #, Due date, and ITM number.

• Extension: The extended cost of the items on the open purchase order line. The system uses this calculation for open purchase order lines in the PO Detail file whose Due date falls within the report’s date range: Price - (Unit Dsc amount + PDT unit discount amt 1 + PDT unit discount amt 2 + PDT unit discount amt 3) x Open qty = extension. Note: If you did not select to Print SKU details, the Extension represents the extended cost on all open purchase order lines in the PO Detail file for the same P/O #, Vendor #, Due date, and ITM number.

• Warehouse totals: Open quantity and Extension totals by warehouse.

• Open quantity: The total open quantity across all open purchase order lines that are expected to be delivered to the specified warehouse within the report’s date range. The system uses this calculation for open purchase order lines in the PO Detail file for the specified Whs whose Date date falls within the report’s date range: order qty - rec qty = open qty

• Extension: The total extended cost across all open purchase order lines that are expected to be delivered to the specified warehouse within the report’s date range. The system uses this calculation for open purchase order lines in the PO Detail file for the specified Whs whose Due date falls within the report’s date range: Price - (Unit Dsc amount + PDT unit discount amt 1 + PDT unit discount amt 2 + PDT unit discount amt 3) x Warehouse total open qty = extension