Planning Expressions for Microsoft Dynamics 365 Business Central
Turning a forecast into a reorder point takes a rule, and a rule applied by hand to hundreds of items is applied inconsistently.
Enhanced Forecasting Worksheet holds planning expressions, formulas on the Enhanced Forecast Setup page, that calculate safety stock, reorder point, reorder quantity, and maximum inventory from variables such as average daily usage, average daily forecast, and lead time.
How Planning expressions works in Enhanced Forecasting Worksheet
- An administrator or planner opens Enhanced Forecast Setup.
- They write an expression for each planning value, using the variables listed in Expression Help.
- Planners calculate a forecast, and each row shows the calculated values.
- Planners apply the values with Update Item Planning.
Key capabilities
Variables
Expressions can use avg_daily_usage, avg_daily_forecast, lead_time_days, forecast_qty, forecast_days, and usage_qty.
Spreadsheet-style formulas
Formulas work much like spreadsheet formulas, with if statements and rounding up, down, or to a precision. For example, round(avg_daily_forecast * lead_time_days + 0.5;1.0) * 2.
A simple starting point
A common reorder point is average daily forecast times lead time in days: enough stock to cover demand until the next order arrives.
Adjust the forecast itself
Formulas can also modify the predicted value, for example to add a percentage on top of the forecast.
Help on the page
Expression Help lists every variable, and Enhanced Forecast Setup links to the Sales and Inventory Forecast Setup page.
Same idea elsewhere
Item Planning Review, also in Enhanced Planning Pack, uses expressions in the same way, with item and stockkeeping unit fields as variables.
See Planning expressions on screen
Real screens from Enhanced Forecasting Worksheet, shown with demo data.
Details that matter on the floor
The rule is written down
A formula on the setup page is the team's planning rule, applied the same way to every item.
Forecast and usage together
Having both forecast and usage variables lets a formula use the forecast for one value and actual usage for another.
Who uses Planning expressions
Inventory managers
Encode the team's safety stock and reorder rules.
Supply chain planners
Tune formulas to the lead times and periods they plan in.
Business Central consultants
Set up expressions that match the customer's planning policy.
Questions about Planning expressions
How do I calculate a reorder point from a forecast in Business Central?
With Enhanced Forecasting Worksheet, write a reorder point expression on Enhanced Forecast Setup, such as avg_daily_forecast * lead_time_days. The worksheet calculates it for each forecast row.
Which variables can I use?
avg_daily_usage, avg_daily_forecast, lead_time_days, forecast_qty, forecast_days, and usage_qty. Expression Help on the setup page lists them.
Can formulas include conditions?
Yes. Expressions work much like spreadsheet formulas and can include if statements and rounding.
What happens if I leave an expression empty?
The setup page notes that deleting an expression's contents results in zero for that value.
Related Enhanced Forecasting Worksheet features
All Enhanced Forecasting Worksheet features →Part of Enhanced Forecasting Worksheet
Precise, customizable inventory forecasting to prevent stockouts and optimize stock levels.
Have a question about Planning expressions?
Send us a note and the Enhanced Forecasting Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
