1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Inventory contract balance enquiry...

Inventory contract balance enquiry (DSR23201)

Related topics

This enquiry displays the balances for all inventory contract lines, per inventory contract, regardless of the status, available quantity, start and end dates.

Options

Details Select this option to access the Inventory contracts enquiry to view the inventory contract line details.
Contract header Select this option to access the Inventory contracts enquiry to view the inventory contract header information.

Selection fields

Item
Displays the item and item description on the inventory contract line.
Unit
Displays the unit for the item.
Whs
This column lists the warehouse code for the inventory contract line.
Type
This column lists the inventory contract type for the inventory contract line.
Inventory contract
This column lists the identity of the inventory contract.
Line
This column lists the inventory contract line number.
Description
This column lists the description of the inventory contract.
Available qty
This column lists the available quantity (in stock unit) for the inventory contract line.
Active
This column denotes if the inventory contract is active.
Status
This column displays the status of the inventory contract line.

The following statuses could be displayed:

Status Description
N (New) The inventory contract line is new but no order for the line has been created yet. The inventory contract line will immediately receive this status as soon as it is created, even if the inventory contract itself has not been activated.
O (Open) Order has been created for the line on the contract.
C (Closed) The inventory contract line is closed which means that orders can no longer be created for this line. The inventory contract line receives this status when the entire contracted quantity for the line has been consumed.
Start date
This column displays the start date of the inventory contract line, if any was defined during the set-up of the line.
End date
This column displays the end date of the inventory contract line, if any was defined during the set-up of the line.
Reception date
This column displays the reception date of the inventory contract line denoting that it has been initialized (i.e. available for use which can be a sale and/or other CMI processes depending on the inventory contract type).
Contract unit qty
This column lists the contracted quantity (in stock unit) for the inventory contract line.
Qty on purchase order
This column lists the quantity (in stock unit) that is not yet received for purchase orders on the inventory contract line. It can be internal orders (IRO) or external orders. The field is updated when a purchase order related to the inventory contract is created, changed or received into stock.
Stock on hand qty
This column lists the stock on hand quantity (in stock unit) for the inventory contract line.
Qty on reservation
This column lists the reservation quantity on a sales order (in stock unit) for the inventory contract line.
Consumed qty
This column lists the quantity (in stock unit) that has been consumed for the inventory contract line.
Qty disp not invoiced
This column lists the quantity (in stock unit) that has been dispatched but not yet invoiced for the inventory contract line.
Qty on return order
This column lists the quantity (in stock unit) that has been entered on a return order to the supplier for the inventory contract line.