Enhanced Planning Worksheet for Microsoft Dynamics 365 Business Central
Free for One User
Plan purchases with supply, demand, and history in view
Align Inventory with Demand and Optimize Vendor-Driven Purchasing.
Enhanced Planning Worksheet adds planning summaries, availability by location, sales and purchase history, and vendor thresholds to the planning worksheet in Microsoft Dynamics 365 Business Central, so planners can check and correct a suggestion without leaving the line. Its Calculate Purchase Plan option plans distribution-style replenishment without date-phasing, which keeps reschedule and cancel messages down. It is free for one named user in a Business Central online environment, with every feature included.
- Business Central online
- Free for one user
- Stockkeeping unit planning
Enhanced Planning Worksheet resources
How Enhanced Planning Worksheet helps
Planning in context
See why the worksheet suggests each order
A planning line with an unexpected quantity sends planners into the item card, the stockkeeping unit, and ledger entries to find out why. Across hundreds of lines, that checking adds up.
Enhanced Planning Worksheet shows a planning summary, availability by location, and the selected line's supply, demand, order tracking, and history in FactBoxes and tabs on the same page. The Chart tab shows item usage over time, so a suggestion that does not match recent sales stands out.
See all Enhanced Planning Worksheet features ↓Fix parameters in place
Correct planning parameters from the worksheet
An outdated minimum order quantity or reorder point keeps producing the wrong suggestions until someone finds it. Finding it usually means leaving the worksheet for the item or stockkeeping unit card.
The Planning tab shows the stockkeeping unit's planning fields, including reordering policy, reorder point, maximum inventory, and order modifiers, and planners can edit them in place. Changes are saved to the stockkeeping unit or item, so the next planning run uses the corrected values.
See all Enhanced Planning Worksheet features ↓Calculate Purchase Plan
Plan replenishment without a flood of action messages
Date-phased regenerative planning responds to date changes on open orders with reschedule and cancel messages. In a high-change distribution environment, planners can spend more time reviewing messages than placing orders.
Calculate Purchase Plan plans purchases and transfers from each stockkeeping unit's reorder point or maximum quantity without date-phasing, so it focuses on net demand that is not yet covered. Run it from the worksheet or on a schedule through the job queue, then create purchase orders from the results.
See all Enhanced Planning Worksheet features ↓Vendor planning
Plan to each vendor's prepaid freight threshold
Many vendors offer prepaid freight once an order reaches a minimum value or weight. Without a running total per vendor, buyers either miss the threshold or order more than they need.
The Enhanced Plan Vendor Summary totals approved planning lines by vendor and shows the amount and weight still needed to reach each vendor's prepaid minimum. Buyers can keep their own list of vendors, so a purchasing team can split vendor responsibility and plan independently.
See all Enhanced Planning Worksheet features ↓Enhanced Planning Worksheet screenshots
Real screens from Enhanced Planning Worksheet in Business Central, shown with demo data.
Enhanced Planning Worksheet features
16 features in 3 groups. Each one has its own page with screens, steps, and answers to common questions.
Planning worksheet
- Planning SummarySee supply, demand, and surplus or shortfall for the selected line in a FactBox.
- Availability by LocationCheck on-hand and future availability at other locations and companies before you buy.
- Supply, Demand, and Order Tracking TabsReview the documents behind each suggestion without leaving the worksheet.
- History and Chart TabsView sales and purchase history as a table or an item usage chart.
- Inline Planning EditsEdit reorder point, minimum order quantity, and other planning fields on the stockkeeping unit or item from the worksheet.
- Custom ViewsSave and switch between worksheet views for different planning roles.
- Sales and Service Order DemandChoose whether only released sales orders count as demand and which service order statuses to include.
- Drop Shipments and Special OrdersPlan drop shipment and special sales orders in the same worksheet.
Purchase planning
- Calculate Purchase PlanPlan purchases and transfers from reorder points or maximum quantities without date-phasing.
- Regenerative PlanRun the standard Business Central regenerative plan from the same worksheet.
- Transfer or PurchaseSwitch a line to a transfer when another location already has the stock.
- Job Queue SchedulingRun Calculate Purchase Plan on a schedule through the job queue.
- Create Purchase OrdersCreate purchase orders from approved lines, with options to combine lines and send them.
Requirements and licensing
Free for one user
One named user in each Business Central online environment can use every feature at no cost, with no time limit. Additional users need a paid subscription.
Business Central online
The free single-user license applies to Business Central online.
Business Central license
Each user needs a Business Central user license.
Stockkeeping units
Calculate Purchase Plan works from stockkeeping units. Items without a stockkeeping unit are not included in that plan.
Purchase plan setup
Turn on Extended Purchase Planning on the Enhanced Planning Worksheet Setup page to make Calculate Purchase Plan available.
Manufactured items
In the latest release, Calculate Purchase Plan plans multi-level production orders. The standard regenerative plan also runs from the same worksheet.
Also in Enhanced Planning Pack
Enhanced Planning Worksheet is also included in Enhanced Planning Pack, Insight Works' bundle of six planning, forecasting, and production analysis apps.
PRICE
Free for One User
The free license covers one named user in a Business Central online environment with no time limit or feature restrictions; additional users or on-premises deployment need a paid subscription.
App details and prerequisites
- Business Central
- Business Central online
- Insight Works license
- Free for one named user; subscription for additional users
- Business Central license
- Business Central user license
- Planning basis
- Stockkeeping units
- Languages
- English
- Availability
- All countries where Business Central is available
What customers say about Enhanced Planning Worksheet
Case studies
Questions about Enhanced Planning Worksheet?
Ready to plan a rollout? Contact your Microsoft Partner. For product questions, send us a note and the Enhanced Planning Worksheet team will reply by email.









