Forecast Management

From ADempiere ERP Wiki
Jump to navigationJump to search


In production use




This functionality allows an estimate of future sales of physical units and / or monetary of the products or services over a period of time, using quantitative and statistical methods based on historical data and market statistics.

The projected quantities and sales amounts are used for decision making, pricing, cash flow, estimated future demand, calculating master production schedule, supply plan and future capacity requirements.


Forecast Sales Management User Guide


Open Forecast

Demand forecasting


Business Dictionary Definition

Design Considerations




  • Is requires having a historic sales by product at least a year to be imported.


Functional Requirements

Functional team

  • Volunteers for analyzing:

Result of review by Mario Calderon, June 16th, 2013

  • Analyzing document ( )
  • Goal of module: to create forecasts that will be considered during execution of MRP. The forecasts can be generated based on different rules and the results can be simulated before being brought into the forecast table.
  • Definition of forecast calendar and forecast periods
    • Automatically, weekwise
  • Generation of sales history, based on different parameters
  • Possibility of importing sales history, created on csv files
    • Import sales history: works (from file into table C_SalesHistory
  • Definition of forecast rules in Application Dictionary
    • Double Exponential Smoothing
    • Simple Exponential Smoothing
    • Triple Exponential Smoothing
    • Polynomial Regression
    • Regression
    • Naive Forecasting
    • Multiple Linear Regression
    • Best Forecast Model
    • Moving Average
  • Forecast definition
    • Lines for different concepts: products, product categories, business partners
    • Factors definable (alpha, beta, gamma)
    • Sequence definable
  • Forecast calculation
    • Forecast is calculated based on parameters and sales history
    • Forecast calculation is possible to run repeatedly
  • Parameters for calculation
    • Forecast definition
      • Forecast rule
      • Calendar
      • Source and target warehouse
      • Base and target period
  • Forecast run result
    • Is a Smart Browser
    • Two filter fields with same name (Period definition): is not clearly explained what they are for; this makes the filtering difficult.
    • Zoom doesn't work
    • Export works
  • Conclusion: accepted

User roles & profiles

  • Sales Manager
  • Product Manager
  • Marketing Manager

Business process definition

User stories

Functional requirements based on business processes

User Interface Mockups


Acceptance criteria

QA and test cases

Development infrastructure

Technical Requirements

Technical team

  • Volunteers for analyzing:
  • Result of analysis:

Data Requirements

Non-Functional Requirements

Open Discussion Items

Closed Discussion Items