Skip to main content
Answer

Sales Forecast vs MPS forecast

  • June 6, 2025
  • 1 reply
  • 64 views

We are new to Acumatica and still in the learning stages and business processes.  We have used sales forecast in the past along with a production forecast.  How can we still use both and which one is best for our production dept to use?  We want the sales orders to pull from the forecast but not both.

Looking for knowledge and how we can make this work.

Best answer by pauldubuque13

A Forecast is typically what you expect to sell, the MPS (Master Production Schedule) is typically what you plan to make.

The Forecasts can optionally be Consumable (Acumatica calls them Dependent).  If you forecast 100 units next month, but then get a sales order for 20 for that time period, if that Forecast is Dependent, then Acumatica will only forecast 80, if the Forecast is Not Dependent, then the forecasted amount is still 100. 

Master Production Schedules are Not consumable or dependent on sales orders or other demand.

It sounds like you want to use Forecasts.  Forecast can be weekly, monthly or yearly or be a one time forecast amount.  The same Stock Item can have multiple forecasts for the same warehouse or different forecasts for each warehouse.  The forecasts can also be Customer specific.  Forecasts can be manually entered, imported from Excel or using the “Generate Forecast” function based off of prior sales activity.

Note that Items that are Forecasted or Master Scheduled that have subordinate demand (manufacture components or kit components) will also be planned if they are MRP or DRP planned items.

1 reply

Forum|alt.badge.img
  • Acumatica Employee
  • Answer
  • June 6, 2025

A Forecast is typically what you expect to sell, the MPS (Master Production Schedule) is typically what you plan to make.

The Forecasts can optionally be Consumable (Acumatica calls them Dependent).  If you forecast 100 units next month, but then get a sales order for 20 for that time period, if that Forecast is Dependent, then Acumatica will only forecast 80, if the Forecast is Not Dependent, then the forecasted amount is still 100. 

Master Production Schedules are Not consumable or dependent on sales orders or other demand.

It sounds like you want to use Forecasts.  Forecast can be weekly, monthly or yearly or be a one time forecast amount.  The same Stock Item can have multiple forecasts for the same warehouse or different forecasts for each warehouse.  The forecasts can also be Customer specific.  Forecasts can be manually entered, imported from Excel or using the “Generate Forecast” function based off of prior sales activity.

Note that Items that are Forecasted or Master Scheduled that have subordinate demand (manufacture components or kit components) will also be planned if they are MRP or DRP planned items.