This report shows the current stock level of all active products in all locations. Use this report to see available, on-hand, allocated, on-order, reordered and minimum before reorder quantities. You can also check the stock on hand value and unit cost of products.
- Managing DEAR Reports
- See Calculation of On Hand, Available and Allocated Stock Quantities for more information on how these quantities are calculated.
Table of Contents:
Data from this report can be exported in Excel, PDF or RTF format.
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.
|Product||The name of the product.|
|Unit||Product unit of measure.|
|Family||Product family name.|
|Tags||Comma-separated product tags.|
|Product Additional Attribute 1-10||Values of product additional attributes.|
|Location||Where product is located|
|Barcode||Barcode of the product|
|Quantity On Hand||Quantity on hand now.|
|Available||Stock available for picking. (On Hand - Allocated).|
|Allocated||Stock allocated by pending Production and Sale tasks.|
|On Order||Stock ordered from suppliers/currently being manufactured.|
|Unit Cost||Unit cost of the product stock now in base currency. (Stock on Hand/Quantity on Hand).|
|Stock On Hand||Value of Stock on hand now in base currency.|
|Reorder Quantity||Quantity of the product to reorder as configured for the product.|
|Minimum Before Reorder||Minimum stock level for the product to appear on Reorder stock form.|
|Volume On Hand||Volume on hand now calculated as Product Height * Product Width * Product Length * Quantity On Hand. If dimensions have not been entered for the product, this figure will show as 0.|
I am seeing discrepancies between the values in Stock Level Report and the General Ledger/Balance Sheet. What is causing this?
The most common cause of discrepancy is stock which has been received but not yet invoiced or invoiced and not yet received. Inventory Accrual and Stock in Transit transactions can be enabled from the General Settings. You can check the Transactions VS Stock On Hand Difference Report to find this type of discrepancy.
Hello, when I look at the below two reports for my stock on hand value they are both coming up with a slightly different value. Can you explain why this would be? Product Stock Level Report and Inventory Movement Summary Report.
The Product Stock Level report shows the current stock level of all active products in all locations whereas the Inventory Movement Summary report shows the summary of stock movements in the specified From - To time frame together with the stock on hand value as of the To date field. Inventory movement summary shows value from all products (not just all active products) which can also explain some discrepancies.
A product is not showing in Stock Level Report.
Check if the product in question has been Deprecated. Stock Level Report only shows active products.
If combination of number of active products * location count > 10000, the report will ignore setting to show zero quantities and will only show non-zero. This limitation was designed for performance considerations.
How can I generate a report for stock levels in a certain location?
Please refer to the "Product Stock Level" report. You will be able to filter out the location. See the below screenshot.
If you need stock levels to date wise, I would recommend the Inventory Movement Summary report.
How can I have the inventory with bill of materials show up on the Stock Level Report? Right now it's showing 0, but we have inventory if we account for the bill of materials that creates this item.
Stock Level Report will not include the Availability as per the available components of the bill of materials. On this report, the availability is based on the available physical stock or as per current stock level. Estimation as per available components of the BOM is only available in the Availability Report.
I need a stock list report that shows the Stock Locator Field
Stock Locator field is available in Inventory Movement Details report. Stock Locator Field is not currently available in Stock Level Report.
I was wondering if there was a way to add a date to the Stock Level Report. We are trying to get the levels at year end for tax purposes.
Try the Inventory Movement Summary report for this purpose. It will be able to show you the stock level of each SKU with the value of it as well.