Skip to main content

Knowledge Center

Sales forecast (FCC)

Sales Forecast (FCC) is a used to create a forecast for estimating future sales, to enable calculating production and purchase requirements.

clip1556.png

To create a sales forecast, upload a comma separated value (CSV) file with details of the forecast. Refer to Load Sales Forecasts (FCC) for the CSV file format. The CSV file can be uploaded from the Import/export Wizard (IOQWIZ).

The FCC displays the following information.

  1. Customer gives the customer number and name. Select right_arow_in_black_box_icon.svg to view more customer information in the Customer (CUS) aoolication.

  2. Customers reference is retrieved from the uploaded forecast.

  3. Customers reference no is retrieved from the uploaded forecast.

  4. Requested delivery date, This is the date by which the customer has requested delivery.

  5. Location gives the location of the product.

  6. Source gives the source of the sales forecast.

  7. Probability percent gives the estimated probability of the order being received as percentage.

  8. Product gives the product number of the product that is forecast to be ordered.

  9. Quantity is the estimated quantity in the order.

  10. Type gives the type of product ordered,

  11. Product description describes the product.

  12. The History tab displays the history of the sales orders.

  13. Sales orders displays all the sales orders belonging to the custome for a specific productr. By default, only the Sales Orders having a requested delivery date as given in the Requested delivery date field are shown. Select X in the Requested delivery eq forcasted request delivery to disable the filter and view all sales orders for the customer.

You can create a Sales Order (COA) from a Sales Forecast (FCC), if the FCC is for a specific customer.

  1. Select Cogwheel_Icon.svg and select Columns.

    2021-02-11_11-17-49.png

  2. Select Sales Order to display the Sales Order column.

  3. Select Plus_Sign_Grey_Back.svg in any row to create a COA from the FCC, if the control is enabled. If the control is disabled, a COA has already been created from that FCC.

    The Sales order column displays the newly created COA:

  4. Select right_arow_in_white_box_icon.svg to open the COA in the COAITEM application.

    2021-02-11_12-40-35.png

Clicking the arrows next to the quantity will open that product in the FCC application where you can see more details and edit if necessary.

clip1557.png

Status descriptions for FCC

  1. ST:4: Forecast for current and future periods

  2. ST:8: Latest forecast for periods in the past. When forecast are uploaded, active forecasts with a Requested delivery date that is earlier than the first Requested delivery date from new forecast are set to Status 8

  3. ST:9: Old and discarded forecast

In this section: