Sales Forecast
The Sales Forecast report uses information in
Sales Forecasts to list the predicted sales of each Item during the report period.
Only the latest Versions of Sales Forecasts that have been marked as OK and not Closed will be included in the calculations.
The report will contain separate columns showing the predicted weekly or sales of each Item during the report period. The duration of each column (weekly or monthly) will depend on the Period Type that you have chosen in the Forecast Settings setting.
- Period
- Paste Special
Reporting Periods setting, System module
- The report will list the Items in Sales Forecasts that begin during the period that you specify here. The report will contain separate columns for each week or month in the period.
- Item
- Paste Special
Item register
- Range Reporting Alpha
- Use this field to restrict the report to a particular Item or range of Items. Only Items that have been used in Sales Forecasts will be included in the report.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- Use this field to restrict the report to Items belonging to a particular Item Group.
- Item Classification
- Paste Special
Item Classifications setting, Sales Ledger
- If you select an Item Classification here, every Item with that Classification that has been used in Sales Forecasts will be included in the report. If you enter a number of Classifications separated by commas, only Items featuring all the Classifications listed will be included. If you enter a number of Classifications separated by plus signs (+), every Item featuring at least one of the Classifications listed will be included. If you enter a Classification preceded by an exclamation mark (!), every Item featuring any Classification except the one listed will be included.
- For example:
- 1,2
- Lists Items with Classifications 1 and 2 (including Items with Classifications 1, 2 and 3).
- 1+2
- Lists Items with Classifications 1 or 2.
- !2
- Lists all Items except those with Classification 2.
- 1,!2
- Lists Items with Classification 1 but excludes those with Classification 2 (i.e. Items with Classifications 1 and 2 are not shown). Note the comma before the exclamation mark in this example.
- !1,!2
- Lists all Items except those with Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Lists all Items except those with Classifications 1 and 2 (Items with Classifications 1, 2 and 3 will not be listed).
- !1+2
- Lists Items without Classification 1 and those with Classification 2 (Items with Classifications 1 and 2 will be listed).
- (1,2)+(3,4)
- Lists Items with Classifications 1 and 2, and those with Classifications 3 and 4.
- 1*
- Lists Items with Classifications beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Lists Items with Classifications beginning with 1 but not 1 itself.
- *1
- Lists Items with Classifications ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Lists Items with Classifications beginning and ending with 1.
- Forecast Class
- Paste Special
Forecast Classes setting, MRP module
- To list predicted sales in Sales Forecasts belonging to a particular Forecast Class, specify that Class here.
- Specify
- Use these options to specify whether the report should show forecast quantities or values for each week or month.
---
Reports in the MRP module:
Go back to:
Introduction to Reports in the MRP Module
