Skip to main content
Try for free

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
Purchasing
Sales
Production

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.

  1. What demand you are forecasting

    1. Know the customer, the part, the quantity and the date it will be needed.
    2. Decide whether it will ship from stock or be built to order.
  2. Create the forecast

    1. Open Sales > Forecasts > Forecast List. The screen is headed Forecasts.
    2. Click Create. In a narrow window the list's buttons, Create included, can be cut off at the right.
    3. 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 click Add Forecast.
  3. Fill in the part, quantity and date

    1. On the forecast's edit screen, search for the Part and pick it. Enter a revision in the box beside it if you forecast a particular one.
    2. Enter the Quantity and the Date it will be needed, and check the Location.
    3. Choose Stock or Build in Transaction Code, and tick Recursive BOM if its sub-assemblies should be forecast too.
    4. Click Submit. Cetec says Forecast updated successfully.
    5. To remove a forecast that won't happen, open it and click Delete.
  4. Make planning count it

    1. Ask a buyer or planner, someone with access to MRP, which is a Purchasing screen, to open Purchasing > MRP and tick Include Forecasts In Next Allocation Run?.
    2. After the next allocation run, they refresh MRP. See Plan what to buy. Forecasts now show as demand.
  5. Check what the forecast is short

    1. On the Forecast List, click Refresh Forecast Short Flags. Cetec opens the older Forecast List and says Forecast Short Flag Updated.
    2. Look for forecasts marked Short? = Yes.
    3. Open Sales > Forecasts > Overview (headed Forecast Overview) to see how many forecasts each part has.

Other ways to do this

Import a forecast file

For a customer forecast covering many parts and dates.

  1. Open Sales > Forecasts > Import.
  2. Pick the Customer For Import first.
  3. 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.
  4. Check the preview and column matching, and finish the import.
  5. Continue at Make planning count it.