How To Create Sales Forecasts
A forecast is demand you expect from a customer before the order exists. Enter forecasts one by one or import the customer's forecast file, then include them in MRP so you buy and build ahead.Updated Nov 9 2026
Before you start
- The Forecasts menu appears only when the Show Forecasts setting is on (next section).
- Forecasts is under Sales and needs the Sales role.
- Changing a config setting needs the Admin role and the Can Edit Config Settings permission.
- Including forecasts in MRP is done on the MRP screen, which needs the Purchasing or PurchasingOnly role.
-
Turn on forecasts
- Go to Admin > Config Settings > Config Settings.
- Type
Show Forecastsin Name and click Submit. - Type
1in the setting's Value box and click Set. Cetec shows Config updated: Show Forecasts. - Reload the page. The Forecasts menu appears under Sales; if it doesn't, log out and back in.
-
Create a forecast
- Go to Sales > Forecasts > Forecast List. The page is titled Forecasts.
- Click Create. The Create Forecast window opens.
- Search for the Customer, pick it, and click Add Forecast. Cetec opens the new forecast.
- Fill in the forecast:
- Part – search for the part and pick it; type a revision in the box beside it to forecast a particular one.
- Quantity and Date (when it will be needed).
- Location – required.
- Name and Customer Part – optional.
- Choose the Transaction Code:
- Stock (the default for a new forecast) – demand for the part itself only.
- Build – demand for the part's BOM components too. Tick Recursive BOM to include every level of sub-assemblies and components. Recursive BOM is greyed out for Stock.
- Click Submit. Cetec shows Forecast updated successfully. For a Build forecast a FORECAST SPECIFIC BOM section appears below, where you can change the components for this forecast only.
-
Import a customer's forecast
Importing is the usual way to load a customer's forecast covering many parts and dates.
- On Sales > Forecasts > Forecast List, click Import Forecast (or go to **Sales > Forecasts
- In Customer For Import, search for the customer and pick it.
- Choose your .xls or .csv file and click Import File (for a CSV, enter the CSV Delimiter, which appears once you've chosen the file). Or click Input Text, paste the rows, and click Import Text. Up to 10,000 rows; password-protected files aren't supported.
- Valid columns are Name, Prcpart, Custpart, Quantity, Due_Date, Resale, BOM, Recursive BOM, Revision and Project Id. None is required, but rows without a Prcpart or Custpart are ignored.
- In the preview, set each column's type from its drop-down (they all start at (identify column)) and untick Use? on rows you don't want, including your header row.
- Tick Delete All Prior Forecasts For customer? to replace the customer's previous forecast, and Use Current Rev On Parts If Other Revision Not Specified? if you want the current revision. Check Location.
- Click Update to check the file, then Finish. Cetec shows Data (n) Imported! on the Forecast Overview page. The new forecasts are listed on Sales > Forecasts > Forecast List.
-
Include forecasts in MRP
- Go to Purchasing > MRP > MRP - All.
- Tick Include Forecasts In Next Allocation Run?. This applies to everyone's planning, not just yours.
- After the next allocation run, click Refresh. Forecasts now show as demand in MRP and in the part waterfall.