Calculate Purchase Plan for Microsoft Dynamics 365 Business Central
In a distribution business, demand and receipt dates move every day. Date-phased planning reacts to each change with reschedule and cancel messages, and buyers spend their time on messages instead of on what to order.
Enhanced Planning Worksheet adds Calculate Purchase Plan, a planning run for distribution-style replenishment. It plans purchases and transfers from each stockkeeping unit's (SKU's) reorder point or maximum quantity, without date-phasing, which keeps reschedule and cancel messages down.
How Calculate Purchase Plan works in Enhanced Planning Worksheet
- An administrator turns on Extended Purchase Planning on the Enhanced Planning Worksheet Setup page, which makes Calculate Purchase Plan available.
- A buyer chooses Calculate Purchase Plan on the worksheet's Prepare tab.
- In Run Purchase Plan, the buyer sets the reorder trigger, what to plan, the batch to fill, and SKU filters such as location and vendor.
- Enhanced Planning Worksheet suggests purchases and transfers for SKUs at or below their trigger level.
- The buyer reviews the lines, checks vendor totals, and approves them for purchase orders or transfers.
Key capabilities
Triggered by reorder point or maximum
The Minimum Level to Trigger Reorder option sets whether a line is suggested when stock falls to the reorder point or below the maximum quantity. The maximum quantity option suits seasonal patterns.
Net demand, not dates
Calculate Purchase Plan focuses on net requirements and does not date-phase supply against demand. Once a purchase order is placed, the run does not keep suggesting new dates for it.
Purchases and transfers
The run plans both purchases and transfers between locations. Plan replenishment for chooses what to plan, and Include Planned Purchases decides whether lines already planned count as supply.
Filtered by SKU
Filter the run by location code, item number, or vendor number on the SKU, so a buyer can plan one vendor or one warehouse at a time.
Your choice of batch
Batch to Populate and Use Batch Name send the results to a named batch, and Existing Worksheet Lines decides what happens to lines already there, for example deleting them first.
Fits the rest of the worksheet
Results land in the same worksheet, with the Planning Summary, Enhanced Plan Vendor Summary, and tabs ready for review.
See Calculate Purchase Plan on screen
Real screens from Enhanced Planning Worksheet, shown with demo data.
Details that matter on the floor
Built for reorder-point replenishment
Calculate Purchase Plan answers the question a distribution buyer asks each day: what is below its trigger level, and how much do I need to bring it back up.
Regenerative planning is still there
Calculate Purchase Plan does not check timing conflicts the way date-phased planning does. When dates matter, such as component requirements for manufactured items, the standard regenerative plan runs from the same worksheet.
Depends on good SKU setup
Because the run works from SKUs and their reorder points, accurate SKU planning fields matter. Item Planning Review, also in Enhanced Planning Pack, helps set those values from actual usage.
Who uses Calculate Purchase Plan
Purchasing managers
Run a daily purchase plan that suggests what to reorder without a flood of reschedule messages.
Distribution managers
Plan replenishment and transfers for distribution centers from reorder points.
Inventory planners
Use maximum quantities for seasonal items and reorder points for steady ones.
Questions about Calculate Purchase Plan
What is Calculate Purchase Plan in Business Central?
A planning run added by Enhanced Planning Worksheet. Calculate Purchase Plan plans purchases and transfers from each stockkeeping unit's reorder point or maximum quantity, without date-phasing, which keeps reschedule and cancel messages down.
Does Calculate Purchase Plan replace material requirements planning (MRP)?
No. Calculate Purchase Plan is for distribution-style replenishment. In the latest release it plans multi-level production orders, and the standard regenerative plan still runs from the same worksheet for full MRP.
Do items need stockkeeping units?
Yes. Calculate Purchase Plan works from stockkeeping units. Items without a stockkeeping unit are not included in that plan.
How do I turn Calculate Purchase Plan on?
Turn on Extended Purchase Planning on the Enhanced Planning Worksheet Setup page. The Calculate Purchase Plan action is then available on the worksheet.
Can it run without a planner starting it?
Yes. Calculate Purchase Plan can run on a schedule through the job queue. See Job Queue Scheduling.
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 Calculate Purchase Plan?
Send us a note and the Enhanced Planning Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
