Planning Summary for Microsoft Dynamics 365 Business Central
A planning line tells a planner what Business Central suggests buying, but not why. Checking the supply and demand behind one suggestion usually means opening item availability pages one at a time, and on a worksheet with hundreds of lines that adds up.
Enhanced Planning Worksheet adds a Planning Summary FactBox, the information pane to the right of the worksheet lines, that totals supply, demand, and the surplus or shortfall for whichever line is selected.
How Planning Summary works in Enhanced Planning Worksheet
- The planner opens Enhanced Planning Worksheet after a plan has been calculated.
- The planner selects a planning line, and the Planning Summary FactBox shows supply, demand, and surplus or shortfall for that line.
- If a figure looks wrong, the planner opens the Supply/Demand tab below the lines to see the documents behind it.
- The planner accepts, changes, or deletes the planning line, then moves to the next one; the summary follows the selection.
Key capabilities
Supply in one total
The supply section lists quantity on hand, quantity on production orders, quantity on purchase documents, transfer order receipts and shipments, and quantity on planning lines, then shows a Supply Net total.
Demand in one total
The demand section lists quantity on component lines, on sales documents, and on service orders, then shows a Demand Net total, so the planner sees where the requirement comes from.
Surplus or shortfall
Surplus/Shortfall compares the two totals for the selected line's item and location, which tells the planner at a glance whether the suggested quantity is needed.
Context at the bottom
A miscellaneous section shows the number of other locations and variants for the item, usage in the current year, and the physical inventory counting period.
Follows the selected line
The summary changes as the planner moves through the worksheet. For the documents behind a figure, the planner opens the Supply/Demand and Order Tracking tabs below the lines.
See Planning Summary on screen
Real screens from Enhanced Planning Worksheet, shown with demo data.
Details that matter on the floor
Totals the planner would otherwise add up
Supply Net, Demand Net, and Surplus/Shortfall are calculated for the planner. The planner reads one number instead of adding figures from several availability pages.
Planning lines count as supply
Quantity on planning lines is part of the supply total, so a planner sees when other suggestions on the worksheet already cover the requirement.
Who uses Planning Summary
Inventory planners
Check each suggestion against current supply and demand before accepting the action message.
Purchasing managers
Review why a purchase is suggested before the line becomes a purchase order.
Production planners
See component demand next to supply when checking lines for manufactured items.
Questions about Planning Summary
What does the Planning Summary show in Business Central?
Supply, demand, and the surplus or shortfall for the selected planning line. Enhanced Planning Worksheet totals quantity on hand, production orders, purchase documents, transfers, and planning lines as supply, and component lines, sales documents, and service orders as demand.
Is the Planning Summary part of the standard planning worksheet?
No. The Planning Summary FactBox is added by Enhanced Planning Worksheet, an Insight Works app that adds planning summaries, availability by location, history, and vendor thresholds to the planning worksheet in Business Central.
How is Enhanced Planning Worksheet different from the standard planning worksheet?
The worksheet lines look the same. Enhanced Planning Worksheet adds FactBoxes for the planning summary, availability by location, and vendor planning, plus tabs for supply and demand, order tracking, history, an item usage chart, and planning fields, so a planner can check and correct a suggestion without leaving the line.
Is Enhanced Planning Worksheet part of Enhanced Planning Pack?
Yes. Enhanced Planning Worksheet is sold as its own app and is also included in Enhanced Planning Pack, Insight Works' bundle of six planning, forecasting, and production analysis apps. Licensing depends on the setup; see the licensing FAQ.
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 Planning Summary?
Send us a note and the Enhanced Planning Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
