Inventory Tab of Item Review

Use the Inventory tab to view a recap of the inventory item's quantities and to display dialog boxes of data for Quantity on Hand, Quantity on Requisition, Quantity on Order, Quantity Reserved, and Quantity Requested.

Contents

Field Description
Item Number This field displays the item's Item Number, from the General tab of Configuration > Purchasing & Inventory > Items Master.
Category This field displays the item's Category, from the General tab of the Items grid.
Inventory Reorder Point This field displays the item's Inventory Reorder Point, from the Inventory tab of Configuration > Purchasing & Inventory > Items Master.
Inventory U/M This field displays the item's Inventory U/M from the Inventory tab of Configuration > Purchasing & Inventory > Items Master.
Average Actual Cost This field displays the result of the calculation [(Quantity on Hand * Current Average Actual Cost) + (New Unit Cost)]/New Quantity on Hand.
Quantity on Hand

This field displays the total quantity of this inventory item at all locations, as recorded in your enterprise's inventory records.

If the Allow Modify of Locations option is selected on the Inventory tab of Configuration > Purchasing & Inventory > Company Settings, this number is an active hyperlink.

Click the link to open a Quantity by Location dialog box, which displays how this quantity is divided among your enterprise's locations.

Quantity on Requisition

This field displays the total quantity of the item on requisition in all In Progress, Submitted or Approved but not Closed purchase requisitions.

Click the link to open a Purchase Requisitions on the File dialog box, which displays all of these purchase requisitions.

Quantity on Order This field displays the total quantity of the item in all purchase orders. Click the link to open a Purchase Orders on the File dialog box.
Quantity Reserved This field displays the total quantity of the item that is reserved, as entered in item requests. Click the link to open an Items Reserved on File dialog box, which displays all of these item requests.
Net Quantity Available

This field displays the total quantity of this item that is available to be reserved for a project.

DPS populates this field with the result of the calculation Quantity on Hand + Quantity on Requisition + Quantity on Order - Quantity Reserved.

Quantity Requested

This field displays the total quantity of the item that is requested via item requests.

Click the link to open an Items Requested on File dialog box, which displays all of these item requests.