Stocking Points Tab for Part Numbers
Updated
by
Cheryl Wallace
This tab gives an overview of the total number of inventory at each location. All stocking locations are listed. For each location, you can define the minimum and maximum quantities for the part number.
Fields on this tab include:
Inventory Location | One row appears for each stocking location. Non-stocking locations that are parents to stocking locations are included as summary rows. |
Qty On Hand | The quantity on hand for the part at the location. System-generated, read-only. |
Issued | The quantity of the part currently issued from the location. System-generated, read-only. |
In Transit Inbound | The quantity that have been transferred from another location but not received at the destination. System-generated, read-only. |
Reserved | The quantity reserved on requisitions for the location. System-generated, read-only. Reservations can cause a negative Quantity on Hand value as the reserved quantity is deducted from the Total. This means that for a serialized part number, while you might have multiple items In Stock, the Qty On Hand could not reflect the number of those In Stock items. |
In Kit | The quantity of this part designated as a kit component and not available for individual issue for this location. System-generated, read-only. |
Total | The total quantity belonging to the location. Calculated as the QOH + Issued + In Transit Inbound + Reserved + In Kit. System-generated, read-only. |
In Transit Outbound | The quantity that have been transferred from the location but not received at the destination. System-generated, read-only. |
On Transaction Requisition | The quantity on non-reservation requisitions. System-generated, read-only. |
On Transfer Request | The quantity on unapproved transfer requests. System-generated, read-only. |
On Purchase Requisition | The quantity on unapproved purchase requisitions. System-generated, read-only. |
Min On Hand | Enter the minimum quantity of the part required for the location. Used with the Purchasing module to recalculate reorder quantities. Also appears on the Low Inventory report. |
Max On Hand | Enter the maximum quantity of the part required for the location. Used with the Purchasing module to recalculate reorder quantities. Also appears on the Low Inventory report. |
Bin Shelf | Editable for non-serialized part numbers only. Enter where the part is stored within each stocking point. Examples include Cabinet 1, R2S5, SeaCan 4 and Laydown Yard. |
On Order | The quantity on outstanding purchase orders for this location. System-generated, read-only. |
Issued To Date | The total number of cumulative issues for the part at this location. System-generated, read-only. |
Peak Usage | The highest number of this part that were issued at one time for this location. System-generated, read-only. |
Last Count Date | The last time a physical inventory was performed for this part at this location. Updated when a count is closed. Read-only. |
Last Count Qty | The quantity counted for this part last time a physical inventory was performed at this location. Updated when a count is closed. Read-only. |
Vendor | A system-generated read-only field. Updated by the Purchasing module. |
Last Received | A system-generated read-only field. Updated by the Purchasing module. |
Last Cost | A system-generated read-only field. Updated by the Purchasing module and adding serialized items or inventory adjustments. |
Average Cost | A system-generated read-only field. Updated by the Purchasing module and adding serialized items or inventory adjustments. |
Project Cost | Enter the cost to the project for this part. The Project Cost is a separate cost field, unrelated to the Last Cost and Average Cost. The Project Cost is not included in calculations and is generally not used on reports. This field is visible even to users who do not have the Access Actual Cost flag set. |
See also:
Copyright © 2020-2023 ToolHound Inc. All Rights Reserved.