Item Usage Chart and Planning History for Microsoft Dynamics 365 Business Central
A suggested purchase quantity that does not match what the item actually sells is easy to miss when history lives on a different page. Planners end up approving numbers they have not checked, or spending time looking up ledger entries.
Enhanced Planning Worksheet adds History and Chart tabs below the worksheet lines. History shows sales and purchase history as a table, and Chart shows an item usage chart by month for the selected line.
How Item usage chart and planning history works in Enhanced Planning Worksheet
- The planner selects a planning line with a suggested quantity to check.
- The planner opens the History tab for the table of sales and purchases, or the Chart tab for the monthly item usage chart.
- The planner compares the suggested quantity with past usage.
- If the planning parameters are out of line with usage, the planner corrects them on the Planning tab and recalculates.
Key capabilities
History as a table
The History tab lists sales and purchase history for the selected line's item, so a planner can compare the suggestion with what was actually sold and bought.
Item usage chart
The Chart tab draws an item usage chart by month. Bars show sales, and the legend separates production usage, transfers, negative adjustments, and purchase, production, and adjustment activity.
Seasonality at a glance
A monthly chart shows peaks and quiet months, which helps a planner judge whether a reorder point or maximum quantity suits the season.
Correct what looks wrong
When the history shows the suggestion is off, the planner opens the Planning tab and changes the reorder point or other planning fields with inline planning edits.
See Item usage chart and planning history on screen
Real screens from Enhanced Planning Worksheet, shown with demo data.
Details that matter on the floor
Usage, not only sales
The chart separates sales from production usage, transfers, and negative adjustments, so an item that is consumed rather than sold still shows its real demand.
Same screen as the fix
History, chart, and planning fields sit in tabs under the same lines. Finding a mismatch and correcting it happen without leaving the worksheet.
Who uses Item usage chart and planning history
Inventory planners
Check a suggested quantity against months of real usage before approving it.
Purchasing managers
Spot seasonal items whose maximum quantity needs to change.
Supply chain analysts
Review usage trends for items that keep generating suggestions.
Questions about Item usage chart and planning history
Can I see an item's sales history from the planning worksheet in Business Central?
Yes, with Enhanced Planning Worksheet. The History tab below the worksheet lines shows sales and purchase history for the selected line, and the Chart tab shows it as an item usage chart by month.
What does the item usage chart include?
Monthly sales as bars, with production usage, transfers, negative adjustments, and purchase, production, and adjustment activity in the legend. The chart covers the item on the selected planning line.
Can I change planning parameters after reviewing history?
Yes. The Planning tab on the same worksheet lets you edit the reorder point, minimum order quantity, and other planning fields on the stockkeeping unit or item.
Does Enhanced Planning Worksheet forecast demand?
No. Enhanced Planning Worksheet shows history and plans replenishment. Demand forecasting is done by Enhanced Forecasting Worksheet, a separate Insight Works app that is also part of Enhanced Planning Pack.
Related Enhanced Planning Worksheet features
All Enhanced Planning Worksheet features →Part of Enhanced Planning Worksheet
Align Inventory with Demand and Optimize Vendor-Driven Purchasing.
Have a question about Item usage chart and planning history?
Send us a note and the Enhanced Planning Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
