This report provides a list of all of your site's Active Stock Parts and can be found under the Inventory Reports category from the left menu.
Below is a sample of what the report may look like:
You may customize your report by choosing which columns are shown and where by selecting the Configuration Icon in the top right. A quick tutorial is shown; for more help see Customizing Reports:
The chart below provides descriptions of the possible columns:
Column | Description |
---|---|
Part ID | The ID Code for the part. See Data Validation Rules for Part IDs for more help as to what characters are allowed. |
Description | Any description for the part. |
Stock Type | Type of stock part this is generally a bearing would have a stock type of BRG |
Unit | Unit of Measure for the Part |
Location | Where the part is located. |
Max / Min Qty | Max and min quantity you would like to have in inventory. |
On Hand | Current on hand quantity. |
Avg Cost | Average Cost of the Part |
Total Cost | Total Cost for the on hand qty of this part (Average Cost * On Hand qty = Total Cost) |
Account | Account that the part is linked to. |
Manufacturer | Manufacturer of the part. |
Manufacturer ID | Manufacturer's ID. |
UPC Code | The barcode for tracking for the part. |
Critical | Whether the part is critical to your organization. |
Auto Purchasing | Whether auto purchasing, SOMAX's automatic purchasing system based on max & mins, is turned on. |
Create Date & By | Date the Part was created and by whom |
Last Issue Date | Date the part was last issued to an asset/work order. |
Last Purchase Price | Cost of the most recent purchase of the part. |
Last Purchase Date | Date of the most recent purchase of the part. |
SKU Count | This is a counter so the report can display the total number of individual active parts |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article