Forecast demand
Anticipate demand before orders exist.Updated Nov 5 2026
Who this is for
Sales and buyers enter what customers are expected to order. Production planners and buyers then plan material and capacity around it before the orders arrive.
Applies to
Why it matters: parts with long lead times must be bought before the order exists. Without a forecast, MRP only sees real orders — by then it may be too late.
-
What demand you are forecasting
- Know the customer, the part, the quantity and the date it will be needed.
- Decide whether it will ship from stock or be built to order.
-
Create the forecast
- Open
Sales > Forecasts > Forecast List. The screen is headed Forecasts. - Click
Create. In a narrow window the list's buttons,Createincluded, can be cut off at the right. - In the Create Forecast window, search for the customer, pick it, and click
Add Forecast. Cetec opens the new forecast. On the older Forecast List, search for the customer on the list and clickAdd Forecast.
- Open
-
Fill in the part, quantity and date
- On the forecast's edit screen, search for the
Partand pick it. Enter a revision in the box beside it if you forecast a particular one. - Enter the
Quantityand theDateit will be needed, and check theLocation. - Choose
StockorBuildinTransaction Code, and tickRecursive BOMif its sub-assemblies should be forecast too. - Click
Submit. Cetec says Forecast updated successfully. - To remove a forecast that won't happen, open it and click
Delete.
- On the forecast's edit screen, search for the
-
Make planning count it
- Ask a buyer or planner, someone with access to MRP, which is a Purchasing screen, to open
Purchasing > MRPand tickInclude Forecasts In Next Allocation Run?. - After the next allocation run, they refresh MRP. See Plan what to buy. Forecasts now show as demand.
- Ask a buyer or planner, someone with access to MRP, which is a Purchasing screen, to open
-
Check what the forecast is short
- On the Forecast List, click
Refresh Forecast Short Flags. Cetec opens the older Forecast List and says Forecast Short Flag Updated. - Look for forecasts marked
Short?=Yes. - Open
Sales > Forecasts > Overview(headed Forecast Overview) to see how many forecasts each part has.
- On the Forecast List, click
Other ways to do this
Import a forecast file
For a customer forecast covering many parts and dates.
- Open
Sales > Forecasts > Import. - Pick the
Customer For Importfirst. - Choose the file (.xls or .csv), or paste the rows with
Or, Import Text. The screen lists the columns it accepts (Name, Prcpart, Custpart, Quantity, Due_Date and so on), up to 10,000 rows. - Check the preview and column matching, and finish the import.
- Continue at Make planning count it.