The details tab contains all of the main details for the stock item. The fields on the details tab are:
Item - This is the code that the stock item is identified by. You must enter a code for each stock item, and the code must be unique.
Description - A description of the stock item. You must enter a description for each stock item.
Comments - You can use this field to make any comments about a stock item.
Category - This is the category that the stock item falls into. The category is selected from the list of categories that have been set up in the Stock Categories table.
If the Stock Item is a Material Item an indicator will appear next to the Category field. A Stock Item is a Material Item if the Category for the Stock Item has been flagged as a Material category.
Part Number - This is the part number for this stock item.
Model Number - This is the model number for this stock item.
Issue Unit - The issue unit is the number of units of the stock item that can be issued. For example, you might issue the stock item by the box. The Issue Unit is selected from the list of Issue/Order units that have been defined in the Issue/Order Units table.
Market Price Per Issue Unit - This is the current market cost of the stock item per issue unit. You can type this value in manually. The amount is used to calculate the cost of a purchase order line item for the stock item. This field is also updated by the system when you change the issue unit price on a purchase order line item.
Average Issue Unit Cost - This is the average cost of the stock item per issue unit. You can type this value in manually. This field is also updated by the system when a delivery of the stock item is added. The system will calculate the Average Issue Unit Cost as follows:
New Avg Issue Unit Cost =
Maximum Issue Quantity - This is the maximum quantity of items that can be issued in any one stock issue.
Reorder Level (issue units) - If the quantity of stock on hand, in issue units, falls below the reorder level, then an order for more of the stock item should be raised.
Minimum Stock Level (issue units) - This is the minimum amount of the stock item, in issue units, that should be on hand.
Maximum Stock Level (issue units) - This is the maximum amount of the stock item, in issue units, that should be on hand.
Shelf Life (in weeks) - This is the time, in weeks, that the stock item can be used. Some stock items may have no limit or a very large limit on the shelf life, such as plastic items. However some items, such as food, may only have a limited shelf life.
Government Contract - This indicates whether the stock item is purchased by government contract.
Restricted Item - This indicates whether the stock item is a restricted item.
Non-stock Item - This indicates whether the item is a non-stock item. Non-stock items are items that do not have quantities associated with them. These are used for maintenance work orders.
Asset Item - This indicates whether the stock item is an asset item. If the stock item is an asset item, the system will create asset import records in the asset import table when a delivery of this stock item is made. These can then be imported into the Pinnacle Assets Module through the Asset Import function.
Total Stock - This is current quantity of the stock item on hand, measured in issue units.
Due In - This is the total number of issue units of the stock item that are on order but not yet received. This field is calculated by the system from the purchase orders in the Stock Module.
Due Out - This is the total number of issue units of the stock item that have been requested but not yet issued. This field is calculated by the system from the requests in the Stock Module.
Awaiting Requisition - This is the quantity of the stock item that is required by active work orders but has not been requisitioned yet. This field is calculated by the system from the active work orders in the Work Order Module.
Balance - This is the total stock on hand plus the dues in minus the dues out minus awaiting requisitions.
Stock Value - This is the total stock on hand multiplied by the Average Issue Unit Price.
Requisitioned - This is the quantity of the stock item that has been requisitioned by active work orders. This field is calculated by the system from the active work orders in the Work Order Module.
This Year Usage - This is the actual number of issue units of the stock item that have been issued in the current financial year.
Last Year Usage - This is the actual number of issue units of the stock item that were issued in the last financial year.
This Year Requests - This is the number of requests that were made for this stock item in the current financial year.
Last Year Requests - This is the number of requests that were made for this stock item in the last financial year.
This Year Requisitions - This is the total quantity of this stock item used against completed and finalised work orders in the current financial year.
Last Year Requisitions - This is the total quantity of this stock item used against completed and finalised work orders in the last financial year.
This Year MWAs - This is the number of completed and finalised work orders that this stock item was used against in the current financial year.
Last Year MWAs - This is the number of completed and finalised work orders that this stock item was used against in the last financial year.
Preferred Supplier - This allows you to indicate who is the preferred supplier of this stock item. You may have a few suppliers who could supply you with the same product, however one may be your preferred supplier. This is taken into account when orders are raised.
Order Units - The order unit is the number of units of the stock item that are ordered. For example, you might order the stock item by the box. The Order Unit is selected from the list of Issue/Order units that have been defined in the Issue/Order Units table.
Minimum Order Quantity - This is the minimum number of order units that can be ordered of this stock item when an order for this stock item is raised.
Issue Units per Order Unit - This is the ratio of issue units per order unit. For example, you may order the stock item by the box, but there are ten cartons per box and the stock item is issued to requesters by the carton. This would mean that there are ten issue units (cartons) per order unit (box).
Viewing the Economic Order Quantity