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 all active products.
To see stock level details for only products with low stock levels, see Products Low on Stock Report.
To see Lead, Safety, and other values associated with Smart Reordering, try the Inventory Velocity report.
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. |
| 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
My product value SKU has different values for available in Product Availability report and Product Reordering.
That is normal behaviour, it doesn't calculate the "available" in the Reorder report for assemblies, however it does for Product Availability report.
I'm trying to use the Products Reordering Report. Is there a way to filter this report so only products that show up are those where minimum reorder quantity is higher than stock on hand?
You can use the Products Low on Stock report, which only shows products where stock on hand is below minimum order quantity.
We are hoping to make use of the Minimum Before Reorder & Reorder Quantity fields. I am seeing different values for these fields in different places. For example SKU 4015225003127, the Products Reordering report shows a 1 for Minimum Before Reorder and a 2 for Reorder Quantity, however, when I click on the item itself under products, I am seeing a 0 for both of these fields. What is going on?
Check if the product has specific location override for these quantities. You can check this from the Product detail screen and then clicking the Reorder Levels tab.
Still no answer to your question? Please do not hesitate to get in touch with DEAR support.