Skip to content
Enhanced Planning Worksheet app icon

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

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 ↓
Illustrative image: a technician tightens a joint on a robotic arm at an assembly bench.

Customer story

Reach Robotics

Reach Robotics, a robotics manufacturer in Glebe, New South Wales, Australia, plans with Enhanced Planning Worksheet: supply, demand, availability by location, and vendor information in one place, with purchase orders created from the worksheet.

Read the case study →

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.

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

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.

Ask a product question

Product Questions