Inventory replenishment planning with dated supply

An open purchase order can cover the horizon total while arriving after the production shortage it was meant to prevent.

Kartik Deshpande··6 min read

Inventory replenishment planning turns dated demand, usable stock, and expected receipts into proposed buys, transfers, or production orders. Calculate the projected stock position in time buckets, identify when it crosses the approved buffer, then apply lead times and buying constraints. An open PO belongs in the bucket when it can become usable, not at the start of the horizon.

Start with one material and one location where you can reconcile the quantities. If a supplier delays a receipt, your plan should show the resulting shortage before suggesting another order. A single net total for the whole horizon can conceal that timing problem even when every quantity is correct.

Define usable stock and avoid counting demand twice

Set the opening balance at a named cutoff and location. Exclude damaged, expired, or quality-held material from the usable balance according to the approved policy. Keep those quantities visible in their own states so the difference from financial inventory can be explained. A physical receipt (when inspection is required) needs acceptance time before it can serve production.

Choose one treatment for reserved demand. Either start with stock before reservations and subtract all included requirements, or start with stock net of reservations and exclude that same reserved requirement from later deductions. Mixing the approaches counts the reservation twice. Retain a check from the opening stock to the source inventory states.

Separate firm customer or production requirements from forecast demand and document how forecast consumption works. If an actual order replaces part of a forecast, subtracting both can overstate the need. Your planning system’s rules and the planner’s approved assumptions must establish the combined demand population before a shortage calculation is trusted.

Select the replenishment rule for the material

Microsoft’s replenishment methods documentation distinguishes period grouping, one planned order per requirement, and min/max coverage. The choice affects which needs are combined and how much is proposed. Keep the rule with the item and location rather than assuming one buying policy fits every material.

A requirement-based rule can preserve the link to a specific job. A period rule can combine requirements to reduce fragmented orders. A min/max rule can restore stock toward a chosen level after it crosses a threshold. For each material, review shelf life, demand variability, supplier constraints, and the cost of carrying the proposed stock before adopting the rule.

The reorder point formula article covers a threshold based on demand during lead time and a buffer. Replenishment planning extends that decision into a dated schedule. It must still show whether an existing order arrives before the requirement and whether the supplier can meet the proposed release date.

Run a date-phased net requirements example

Assume a hypothetical purchased component with 500 usable units at the start of the plan and a desired minimum projected balance of 100 units. The opening stock is before all demand shown below, so reservations are not deducted elsewhere. There are no scrap, yield, or unit-conversion adjustments in this example. Receipts become usable at the start of each week and demand occurs afterward.

WeekOpening projected unitsUsable receiptsRequirementsClosing projected units
Week A5000300200
Week B2000250-50
Week C-50400200150

The arithmetic is opening projected units + usable receipts - requirements. The existing 400-unit PO in Week C leaves 150 units at the end of the horizon, but the plan has a 50-unit shortage in Week B. The negative projected balance is an unmet requirement, not physical negative stock. A horizon-total view would miss the earlier service failure.

To close Week B with the assumed 100-unit buffer, the plan needs 150 additional usable units by Week B: 100 - (-50) = 150. Assume a minimum order of 200 units and a pack multiple of 50; a new buy would therefore be 200 units under this hypothetical policy. Moving some of the existing Week C receipt earlier could be a different response, subject to supplier confirmation.

Confirm how the actual planning application combines minimums, maximums, and multiples. Microsoft documents interactions between those settings, including min/max cases that do not follow a naive round-up rule. The 200-unit example above is an explicitly assumed purchasing policy, not a promise about the output of a particular ERP configuration.

Put supply where it becomes usable
Opening balance
Usable at cutoff
Dated receipts
Available after acceptance
Dated needs
Required before release
A later receipt can restore the horizon balance while leaving an earlier requirement uncovered. Escalate the earlier shortage before adding more stock.

Inspect a material’s dated position

Bring a stock snapshot, open-order lines, and demand dates into a workspace and trace one projected shortage.

Resolve late receipts before creating duplicate supply

For each suggested buy, inspect outstanding receipts for the same material and location. Confirm remaining quantity, current promised date, cancellations, and the time needed for receiving and inspection. Microsoft’s Vendor - Order Detail report distinguishes outstanding receipt quantities and identifies past-due expected dates; an open line alone does not prove that supply will arrive.

Assign responses to the constraint. An expediting request needs a supplier commitment. A transfer needs available stock at the sending location and transport time. A substitute needs the responsible technical approval. Keep the original shortage visible until the chosen response has evidence, then update the supply date or quantity rather than leaving both the old and replacement orders as expected receipts.

Carry the distinction between the required date, supplier promise, and internal usable date into the review. If a receipt needs inspection, a truck arriving on the production requirement date can still be late for use. The lead time article explains why the clock’s start and end events must be stated before supplier or planning performance is compared.

Approve the proposal and preserve the next review

Record the proposal, selected response, owner, and release decision in the purchasing workflow. Recalculate after the order is accepted or a receipt changes. Track which assumptions changed between runs so a buyer can distinguish new demand from a corrected opening balance. Otherwise the next suggestion may repeat an action already taken.

Review repeated expedites and aged excess together. A material can experience both when receipts arrive after demand and replacement orders remain open. Preserve the date history and the cancellation outcome before diagnosing the problem as an incorrect safety-stock level. The safety stock formula article covers the separate assumptions behind a buffer.

Where Permute supports the replenishment inputs

Permute sells connected business data and custom applications. We can connect supplied SAP, NetSuite, Excel, and Google Sheets records, resolving material identifiers and declared unit conversions across demand, inventory, and open orders. A planner can inspect unmatched materials and missing receipt dates before relying on the combined position.

We can reuse approved stock-state, cutoff, and receipt definitions in recurring views. A material planner can ask which requirements precede the next usable receipt and inspect the source order lines and assumptions behind the result. That gives your planning owner a checked population for the replenishment method already selected.

Keep planning policy and order authority explicit

We are not a forecasting engine. The analytical workflow supplies governed inputs and applies declared calculations; it does not choose service levels, forecast demand, qualify substitutes, or release purchase orders into a system of record. Buyers and planners retain those decisions in their authorized workflows, including approval of exceptions to minimum quantities or supplier terms.

Review timing before approving more inventory

A replenishment plan needs a dated stock position, a stated demand treatment, and receipts placed when they become usable. Apply the selected coverage rule and purchasing constraints after identifying the shortage. Review existing supply before creating a replacement order. Preserve the accepted response so the next planning run can distinguish an unresolved shortage from an action already taken.

Review a recurring shortage

Bring one material that experiences repeated expedites and the inventory, demand, and open-order records behind its plan.

Questions about inventory replenishment planning

Is replenishment planning the same as demand forecasting?

Forecasting estimates future demand. Replenishment planning uses demand assumptions alongside inventory, supply dates, and purchasing constraints to propose a response. Keep the forecast version visible so a revised buy can be traced to a changed demand input or supply condition.

How often should the plan be refreshed?

Choose a cadence that gives owners time to act before the relevant release dates. Refresh after material changes in demand or receipt commitments when the normal cadence would miss that decision. Display the source cutoffs so a new plan is not mistaken for one built from new data.

Should a negative projected balance be reset to zero?

Keep the unmet requirement visible rather than erasing it from the calculation. A zero floor can make a later receipt appear to create more free inventory than exists after backlog is served. If your system uses a different backlog convention, document it and reconcile the resulting requirement population.