Skip to content

Forecasts Archive

Navigation: Demand → Forecasts Archive

The Forecasts Archive stores all archived forecast lines. The system archives forecast lines automatically whenever a new forecast import is processed, preserving a full history of forecast changes over time.

Purpose

  • Track how the forecast has changed over time at a line level
  • Provide historical data for forecast accuracy analysis
  • Feed the Forecast Over Time and Forecast vs Sales analytics views

Archival Logic

The system uses a composite unique key per forecast line:

Unique Key = Forecast Number + Item Number + Schedule Line Number

On each forecast import:

Scenario Action
Line exists in new data and in Knosc Update quantities, dates, and fields
Line exists in new data but not in Knosc Add as a new line
Line exists in Knosc but not in new data Archive the line (removed from current forecast)

This means the archive accumulates lines that were present in previous forecasts but have since been removed or superseded, giving a complete audit trail of forecast evolution.

Columns

Column set is identical to Forecasts. Key columns:

Column Description
Forecast Number Document identifier
Item Number Item forecast
Customer Number / Name Associated customer
Warehouse Number Planning warehouse
Delivery Date Forecast delivery date
Quantity Ordered Forecasted quantity
Status Archived