AWRA OpsHub Search

Stock Promised Is Not Stock Free

An order confirmed on Monday holds stock for that customer until the goods leave. Invoices get raised, cancelled and raised again in between, and none of that paperwork should move the promise. Here is what does.

Inventory Insights Washingtone Aura 7 min read

A contractor building rental flats in Eldoret confirms an order with a hardware wholesaler for 400 bags of cement and 120 iron sheets, to be collected over two weeks as the site needs them. The order is confirmed on Monday. On Tuesday the accounts clerk raises an invoice for the first 150 bags. On Wednesday the contractor asks for the invoice to be split differently, so the clerk cancels it. On Thursday a walk-in builder at the trade counter asks for 200 bags.

How many bags can the counter sell him? The honest answer depends on a question most systems answer by accident: is the contractor’s promise measured against what has been invoiced, or against what has actually left the yard? If invoicing counts, Tuesday’s invoice made 150 bags look delivered and Wednesday’s cancellation either put them back or did not, depending on who wrote that screen. If the goods count, the paperwork in between changes nothing, which is how it should be.

We have written about the guard itself, the single check every outgoing movement passes through, in On Hand, and Already Promised. The order that carries the promise, from the customer’s yes to the invoice, is described in the sales order between Tuesday and Monday. This post is about the life of one promise while the documents around it change.

What a confirmation holds

When the order is confirmed, each stock line reserves as much as is free at the order’s warehouse, and records the rest as a backorder on the same line. The wholesaler had 520 bags and nothing else promised, so the contractor’s 400 are held in full. The sheets were short: 90 on hand, so 90 are held and 30 wait. Service lines on the same order, such as delivery or offloading, hold nothing, because nothing physical leaves for them.

From that moment the counter sees 120 free bags, not 520. Try to sell the walk-in builder 200 and the sale is refused with a sentence the cashier can read out: only 120 of the cement here is free, 400 is reserved for customer orders.

Owed means not yet gone

Here is the rule that keeps the promise steady. What an order still owes the customer is what it ordered less what has gone out on a checkout of its invoices, pending or approved. It is not what it ordered less what has been invoiced. An invoice that has not been checked out yet still needs its stock, and the promise keeps covering it.

What happens What the hold does
Order confirmed Holds what is free; the rest is backordered
Invoice raised from the order Nothing. The goods have not moved
That invoice checked out That much of the hold moves onto the checkout
Checkout approved, goods leave The moved part is fulfilled and closed
Checkout rejected The moved part goes back to the order line
Invoice cancelled Its quantities go back on the order as not yet invoiced
Order released Every hold is given up and the backorders stop waiting

Walk the Eldoret week through that table. Tuesday’s invoice for 150 bags moved nothing. Wednesday’s cancellation put the 150 back on the order as not yet invoiced, and the order went back to confirmed, because no other invoice had been raised. The hold of 400 never changed, because no cement had left. On Thursday the counter could still sell 120 and no more, which is the right answer.

Paperwork can be raised and cancelled all day. A promise should move only when the goods do.

Changing an invoice raised from an order

An invoice raised from an order cannot be edited on its own. Its lines are the order’s invoiced quantities, and editing one would leave the order still saying the original quantities were billed. To change it, cancel it and invoice the order again with the quantities you want. That is why the contractor’s split in the story above is a cancellation and not an edit.

Letting go of a promise

A promise ends in one of three ways: the goods leave, the order is cancelled, or the order is released. Which is open to you depends on how far the order has got.

The order is still a draft or only confirmed, and the customer has walked away

Cancel the order

Every hold is given up and the freed stock is offered straight to anyone waiting on a backorder for those items.

Part of the order is already invoiced and the customer will not take the rest

Release the stock

A partly invoiced order cannot be cancelled, so Release is how it lets go. Every hold is given up, the backorders stop waiting, and the order keeps its invoices.

You released too early, or a line lost its hold and the customer still wants the goods

Reserve stock again

The order shows a Reserve stock button whenever a line still has something to ship and holds nothing. It holds what is free now and backorders the rest.

Reserving again uses the same rule as confirmation: still owed is measured against goods that have gone, so an order that has invoiced some lines but shipped nothing holds the full amount again. Only an order that is confirmed, partly invoiced or invoiced can hold stock; a draft or a cancelled order is refused.

Released stock goes to whoever is waiting

Stock freed by a cancellation or a Release is offered to waiting backorders for the same items before the counter sees it, once the change is saved. In Eldoret, if another contractor’s order is short of iron sheets, the 90 sheets released from this one fill that order first.

Two weeks of cement

On hand, Monday 520 bags
Order confirmed 400 held
Invoice for 150 raised, then cancelled 400 held
New invoice for 150, checked out and approved 250 held
Walk-in sale at the counter 120 sold
Still free to sell 0 bags

On hand is 250 and every bag is the contractor’s. The next delivery will be free stock, unless a backorder is waiting for it.

More we can add

Sharper tools for letting go

Holding, moving and returning a promise with the goods is in place. These are the refinements wholesalers ask about once orders start to change mid-delivery.

A reason on every Release

Recorded beside who released the stock and when, for the sales manager’s weekly review.

Releasing one line

Letting go of the sheets while the cement stays held, rather than the whole order at once.

A notice when a line holds nothing

Telling the order’s owner that a line still owed has lost its hold, before the customer arrives to collect.

Three questions for your current system

If I invoice part of an order and then cancel the invoice, how much stock is still held?

What you will probably hear

It depends on the screen you used.

How to read it

Then the promise is tied to paperwork. It should be tied to what has physically left.

How do I stop holding stock for an order that is half invoiced?

What you will probably hear

Cancel the order.

How to read it

Cancelling a half-invoiced order disturbs the invoices already raised. Ask whether you can release the stock and keep the invoices.

When I release stock, who gets it?

What you will probably hear

Whoever sells it first.

How to read it

Released stock should go to customers already waiting for it before the counter sees it.

At the counter

Measure a promise against goods that have left, not against invoices. Then invoices can be raised, cancelled and raised again without a single bag changing hands on paper, the counter always sees the true free figure, and the only things that end a promise are a shipment, a cancellation or a deliberate Release.

The straight answer

What AWRA OpsHub does today

  • Reservation on confirmation, holding what is free per stock line at the order’s warehouse and backordering the rest, with service lines left out.
  • Still owed measured against goods checked out, pending or approved, so raising or cancelling an invoice does not move the hold.
  • The hold moving onto an invoice checkout, fulfilled on approval and handed back to the order line on rejection.
  • A cancelled order invoice returning its quantities to the order, with the order’s status recomputed.
  • Release for a partly invoiced order, and Reserve stock to hold again any line that still owes goods and holds nothing.
  • Freed stock offered to waiting backorders before the counter can sell it.

More we can add to your workspace

  • A reason recorded on every Release, beside the person and the time. Commission it
  • Releasing a single order line, keeping the rest of the order held. Commission it
  • A notice to the order’s owner when a line still owed holds nothing, in the bell and by email. Commission it

Where we point you to a specialist

  • We do not let a sale at the counter take promised stock on a cashier’s say-so. The way past a promise is to release it on the order, where the release is recorded against the person who made it.

The reason on Release is a small change to an action that already exists; the single-line release builds on the per-line holds the order already keeps.

See reservations and backorders

How confirmed orders, holds and backorders work together, and what each screen shows.

Stock reservations and backorders

Frequently asked questions

Does raising an invoice from a sales order release the reserved stock?

No. The hold covers what the order still owes, which is what it ordered less what has gone out on a checkout of its invoices. An invoice that has not been checked out still needs its stock, so the hold stays until the goods leave.

What happens to the reservation when I cancel an invoice raised from an order?

The invoice’s quantities go back on the order as not yet invoiced and the order’s status is recomputed. The hold itself does not change, because no goods moved.

Can I edit an invoice that was raised from a sales order?

No. It is changed through the order: cancel the invoice, then invoice the order again with the quantities you want.

How do I stop holding stock for an order that is partly invoiced?

Use Release on the order. A partly invoiced order cannot be cancelled, so Release gives up every hold and stops its backorders while keeping the invoices already raised.

Can a released order hold stock again?

Yes. When a line still has goods to ship and holds nothing, the order shows a Reserve stock button. It holds what is free now and backorders the rest.

Share this article

LinkedIn X WhatsApp

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center