This report shows stock level details necessary for stock refill. Use this report so see available, on order, reorder and minimum before reorder quantities as well as purchase price for active products with stock levels below the minimum before reorder quantity.
To see stock level details for all active products, check the Products Reordering Report.
If you are using DEAR's smart reordering function, you should use the Inventory Velocity Report.
Only users with the Inventory Reporting permission can access this report.
Products Low on Stock Report can be generated and circulated automatically using Report Scheduling.
Prerequisite:
Table of Contents
Data from this report can be exported in Excel, PDF or RTF format.
Input:
| 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.
Output:
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.
| Fields | |
| Location | Location name. |
| SKU | Product SKU. |
| Product | The name of the product. |
| Unit | Product unit of measure. |
| Supplier | Name of the supplier who is associated with the product. |
| Brand | Product brand. |
| Category | Product category. |
| Family | Product family name |
| Product Tags | Comma-separated product tags. |
| Supplier Additional Attribute 1-10 | Values of Additional supplier attributes. |
| Product Additional Attribute 1-10 | Values of product additional attributes. |
| Barcode | SKU barcode. |
| Data Headers | |
| Available | Currently available stock. (On Hand - Allocated). |
| On Order | Stock on order. |
| Purchase Price | Product Purchase price in Supplier 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. |
FAQs
Why is my product not appearing on this report?
Products only appear on the Product Low on Stock Report if Reorder Quantity is defined and stock level is below minimum reorder quantity. If you have reorder quantities set to specific locations, you must ensure the Minimum Before Reorder field on the product detail screen is not left blank. You can use the Product Reordering report to see all products including those with no minimum reorder quantity specified.
Can you tell me how I would deal with a product that we only required 1 in stock of?
You can add the "Minimum before reorder" value to be as "1". This way it will appear correctly in the Report.
I am trying to run a Products Low on Stock report for the overall company. However, the report is giving me results by location and not for the company as a whole. I removed the "Location" filter, but it is still not yielding the correct results.
Product low on stock report shows all products which are below the specified reorder point. If reorder point is specified on multiple locations, the product will be shown for multiple locations and not for the company as a whole. This is by design. You can move the Location field to the final column of the report to see required numbers for SKU more clearly.
You may wish to try Product Stock Level Report, Products Reordering report or Product Availability report, which can show company-wide stock
Please tell me why some products are being listed when their 'Available' quantity is greater than the 'Minimum Before Reorder' quantity levels.
This can occur when multiple suppliers are mapped to a single product. If there is more than one supplier, Low on Stock Reorder report will show 1 line per supplier mapped as any one of the supplier can be used to reorder. Make sure the Supplier field is included in the report and take only the quantity per supplier.
Still no answer to your question? Please do not hesitate to get in touch with DEAR support.