Calculate daily forecast

Forecasting  •  Article  •  10/8/2024  • 

You can calculate the Daily Forecast based on the History and the Multiplier code using the following procedures:

  1. Select the Search icon
    , enter Daily Forecast, and then choose the related link.
    The Daily Forecast page opens.

  2. On the Options FastTab, perform the following steps:

    • In the Forecast Date field, select a date. This field is filled with the work date by default.
    • In the Forecast Day field, you can view the day corresponding to the value selected in the Forecast Date field.
    • In the Location Code field, select a code from the list.
    • In the Item No. field, select an item from the list.
    • Turn on the Show Shortage toggle to filter and view the daily forecast lines that have a shortage quantity greater than zero.

    After entering the filters, the lines are filtered based on the selected filters.

  3. Select Forecast, and then select Calculate Daily Forecast.
    The Calculate Daily Forecast page opens with the following filters.
    • Forecast Date
    • Item No.
    • Variant Code
    • Location Code
      These fields are filled in from the filter options on the Daily Forecast page.
  4. In the Forecast Date field, select the date on which you want to calculate the forecast.
  5. In the Item No. field, select an item number from the lookup table.
  6. In the Variant Code field, select a code from the lookup table.
    > [!NOTE]
    > The Variant Code field is not a mandatory field, and you can calculate the Daily Forecast with no Variant Code.
  7. In the Location Code field, select a code from the lookup table.

  8. Select OK to start the calculation.
    Based on the above filters, the below list of fields in the Daily Forecast and the Daily Forecast Entry table are updated.
    On the Item Card page of the selected item, ensure that the Daily Forecast Code field is not blank, and that the Blocked and the Sales Blocked fields are disabled.
    For the given Forecast Date and the History Period linked to the Daily Forecast Code of the item, the History, and the Forecast values are calculated based on the Posted Sales Shipments and opened/released sales orders. For each entry of the Item No., Variant, and Location Code, the Daily Forecast is created.
    The Daily Forecast is calculated through the following steps:

    1. Initially, the History is calculated for each customer and Unit of Measure based on the posted sales shipment lines, opened/released sales orders, and the given filters, giving the total Daily Forecast.

      • History = Quantity from Posted Sales Shipment Line x (Percentage of applicable History Period line /100)
      • History (Base) = History in the Base Unit of Measure of the Item.

    2. After the History is calculated, the Forecast is calculated using the Multiplier linked to the Daily Forecast Code, the Customer, and the Item. The calculation is as follows:

      • Forecast = History (Base) x Multiplier
      • Forecast (Base) = Forecast in the Base Unit of Measure of the Item

    3. In the end, the calculated values are rounded with the Rounding Precision value that is defined on the Daily Forecast Code page.