Use this report to forecast sales for up to the next 12 months based on your previous sales history. View expected quantities sold and revenue for each product and location.
Before you start
- Managing Cin7 Core Reports
- This is a Cin7 ForesightAI feature and requires an add-on to your subscription.
- ForesightAI reports require at least 6 months of sales history in Cin7 Core.
Report options
| Reporting period | Select the reporting period from a list of options or set a custom date range. |
|---|---|
| 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 |
| Family | Product family name |
| Product tags | Comma-separated product tags |
| Location | Location name |
| Unit | Product unit of measure |
| Barcode | SKU barcode |
| Product additional attribute 1–10 | Custom product attributes as defined in product settings |
Data headers
| Year | Forecast year |
|---|---|
| Month | Forecast month |
| Sale qty | Quantity sold in preceding 12 month period |
| Forecast qty | Quantity to be sold in upcoming reporting period, according to sales forecast |
| Stock price | Total stock price |
| Sale price | Average sale price |
| Forecast revenue | Predicted revenue from this SKU over the forecast period |
| Reorder quantity | Reorder quantity as configured in the product's low stock reorder settings for this location |
| Minimum before reorder | Minimum stock level before reorder is triggered, as configured in the product's low stock reorder settings for this location |