Overstock report
Overview
The Overstock report details which items are overstocked. Identify overstocked products to reduce inventory on hand and see how many days of sales are required to reduce overstock to optimum inventory levels. You can take insights from this report to reallocate stock to better performing branches, discount overstocked items, and limit buying more.
ForesightAI reports are updated daily so the information may be different to other Cin7 Omni reports. ForesightAI does not review Non Stock products.
You will need to install ForesightAI to access this report. This is an additional cost to your Cin7 Omnisubscription.
We recommend at least 6 months of sales history in Cin7 Omni.
Open Overstock report
After you have installed ForesightAI, you can view all ForesightAI reports in Cin7 Omni.
Select Insights in the navigation.
Select the Retail Reports Dashboard. You should see all reports under the ForesightAI section.
Overstock report columns
The Overstock report includes a range of Cin7 Omnifields and ForesightAI observations. These ForesightAI fields can help you manage your overstocked items.
| ForesightAI column | Description |
| Demand Segment | Shows if the overstocked product is a Winner, Loser, or Chaser. |
| Days To Optimum | Calculates the number of days until the stock returns to a healthy level. This is based on your previous sales. |
| Optimum Qty | Estimates the ideal stock quantity to meet future sales demand. |
| Stock Qty | Shows your available stock. This may be different than Cin7 Omni available stock amount because ForesightAI updates daily. |
| Sale Price | This is the Unit Cost (rounded) for the overstocked item. |
| Overstock Qty | Calculates the amount of overstocked items (Stock Qty - Optimum Qty). |
| Overstock Value | Calculates the value of the overstocked items (Unit Cost * Overstock Qty). |
Other Omni fields include Supplier, Brand, Barcode, Project Name, Branch, Code, and Product Name.
These insights are based on AI recommendations and estimates so you may see some variances.
Remove fields, filter, or export the report
Refine your report by removing, filtering, or sorting fields. You can also create an Excel spreadsheet from this report by selecting Export to Excel file. If there is a lot of data in a report, you may receive this option before the page loads.
You can drag columns to add more fields to the report or change the layout of the report. Cin7 Omni reports use a pivot grid. Alternatively, you can use the Field Chooser to filter results, remove fields, and change the layout.