Products Stock Level Report

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.


Prerequisite:


Table of Contents:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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. 


Output:

The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report. 


Fields
LocationLocation name.
SKUProduct SKU.
ProductThe name of the product.
UnitProduct unit of measure.
Brand
Product brand.
Category
Product category.
Family
Product family name.
TagsComma-separated product tags.
Product Additional Attribute 1-10
Values of product additional attributes.
LocationWhere product is located
BarcodeBarcode of the product
Data Headers
Quantity On HandQuantity on hand now.
AvailableStock available for picking. (On Hand - Allocated). 
AllocatedStock allocated by pending Production and Sale tasks.
On OrderStock ordered from suppliers/currently being manufactured.
Unit CostUnit cost of the product stock now in base currency. (Stock on Hand/Quantity on Hand). 
Stock On HandValue of Stock on hand now in base currency.
Reorder QuantityQuantity of the product to reorder as configured for the product.
Minimum Before ReorderMinimum stock level for the product to appear on Reorder stock form.
Volume On HandVolume 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. 


FAQs

[back to top]


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.





Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.