The Enhanced Forecasting Worksheet from Insight Works gives planners and consultants direct control over how forecast data translates into actionable inventory parameters. This addresses a common gap in standard Business Central setups: Azure ML predictions arrive but lack a tailored application for specific item behaviors.
Planners often face demand that varies by item type, location, or supplier lead times. Standard forecasts provide quantities per period, but they do not automatically adjust safety stock, reorder points, or maximum inventory to reflect real operational constraints. Without customization, you end up with generic parameters that either trigger frequent stockouts on fast-moving items or build up excess on slower ones.
Why do standard Business Central forecasts lead to stockouts or excess inventory?
In Business Central, the Sales and Inventory Forecast extension generates predictions via Azure ML and displays them in fact boxes or entries. However, applying those predictions to planning requires separate steps, and item cards retain static or manually entered values for the Planning FastTab fields.
Lead time logic pulls from SKU, Item, or Vendor cards in a defined hierarchy, but forecasts themselves do not dynamically feed into reorder calculations unless extended. This misalignment increases manual review time, risks service-level drops, and ties up cash in inventory.
How does the Enhanced Forecasting Worksheet give control over reorder logic?
The Enhanced Forecasting Worksheet changes this by letting you define expressions that incorporate both historical usage and forecasted quantities. You set these once on the Enhanced Forecast Setup page, and the worksheet evaluates them for each item and period when you calculate the forecast.
Use available variables such as avg_daily_usage, avg_daily_forecast, lead_time_days, forecast_qty, and forecast_days.
Examples include:
Safety Stock Expression: avg_daily_usage
Reorder Point Expression: avg_daily_forecast * lead_time_days
Maximum Inventory Expression: avg_daily_forecast * lead_time_days * 2
Reorder Quantity Expression: forecast_qty
These expressions evaluate automatically in the worksheet.
How do you apply customized forecast logic to item planning in Business Central?
Open the Enhanced Forecasting Worksheet. Set filters and define periods. Select Calculate Forecast. The worksheet populates lines with Azure ML forecast_qty per item and period, plus columns for Safety Stock Quantity, Reorder Point, Maximum Inventory, and Reorder Quantity.
Select Update Item Planning to write the calculated values directly to each item’s Planning FastTab. After updating, run the standard MPS or MRP; suggestions now reflect customized logic based on the latest forecast.
Start with default expressions on a test subset of items to compare against current manual settings. Adjust one variable at a time and observe how it affects reorder suggestions. This method gives precise, repeatable control that scales with changing demand patterns.
The Enhanced Forecasting Worksheet is free for one named user per Business Central environment. Additional users require a paid subscription. No time limits or feature restrictions apply to the single-user license.
Disclaimer: This content is shared for informational purposes and is not promotional.
Top comments (0)