Daily forecast

Forecasting  •  Article  •  5/7/2025  • 

The Daily Forecast feature helps you to predict the future production details using the past sales data of a particular period.

You can perform the following functions using this feature:

  • Calculate a Forecast based on the sales history.
  • Calculate a Projected Forecast based on the Forecast or actual sales figures.
  • Calculate a shortage based on the projected forecast, inventory, and actual production plan.
  • Calculate the quantity to produce, and you can update it.
  • Create production orders based on the quantity produced.

To use the above functionality, you need to create Daily Forecast Code and assign it to the items.

Create a Daily Forecast Code

You can create a Daily Forecast Code and History Period based on the below procedures:

  1. Select the Search icon , enter Daily Forecast Codes, and then choose the related link.
    The Daily Forecast Codes list page opens.
  2. On the action bar, select New.
    The Daily Forecast Codes page opens.

  3. On the General FastTab, perform the following steps:

    1. In the Code field, enter a code for the Daily Forecast.
    2. In the Description field, enter a brief description of the Daily Forecast Code.
    3. In the Rounding Precision field, enter the number of decimal places you want to round up.
      The values in the History and Forecast fields are rounded up with respect to the decimal values in the Rounding Precision field.
      The sum of the percentage entered for the Historical Period is shown in the Total Percentage Field.

    4. In the Future Sales Order Date Formula field, enter a day, week, or year value to calculate the Qty. on Future Sales Order field value on the Daily Forecast page.

      The system sets the Qty. on Future Sales Order field value to blank if the Future Sales Order Date Formula field value is empty.

  4. On the Daily Forecast Calculation FastTab, perform the following steps:

    1. In the Historical Period field, enter a negative date formula. For example, -2W, which means two weeks before the forecast data. where, W denotes Week.

    2. In the Percentage field, enter the percentage of sales occurred in the History Period.

      The value of the total percentage can also be more than 100%.
      If you delete a Daily Forecast Code from the Daily Forecast Codes page, the associated line entries are deleted.