Skip to content
Enhanced Planning Worksheet app iconEnhanced Planning WorksheetPurchase planning

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

  1. An administrator turns on Extended Purchase Planning on the Enhanced Planning Worksheet Setup page, which makes Calculate Purchase Plan available.
  2. A buyer chooses Calculate Purchase Plan on the worksheet's Prepare tab.
  3. 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.
  4. Enhanced Planning Worksheet suggests purchases and transfers for SKUs at or below their trigger level.
  5. 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.

Enhanced Planning Worksheet app icon

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.

Ask a product question

Product Questions