Products Low on Stock Report

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


Prerequisite:


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.
SupplierName 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.
BarcodeSKU barcode.
Data Headers
AvailableCurrently available stock. (On Hand - Allocated).
On OrderStock on order.
Purchase PriceProduct Purchase price in Supplier 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.


Did you find it helpful? Yes No

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