Summary Sales Order History

The system generates summary forecasts that are based on data in the Forecast Summary File table (F3400). Use the Refresh Actuals program (R3465) to copy the sales order history (type AA) from the Sales Order History File table (F42119) to table F3400, based upon criteria that you specify.

The system stores sales order histories in table F3400 with forecast type AA or a type code that you designate.

You do not need to clear table F3400 before you run this program. The system automatically deletes any records for the same:

  • Period as the actual sales order histories to be generated.

  • Items.

  • Sales order history type (AA).

  • Branch or plant.

    Note: The Refresh Actuals program (R3465) converts sales orders into the primary unit of measure and adjusts the resulting quantities.

After you copy the sales order history into the Forecast Summary File table (F3400), you should review the data for spikes, outliers, entry errors, or missing demand that might distort the forecast. Revise the sales order history manually to account for these inconsistencies before you generate the forecast.