Overstock Report
Use this report to see which items are overstocked and which items are likely to cause stockouts. Identify overstocked products to reduce inventory on hand and see how many days of sales are required to reduce overstock to optimum inventory levels.
Prerequisites
This is a Cin7 ForesightAI report and requires an add-on to your subscription
ForesightAI reports require at least 6 months of sales history in Cin7 Core.
Report options
Layout |
Set to the default layout or select from a saved layout. |
Save layout as |
Save 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 Cin7 Core Reports - Filtering Reports for more detailed information about using filters.
Export report data to Excel, PDF, or RTF.
Report fields
The following fields are available for this report. Open the Configure Layout menu to view all available fields.
Fields | |
SKU |
Product SKU |
Product |
The name of the product |
Brand |
Product brand |
Category |
Product category |
Family |
Product family name |
Product Tags |
Comma-separated product tags |
Location |
Location name |
Unit |
Product unit of measure |
Supplier |
Supplier associated with this product |
Barcode |
SKU barcode. |
Min. before reorder qty |
The reorder minimum threshold for the product. When quantity is below this level it will appear on the 'reorder stock' form. |
Reorder qty |
Reorder quantity for the product |
Data headers | |
Optimum qty |
The recommended quantity on hand of this SKU to satisfy upcoming sales demand forecast |
On hand qty |
Current inventory on hand |
Overstock qty |
Quantity of overstock items |
| Overstock value | Value of overstock items. |
| Days to optimum | No. of days to go from current stock level to optimum quantity of the item according to sales forecast |