The Planning Worksheet in Business Central is the page where MRP and MPS propose what to buy, make, or transfer, and when. A planner runs a calculation, reviews the suggested lines and their action messages, and carries them out into purchase, production, transfer, or assembly orders. Microsoft Dynamics 365 Business Central drives the whole calculation from a handful of item parameters. Most planning problems therefore trace back to those fields rather than to the engine. This article explains how the worksheet works, what each reordering policy and parameter does, and why the worksheet sometimes suggests far too many lines. It closes with where planners reach for an enhanced worksheet.
How does the Planning Worksheet in Business Central work?
The worksheet compares demand against supply for each item and proposes actions to close the gap. Microsoft Learn describes the scope under supply planning in Business Central: the worksheet considers “independent demand from sales and forecasts and dependent demand for components” and can suggest purchase, transfer, assembly, and production orders to cover it. Existing inventory and open supply orders count against that demand.
Business Central has two worksheets for this. The Requisition Worksheet is built for companies whose supply orders are only purchase and transfer orders, and it runs Calculate Plan. The Planning Worksheet plans production, assembly, purchases, and transfers together, running MPS and MRP, and it is the one manufacturers use. Both read the same item parameters. A company can start on the Requisition Worksheet and move to the Planning Worksheet without changing item setup.
Every proposed line carries an action message: New, Change Qty., Reschedule, Resched. & Chg. Qty., or Cancel. New creates supply. Reschedule and Change Qty. modify existing supply. Cancel removes supply the engine no longer needs. The planner ticks Accept Action Message on the lines to keep, then runs Carry Out Action Message. That action turns the accepted lines into real documents.
Regenerative vs net change: which calculation should a planner run?
Calculate Regenerative Plan starts by deleting the planned supply orders currently loaded and replans every item inside the filter from scratch. Calculate Net Change Plan considers only items touched by a demand or supply change (a sales order, forecast, production order, or purchase order quantity, or an unplanned inventory movement) or by a planning parameter change such as safety stock, reorder point, routing, BOM, or lead time. Microsoft Learn covers both under the title Run Full Planning, MPS, or MRP and calls the regenerative run “the most common process.”
Regenerative is the safer default for a weekly or nightly run because it does not depend on tracking every change since the last run. Net change suits a planner reacting to a large order during the day. Both share the MPS and MRP switches on the request page. MPS plans end items that have a forecast or a sales order line, and MRP plans the components that are not MPS items. Running with both checked is the common case for a manufacturer.
What do the reordering policies in the Planning Worksheet mean?
The Reordering Policy field on the Item Card’s Planning FastTab decides how the engine sizes and times supply. Microsoft Learn’s design details for planning parameters lists which other fields each policy uses. In practice:
| Reordering Policy | What triggers a suggestion | Quantity suggested | Fits |
|---|---|---|---|
| Fixed Reorder Qty. | Projected inventory falls below Reorder Point | Reorder Quantity, repeated as needed | Stable-usage stocked items, fasteners, packaging |
| Maximum Qty. | Projected inventory falls below Reorder Point | Enough to reach Maximum Inventory | Distribution items with a shelf or bin capacity |
| Order | Each demand event | One supply per demand, quantity matched, with no other planning parameters considered | Make-to-order, configured products, expensive items |
| Lot-for-Lot | Demand inside a period | Net demand in the Lot Accumulation Period, less inventory | Components and finished goods with lumpy, date-driven demand |
| Blank | Nothing | Nothing | Items the planner handles manually |
Fixed Reorder Qty. and Maximum Qty. are reorder-point policies. They look at projected inventory against a threshold and use the Time Bucket to group demand. Order and Lot-for-Lot are demand-driven policies. They tie supply to specific demand dates, which is what makes them date-phased. That distinction explains most planning noise, as the next section shows.
Which planning parameters matter most on the Item Card?
A short list of fields does most of the work:
- Safety Stock Quantity: the minimum inventory level the engine plans to keep covered. It is not the reorder point.
- Reorder Point: the projected inventory level that triggers a suggestion for the two reorder-point policies.
- Lead Time Calculation and Safety Lead Time: how far ahead of the need date to place the order, and how much slack to add. Microsoft Learn recommends a default safety lead time of at least one day, because the due date of demand is known but the due time is not.
- Lot Accumulation Period and Rescheduling Period: for Lot-for-Lot only. The first groups demand into one supply order; the second decides whether an existing order is moved rather than a new one created.
- Dampener Period: the window inside which the engine leaves an existing order alone rather than proposing to push it later. Inventory Setup carries a Default Dampener Period for items that leave it blank, and for Lot-for-Lot items the Lot Accumulation Period must be at least as long as the dampener.
- Minimum Order Quantity, Maximum Order Quantity, and Order Multiple: order modifiers applied in that order after the net quantity is calculated.
- Planning Flexibility on the supply document itself: Unlimited lets the engine change that order; None means the engine will not try to change it.
When items are stocked in more than one location, these fields belong on the stockkeeping unit rather than the Item Card. A stockkeeping unit is the item at a location, optionally per variant, with its own planning parameters. A fast-moving branch and a slow one can therefore carry different reorder points. Microsoft Learn’s central concepts of the planning system walks through how the engine reads these fields.
Why does the Planning Worksheet suggest so many lines?
The usual answer is date-phasing without a dampener. Suppose a purchase order for 500 brackets is due on the 14th, and a sales order moves by two days. A Lot-for-Lot item with no Dampener Period produces a Reschedule message for the purchase order. Multiply that by every open order and every small date change. The planner now sees hundreds of Reschedule and Cancel lines that nobody will act on. Fixes, in order of effort:
- Set a Dampener Period (for example 5D) so small shifts to a later date are ignored.
- Set Planning Flexibility to None on purchase orders already confirmed with the vendor, so the engine stops proposing to move them.
- Use Maximum Qty. or Fixed Reorder Qty. for distribution-style items, so replenishment follows a reorder point rather than individual demand dates.
- Lengthen the Lot Accumulation Period on Lot-for-Lot components so weekly demand becomes one order rather than five.
- Filter the worksheet run by item category, vendor, or location, so each planner sees only the lines they own.
A related trap is the forecast. During the MPS run, the demand forecast is netted against sales and production orders, so a forecast that is never revisited keeps generating demand of its own. Keeping forecast periods current is part of keeping the worksheet quiet.
Where does the standard Planning Worksheet in Business Central run out?
The engine is sound; the working surface is where planners struggle. Reviewing a suggested line means opening the item card, then item availability by location, then the vendor card, then purchase history. Then back to the worksheet. Across a few hundred lines that becomes a full day of navigation. Vendor minimum order values and prepaid freight thresholds live in someone’s notebook. Drop shipments and special orders sit on the separate Requisition Worksheet. A planner who wants to know whether another location already holds excess stock has to go and look.
The Enhanced Planning Worksheet from Insight Works keeps the standard regenerative plan and adds the working surface around it. FactBoxes for Planning Summary, Availability by Location, and Vendor Planning Summary sit beside the lines. Tabs cover Chart, Planning, Order Tracking, Supply/Demand, History, and Create Purchase Orders. A planner can edit reorder point or minimum order quantity on the SKU directly from the worksheet. On seeing that another location has stock, the planner can switch a line from manufacture to transfer. Drop shipments and special sales orders appear in the same worksheet. The Enhanced Plan Vendor Summary tracks planned purchases against a vendor’s minimum prepaid dollar or weight threshold.
The second addition is Calculate Purchase Plan. This distribution-oriented calculation plans purchases and transfers from reorder point or maximum quantity without date-phasing. It deliberately ignores dates once a purchase order is placed, which removes the Reschedule and Cancel noise for stocked items. It is enabled through the Extended Purchase Planning field on the Enhanced Planning Worksheet Setup page and can run in the job queue. Two limits apply. The knowledge base is explicit that “the purchase plan is based on stockkeeping units and not items; you must have stockkeeping units created for the item or the item is not planned.” And it plans purchases and transfers only, so production orders and component explosion still rely on the native regenerative plan.
Details are on the enhanced planning worksheet for Business Central page and in the article on MRP in Business Central with the Enhanced Planning Worksheet. The worksheet setup steps are in the knowledge base. The app page states that one named user per Business Central online environment is free, with no time limit and no feature restriction, and that additional users or on-premises deployment require a paid subscription. The worksheet is also a component of the Enhanced Planning Pack for Business Central, a bundle of six planning and analysis apps. The MRP for Business Central hub collects the wider planning material.
Frequently asked questions about the Planning Worksheet in Business Central
How does the planning worksheet work? It nets demand against supply per item using the reordering policy and parameters on the Item Card or stockkeeping unit. It then proposes lines with action messages. Carry Out Action Message turns accepted lines into orders.
What is the difference between regenerative and net change planning? Regenerative recalculates every item in the filter from scratch. Net change recalculates only items whose demand, supply, or parameters changed since the last run.
Why does the planning worksheet suggest so many lines? Usually because date-phased policies react to every small date change. A Dampener Period, Planning Flexibility set to None on firm orders, and reorder-point policies for stocked items quiet it down.
Should I use the Requisition Worksheet or the Planning Worksheet? Use the Requisition Worksheet for purchases and transfers only. Use the Planning Worksheet when production or assembly orders need planning too.
Is safety stock the same as the reorder point? No. Safety stock is the minimum inventory level the engine tries to keep covered. The reorder point is the trigger level for Fixed Reorder Qty. and Maximum Qty. policies.
Does the Enhanced Planning Worksheet replace MRP? No. It runs the same regenerative plan and adds FactBoxes, inline editing, vendor tracking, and an optional reorder-point-driven Calculate Purchase Plan for stockkeeping units.