Forecasting Report
Forecasting Report in ERPNext helps manufacturers estimate future demand by analyzing historical business transactions. It uses the Exponential Smoothing forecasting method to predict future sales or production requirements based on past Sales Orders, Delivery Notes, or Quotations.
The generated forecast can be used for production planning, inventory management, procurement, and capacity planning, enabling businesses to prepare for future demand more accurately.
Accessing the Forecasting Report
The report is available from:
Home → Manufacturing → Reports → Forecasting
How Forecasting Works
ERPNext generates forecasts using the Exponential Smoothing statistical method.
The system analyzes historical transaction data and predicts demand for upcoming periods by continuously adjusting the forecast based on previous forecasting errors.
Supported historical data sources include:
- Sales Orders (default)
- Delivery Notes
- Quotations
Each forecasted period becomes the basis for calculating the forecast of the next period, allowing predictions to adapt as new business data becomes available.
Understanding Exponential Smoothing
The Exponential Smoothing method calculates future demand by combining historical demand with a smoothing factor.
The forecasting process works as follows:
- The first forecast value is calculated using the average of historical demand.
- For every subsequent period, the system compares the previous forecast with the actual demand.
- The difference between the actual value and the forecast (forecast error) is multiplied by the Smoothing Constant.
- The adjusted value becomes the forecast for the next period.
This approach allows recent demand patterns to influence future forecasts while still considering historical trends.
System Behavior
The default Smoothing Constant is 0.3, which provides a balanced forecast by giving moderate importance to recent demand changes while maintaining historical trends.
Forecast Filters
The Forecasting report provides several filters to customize the generated forecast.
Company
Limits forecasting to a specific company when managing multiple companies within ERPNext.
From Date and To Date
Defines the forecasting period.
By default:
- From Date is the current date.
- To Date is one year from the current date.
Based On Document
Determines which historical transactions are used for forecasting.
Available options include:
- Sales Orders
- Delivery Notes
- Quotations
Based On
Specifies whether forecasting should be performed using:
- Quantity
- Amount
Based On Data (Years)
Specifies how many years of historical data should be analyzed while generating forecasts.
Using more historical data generally provides better long-term forecasting accuracy.
Periodicity
Forecast results can be displayed using different reporting intervals.
Supported options include:
- Monthly
- Quarterly
- Half-Yearly
- Yearly
Monthly reports primarily display future forecast data to improve report readability.
Smoothing Constant
Controls how strongly recent demand influences future forecasts.
The value must be between:
- 0 — Very stable forecasts with minimal reaction to recent changes.
- 1 — Forecasts react strongly to recent demand changes.
Adjusting this value allows organizations to make forecasts either more responsive or more stable depending on their business requirements.
Operational Note
Forecast accuracy depends on the quality and consistency of historical business data. Organizations with reliable Sales Orders, Delivery Notes, or Quotations typically obtain more meaningful forecasting results.
Business Benefits
- Predicts future demand using historical business transactions.
- Supports production and procurement planning.
- Helps reduce stock shortages and excess inventory.
- Allows forecasting based on quantities or monetary values.
- Supports multiple forecasting time periods.
- Provides flexible forecasting using adjustable smoothing constants.
- Improves long-term production planning and decision-making.
Key Summary
Forecasting Report enables ERPNext users to estimate future demand using the Exponential Smoothing method and historical Sales Orders, Delivery Notes, or Quotations. By providing configurable forecasting periods, historical data analysis, and adjustable smoothing parameters, it helps manufacturers improve production planning, inventory management, and procurement decisions.
