Available to Promise: How to Stop Overselling Stock You Have Already Committed

It is 4:40pm on a Thursday. Two of your sales reps are on the phone in the same open-plan office, and they just sold the same 40 sheets of aluminum to two different customers.

Neither of them did anything wrong. Both opened the stock report. Both saw "48 on hand." Both promised a ship date. The problem only surfaces on Monday morning, at the loading dock, when there is enough stock for exactly one of those orders and an awkward phone call waiting for the other.

That gap between "what the report says we have" and "what is actually free to sell" is where overselling lives. And it is almost never caused by bad people. It is caused by a number that quietly means the wrong thing.

This post is about closing that gap with Available to Promise (ATP): separating the stock you physically hold from the stock you have already committed, and reserving units the moment an order is confirmed, so the same 40 sheets can never be promised twice.

Where the single "on hand" number breaks

Most stock reports show you one figure per product: how much is physically sitting on the shelf. That figure is honest, but it is not the number your sales team actually needs.

What they need is: how much can I safely promise a customer right now? And that is a different question, because some of what is on the shelf is already spoken for.

Picture your 48 sheets of aluminum:

• 8 are already committed to a confirmed order that ships Friday.
• That leaves 40 genuinely free.

If your report only shows "48," every quote is built on a small lie. Do it across hundreds of SKUs and dozens of open orders, and the lie compounds until a shipment comes up short. The usual patch is a spreadsheet where someone manually subtracts committed quantities every morning. It works right up until the morning it does not.

The honest villain here is rarely a rival ERP. It is the manual reconciliation, the mental math, and the report that shows on-hand when your team needed available.

What "available to promise" actually means

Available to Promise is a simple idea with three numbers. In Qualis, every stock level, one per product, per location, per lot, carries all three:

• On Hand is what is physically at that location right now.
• Reserved is how much of that on-hand stock is already promised to confirmed orders.
• Available is what is genuinely free to sell or consume.

They relate in one line you will see printed right on the screen:

On Hand = Available + Reserved

So Available is simply what is left once you set aside everything you have already committed. That is the number your sales team should be quoting from, and it is the number Available to Promise keeps honest for you.

Notice what you cannot do on this screen: you cannot type any of these numbers in by hand. Inventory levels in Qualis are read-only. They are maintained automatically from the real stock movements, receipts, deliveries, transfers, and adjustments, that flow through your warehouses. Reserved moves the same way: no one edits it, it responds to what your orders actually do.

How Qualis reserves stock the moment you confirm

Here is the mechanic that stops the Thursday-afternoon collision.

When a sales order moves from quotation to confirmed, Qualis reserves the stock for you, automatically, line by line. For each line that ships from stock, it takes the undelivered quantity and places a hold against the exact location that holds the goods.

The instant that hold lands, three things happen:

1. Reserved goes up by the ordered quantity.
2. Available goes down by the same amount.
3. That stock is now off the table for every other quote and order.

So back to our two reps. The first order to be confirmed reserves its 40 sheets. Available drops to 8. When the second rep tries to confirm their order for 40, there is not enough available, and Qualis refuses the confirmation, telling them exactly how much was requested versus how much is actually free. The double-promise never reaches the loading dock, because it never made it past confirmation.

This is not a nightly batch job or a warning you might scroll past. It is a hard gate at the moment of commitment. Two orders confirming at the very same second cannot both grab the last unit: one succeeds, the other is told there is a shortage. You simply cannot commit stock you do not have.

It is smart about where the stock sits

Real warehouses are messy. Your 40 sheets might be split, 24 in one bay and 16 in another, so no single location holds the whole line. A naive system would look at each bin, see neither holds 40, and falsely report a shortage.

Qualis checks total availability across the product's bins and spreads the reservation across them when needed. If the stock genuinely exists, even in pieces, the order confirms and the hold is recorded against each bin it drew from. If it does not, you get a clear, honest shortage.

Lot and serial-tracked goods

For products tracked by lot or serial number, the specific batch is chosen when you actually ship, not at confirmation. So at confirmation Qualis checks that enough total stock is available across all lots at the location, then commits the specific lot at delivery time. You still get the availability guarantee up front, without pinning yourself to a batch weeks early.

Why this quietly pays for itself

Overselling is expensive in ways that never show up as a single line item. There is the expedited freight to cover the short order. The discount you offer to keep the customer. The production reshuffle when someone raids reserved stock to fill a "quick" order. And the slow erosion of trust every time a promised date slips.

Available to Promise attacks all of that at the source: it makes the free-to-sell number trustworthy, so promises are grounded in reality before they are ever made.

Plenty of established manufacturing systems do some form of ATP, this is table stakes at the high end. Where teams get burned is the middle ground: entry-level tools and homegrown spreadsheets that faithfully track on-hand but leave "what is actually free" as a manual subtraction someone is supposed to remember. That is the gap Qualis closes by making Reserved and Available first-class, automatic numbers you never maintain by hand.

And because Reserved is a live number, your everyday screens get smarter too. A Has Reservations quick filter shows exactly which levels are carrying commitments. The Low Stock filter watches available stock, not on-hand, so it flags a product as low when what is truly free runs thin, even if the shelf still looks full because half of it is reserved.

The whole loop, end to end

Available to Promise is not a one-time reservation. It is a loop that stays balanced across the entire life of an order. Here is the full cycle:

1. Confirm. A quotation becomes a confirmed order. Qualis reserves the undelivered quantity per line. Reserved rises, Available falls.
2. Adjust. If you change a quantity on a confirmed order, the reservation follows. Grow the line and it reserves more (or refuses if stock is short); shrink it and it releases the difference.
3. Deliver. As you ship, the reservation is released in step with what leaves the building. A partial delivery frees exactly the portion delivered, no more.
4. Close or cancel. When the order is fully delivered, or if it is cancelled, the remaining hold is released and that stock returns to Available for the next customer.

At every step, the golden rule holds: On Hand = Available + Reserved. You can watch it happen on each level's trend chart, which plots On Hand, Reserved, and Available over time, sitting right above the stock movement history that explains every change.

Because reservations release precisely as goods ship, you never strand stock in a permanent "reserved" limbo, the classic failure mode of manual holds that someone forgets to clear. Cancel an order and the shelf frees up instantly. Ship half and half comes back available. The number is always live, always honest.

Spotting trouble before it ships

The best oversell is the one you head off days early. Because Available is trustworthy, Qualis can warn you before a shortage becomes a crisis.

Your dashboard carries a Low Stock Alerts widget that counts products running low or hitting zero on available stock and lists the most urgent, each with its available quantity. Qualis also sends a notification when a product runs out, drops to low stock, or is restocked, so you hear about it even when you are not staring at the inventory screen.

That turns Available to Promise from a gate that says "no" at the worst moment into an early-warning system that helps you replenish before you ever have to.

Frequently Asked Questions

What is the difference between on hand and available?

On Hand is what is physically at a location. Available is what is genuinely free to sell or consume, which is On Hand minus everything already Reserved for confirmed orders. Your sales team should quote from Available, because On Hand includes stock that is already spoken for.

When exactly does Qualis reserve stock?

When a sales order is confirmed, moving from quotation to confirmed. Qualis reserves the undelivered quantity of each stock line against the location that holds the goods. If you re-confirm a previously cancelled order, it reserves again, so the numbers stay symmetric across the order's life.

What happens if there is not enough stock to confirm an order?

The confirmation is refused and the order stays as a quotation rather than becoming a confirmed order it cannot back with real stock. Qualis tells you which products are short and by how much, listing requested versus available, so you know exactly what to replenish.

Can two orders reserve the same units at the same time?

No. The reservation is an atomic availability check: two orders confirming at the same instant cannot both take the last unit. One succeeds and the other is told stock is insufficient. This is what prevents overselling at the source.

Do I ever have to update the reserved number myself?

Never. Inventory levels, including On Hand, Reserved, and Available, are read-only and maintained automatically from stock movements and order activity. There are no fields to edit and no spreadsheet to reconcile. To change a physical quantity, you record a real stock movement, and the level updates itself.

What happens to a reservation when I ship or cancel the order?

It is released in step with reality. Ship the full order and the hold clears; ship part of it and only that part is freed. Cancel the order and the remaining reservation is released entirely, returning that stock to Available for other customers.

The bottom line

Overselling is not a discipline problem. It is a data problem: your team was quoting from a number that quietly included stock you had already committed.

Available to Promise fixes the number. By splitting every stock level into On Hand, Reserved, and Available, and reserving stock the moment an order is confirmed, Qualis makes sure the free-to-sell figure your team sees is one they can actually stand behind, no spreadsheet, no mental math, no Monday-morning surprise at the dock.

Want to see it on your own products? Explore Inventory Levels in Qualis and watch On Hand, Reserved, and Available update themselves as your orders move, or start a trial and confirm two orders against the same shelf to see the gate work.