Available to promise for dated customer orders

Give sales a quantity and a ship date it can defend when stock, receipts, and existing orders change.

Kartik Deshpande··5 min read

An available to promise check tells your order desk how much it can commit by a particular ship date. Start with stock that can be sold at the fulfillment location, add eligible receipts by date, and subtract commitments that already claim that supply. A warehouse might have a hundred units on the shelf and have only thirty available for a new order.

Microsoft’s Inventory Visibility documentation describes dated changes to on-hand inventory as inputs to ATP. Set the rules for which changes count before exposing a promise quantity. A purchase order that has not shipped, a transfer due at the wrong warehouse, and stock waiting for inspection give you different levels of confidence.

Set the warehouse, date, and usable supply

Pick the fulfillment warehouse and the latest ship date that meets the requested delivery date. For a Friday delivery on a two-day lane, Wednesday is the last ordinary ship date under a weekday-only calendar. If the order misses the carrier’s Wednesday cutoff, check the next route or offer a later date. A date field with no definition can make a stock promise look like a delivery promise.

Start with released on-hand units and match the unit of measure to the order. Reserve damaged stock, quality holds, and any protected quantity under your policy before allocating more. Then add inbound receipts that can be used by the ship cutoff, with allowance for inspection and put-away where those steps apply. Publish the check time so sales can tell when a receipt update might change the answer.

Deduct open commitments once. If your ERP reports on-hand net of hard reservations, subtract only commitments excluded from that number. Compare the order and reservation keys before totaling demand (one line can appear in both exports). An apparently conservative double deduction can deny a customer stock the business already has.

Ask the planner to test a customer order that spans two warehouses. One location may have enough units but miss the required transit date. A nearby location may ship in time with fewer units. Return those choices separately so the order desk can offer a split rather than relying on a pooled total. If the same stock is advertised in two channels, check that both channels apply the reservation from either order before making another commitment.

Check one order against the dated balance

Assume one warehouse starts Monday with 100 usable units. Earlier customers already hold 70 units due Monday. A confirmed inbound shipment adds 40 units before Tuesday’s shipping cutoff, and another existing order needs 15 Tuesday. In this simplified example, neither day has other demand, safety stock is already excluded, and the new order needs 60 units by Tuesday.

The Monday balance is 30 and the Tuesday balance is 55. Offer 55 by Tuesday, or wait for an eligible receipt that covers the other five units. If the 40-unit receipt slips to Wednesday, Tuesday falls to 15. Record which receipt set the promise so the planner can find the affected customer orders when the carrier changes the date.

Some order systems also protect future committed demand when quoting today. If an existing Wednesday order depends on the same on-hand stock, preserve its reservation before quoting the apparent Tuesday balance. The reorder point formula addresses when to order replenishment. The ATP calculation uses the supply actually eligible under your promise rules.

Point in timeAvailable unitsWhat changed
Monday30100 usable minus 70 existing
Tuesday5530 plus 40 confirmed minus 15 existing
Tuesday if receipt slips1530 minus 15 existing
How a promise becomes a commitment
Read
Usable stock, dated receipts and open commitments
Quote
Quantity by warehouse and ship cutoff
Reserve
Confirmed order with a reservation ID
The quote can change until the order reserves stock in the system that owns the balance.

Trace a quantity to its records

Bring an inventory and order extract into Permute and inspect how the warehouse and item keys line up.

Reserve stock at confirmation

Use a quote as a view of available stock and recheck it when the customer accepts. Two salespeople can see the same thirty units before either order reserves them. Apply the reservation in the system that owns commitments, and return its order reference to the person who promised the date.

Test one split delivery, one late inbound receipt, and two simultaneous orders against the same supply. For the split, ask the receiving system to show a date per quantity. For the delay, confirm the exception names every commitment affected and keeps the old promise date. For simultaneous orders, one check must see the quantity taken by the other before it can confirm.

Report substitutions separately. If the customer approved a substitute, retain the original ordered SKU and the fulfillment SKU together. Let the planner see which unit and location supplied each line, especially if a substitute is pulled from a different warehouse with a different transit time.

Confirm the status of receipts as part of a weekly rule review. Track promised units backed by physical stock separately from promises backed by inbound supply. Check delays against the original decision timestamp, because a receipt moved forward after the promise was made can make a historical report look better than the information sales had at the time. Use distribution requirements planning to check the stock and transfer calendar behind an inbound proposal before including it.

Decide how long an unconfirmed quote can hold stock. If the business takes provisional reservations, give them a defined expiry and return released units to the next check. Otherwise an abandoned quote can keep supply unavailable even when there is no open customer order. Ask the order desk to reconcile expired holds against the next allocation run.

How Permute connects the evidence

Permute is the context layer we sell between business data and the AI tools people already use. Connect approved order and inventory sources, then match orders, locations, and SKUs across them so the team can check what each record refers to.

Define usable stock and which commitments count once so the same rule can be used in a report and a question. An order desk lead can ask which inbound receipt supports an order and see the relevant records they have permission to read.

What stays in the source systems

Keep reservations and delivery promises in the order system. Permute can help examine the inputs and identify a conflict. It reads the source records and does not reserve units, write a promise back, or schedule new production.

Confirm the quantity behind the promise

An available to promise check needs a warehouse, a ship cutoff, and a rule for which receipts and commitments count. In the example, a single late receipt drops Tuesday’s available quantity from 55 to 15. Keep the receipt that supported the original quote visible so the order desk can explain the change. Confirm the reservation before treating the quote as an order commitment.

Review a promise that changed

Bring one original promise and the late receipt that put it at risk.

Questions about stock promises

Can ATP be negative?

A projected balance can go below zero when existing commitments exceed eligible supply. Use it to flag the shortage and offer zero uncommitted units for that date.

Does a transfer count as on-hand inventory?

The receiving warehouse should count it as a dated incoming movement until receipt. Use the actual destination and a date that allows time for receiving before the ship cutoff.

Can you promise stock if production could make more?

Treat that as a separate capacity check. Confirm materials, equipment, and labor before adding the planned output to the eligible supply behind a customer promise.