Stock Item Details

Stock Item Detail (SID) records define how a stock item is managed in the storeroom as well as tracking quantities for stock items. Each record contains storeroom-specific information for the stock item such as pricing, reorder information, unit of issue, unit of purchase, expense code, and so on.

Every stock item that is to be maintained in the inventory of a storeroom must have a corresponding Stock Item Detail record.

The Stock Item Detail record determines whether or not the type of stock can be purchased, repaired, tracked, and so on. Stock items that need to be ordered only when there is a demand for them require some configuration:

  • Configure the following values in the Reorder Information zone of the stock item detail:
    • Auto Reorder: Yes
    • Order On Demand: Yes

A SID is a particular stock item in a particular storeroom. For example, in one storeroom, a particular stock item might be stored whereas in another storeroom that same stock item might only be direct purchased. The item would have a different SID in each storeroom. In cases where an item can only be direct purchased for activities, the storeroom only acts as the receiving dock and courtesy storage location until the workers from the activity come to pick them up.

The Stock Item Inventory section provides a graphical representation of what is in stock with lines representing maximum quantity and reorder quantity. Use the filters to change the display on the chart. This chart can be changed to show projected inventory (taking into account pending purchases and pending activities), or historical inventory (showing actual inventory use and receipts).

Inventory Details

Inventory Details is an individual widget displayed within the Dashboard which displays the inventory quantities for the selected stock item detail record:

  • Inventory is the quantity currently in the storeroom.
  • Average Unit Price is the average unit price of the stock item detail.
  • Reserved is the physical amount of stock items reserved in inventory. If it is not in inventory, it cannot be reserved.
  • On Demand amounts are used in determining whether inventory can meet future needs. Amounts included in On Demand are “Active” activities with resource requirements and material requests, not referencing an activity, that are in a "Ready to Issue" state.
  • Pending Demand indicates that an “Approved” activity includes a resource requirement.
  • In transfer means stock is being transferred from one storeroom to another. The stock is considered “In Transfer” for the target storeroom after the originating storeroom completes their issue and before the target storeroom actually receives the stock.
  • On Order is the amount derived from an “Issued” purchase order. This is before it has been received and accepted into inventory.
  • Pending Order is the amount derived from an “Approved” purchase requisition before it is turned into a purchase order.
  • Available Quantity is the amount of a stock in inventory plus what is due in (Pending Order, On Order, In Receipt, and In Transfer) and subtracting what is due out (On Demand, and Reserved).