Displaying Open Orders by Item (DOOI)

Purpose: Use this on-line inquiry to identify orders that contain a specific item and to evaluate item statistics such as quantities ordered and reserved for that item.

You can also use this option to advance to standard Order Inquiry for a specific order, or to find out about pending purchase orders for a backordered item.

Quotes: This menu option also allows you to review item statistics on quotes; see Entering Pre-Order Quotes.

Open Orders by Item Screen (Selecting an Item for Review)

Use this screen to select the item you would like to research for open orders or purchase order information.

How to display this screen: Enter DOOI in the Fast path field or select this option from a menu.

Note: You must enter complete and accurate information in both the Item and the SKU fields if applicable.




Represents a unit of inventory.

Alphanumeric, 12 positions; required.

SKU (Stock keeping unit; an unlabeled field to the right of the item number)

The style of the item, such as its color and size.

Alphanumeric, three 4-position fields; required for any item with a SKU.

Display Open Orders by Item Screen

Use this screen to evaluate open orders for a specific item by quantity, age, and reason for backorder. You can also advance from this screen to standard Order Inquiry for a specific order or display open purchase orders for the item.

How to display this screen: Enter a complete item code and SKU, if any, at the Display Open Orders by Item Screen.



Description (Unlabeled field to the right of the SKU field)

Text that describes the item.

Alphanumeric, 120 positions; display-only

Order #

A unique number that the system assigns each order.

Numeric, 7 positions; display-only.

St # (Ship To Number)

The number of the shipping address for the order. The system assigns a ship to suffix for each shipping address on an order.

Numeric, 3 positions; display-only.

Ln # (Line number)

The item's order detail line number.

Numeric, 3 positions; display-only.

Days old

The age of the order in days.

Numeric, 5 positions; display-only


Three status fields for the order detail line. These fields are:


The quantity of the item on the order line.

Numeric, 7 positions; display-only.


The total reserved quantity of the item on the order line.

Numeric, 7 positions; display-only.


The total quantity of the item on the order line that has shipped to date.

Numeric, 7 positions; display-only.

Rsn cde (Reason code)

Represents the reason the item is on backorder.

Valid values are:

• blank = Order detail line is not backordered.

D = Item is a drop ship item that is not kept in your inventory, and will be sent to the customer directly from your vendor.

F = Item is a future order, as determined by the order's arrival date.

The system will not “tie-up” inventory that can be matched to current orders if the order will not ship for a period of time. The system uses the following calculation to identify future orders:

Arrival date - Reservation lead days = Date

The system will not reserve inventory if the system-calculated date is greater than today's date.

Normally, the Evaluate Future Orders program runs each evening during a periodic process to evaluate each order detail line identified as a “future” order. The system reruns the arrival date calculation and reserves inventory if the system-calculated date is less than or equal to today's date.

I = No Item/Warehouse record or no allocate; you have not defined a warehouse for this item or the warehouse you have assigned to this item is a non-allocatable warehouse.

W = No warehouse specified; you have not identified the warehouse from which you want to reserve the inventory.

N = Non-allocatable warehouse; inventory cannot be shipped from this warehouse.

O = Not enough inventory available in the warehouse to fulfill the entire order quantity.

S = Not selected batch reservation; you are using Batch Reservation (as opposed to Immediate Reservation, which reserves inventory during Order Entry) and you have not run the Batch Reservation program.


B = Reservation bypassed; the customer is excluded from normal reservations (Immediate or Batch Reservation) based on the setting of the Hold/Bypass/Fraud field. You must reserve inventory on a selective basis, using the Interactive Reservation program to reserve or unreserve inventory. Typically, customers who buy in large quantities are set up to bypass reservation so that they do not deplete your available stock when they place their orders. Note: If the Use OROB for Fulfillment Assignment (M31) system control value is selected, the system uses the Bypass reservation flag to send items to Order Broker for fulfillment assignment.

L = SKU Reserve limit exceeded. The customer has ordered a quantity equal to or greater than the item’s Reserve quantity. Any order quantity above this value will not be reserved by the Immediate or Batch Reservation program and must be reserved selectively through the Interactive Reservation program. You may define a Reserve quantity limit for items that you carry in limited quantities or for items that are in great demand.

U = Interactive unreserve; an order detail line can be unreserved when you upload an inventory transaction through the Generic Inventory Transaction Upload, or through Reprinting and Voiding Pick Slips (WVRP or WSVP).

Alphanumeric, 1 position; display-only.


Text that explains the meaning of the backorder reason code.

Alphanumeric, 25 positions; display-only

Screen Option


Display an order

Select Display for an order to advance to Order Inquiry Header Screen or the Order Inquiry Detail Screen, depending on the setting of the Default Version for Order Inquiry (C34) system control value.

Display open purchase orders for an item

Select Display Open POs to advance to the Display Open Purchase Orders Screen.

Display Open Purchase Orders Screen

Use this screen to obtain information about the unreceived or partially received purchase orders for an item. This screen includes the purchase order numbers, vendors, quantities and expected delivery dates for the item.

How to display this screen: Select Display Open POs at the Display Open Orders by Item Screen.



Whs (Warehouse)

The warehouse to which the item will be delivered.

Numeric, 3 positions; display-only.


The number of the purchase order on which the item was ordered from the vendor.

Numeric, 7 positions; display-only

Ln# (Line number)

The line number of item on the purchase order.

Numeric, 3 positions; display-only

Vendor #

A code to identify the supplier of the item. Vendor codes are defined in and validated against the Vendor table. See Working with Vendors (WVEN).

Numeric, 7 positions; display-only.


The name of the vendor associated with the vendor number.

Note: This field is blank if the Vendor Name Display (D41) system control value is unselected.

Alphanumeric, 30 positions; display-only.

Qty due (Quantity due)

The number of units of the item expected in the shipment.

Numeric, 7 positions; display-only.


The date when the shipment of the item is expected.

Numeric, 6 positions (in user date format); display-only.

CS06_02 OMSCS 19.0 December 2019 OHC