Backorder Report by Vendor/SKU/PO

How to print: Select the By vendor w/PO and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVNDPOS. Backorder totals are provided for each SKU and each vendor.

For more information: See the sample report in PDF format.

Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.

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

• Purchase order number

• Purchase order detail line number (on which the SKU was ordered)

• Purchase order due date

• 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)

• Subtotals for each SKU

• Subtotals for each base item

• Subtotals for each vendor

• Final totals for 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; = exclude on order quantity in sold out calculation.

CS06_01r OMS 17.1 September 2018 OTN