Skip to main content

Why is my Available different from On Hand?

Available is On Hand minus what confirmed orders have promised. Here's how to see the orders behind the gap, and when it's worth a second look.

You can see 604 bags of coffee on the shelf, but the screen says only 564 are available. Nothing is lost. The other 40 are already promised to customers.

​

The short answer

Available = On hand − Allocated.

  • On hand is everything physically in the warehouse, including stock already promised to orders.

  • Allocated is stock held by confirmed sales orders that haven't shipped yet.

  • Available is what's left to promise to the next customer.

​

An item with 604 on hand, 40 allocated and 564 available

​

Confirming an order moves stock from Available to Allocated straight away. On hand only drops when the order ships. Drop-ship lines don't hold any of your stock, so they don't count here.

​

Use the Available number in the item's header. The Available column on the item's Inventory tab shows the same figure as On Hand.

​

See which orders hold the difference

  1. In the top menu, click Inventory, then Inventory, and open the item.

  2. In the header, click the Allocated number.

​

The panel lists every order holding the item, with the Order #, Customer and Quantity. The quantities add up to the Allocated number.

​

The three orders behind 40 allocated

​

Kit orders count too. An order for a kit holds each of its parts. In the example above, one of the three orders is a gift box that contains the coffee. The panel doesn't mark which orders are kit orders, so check the order if a line looks unfamiliar.

​

Kits work differently

A kit holds no stock of its own. Its Available is the number of complete kits you could build from what's available of each part.

​

A gift set needs 1 jam jar and 2 spoons. With 5 jars and 6 spoons it showed 3 available. Then an order for 4 jars on their own was confirmed, leaving 1 jar to promise, so the set dropped to 1 available while its On hand stayed at 3.

​

The gift set shows 1 available while 3 are on hand

​

​

When it's worth a second look

The orders in the Allocated panel should account for the whole difference. If one should no longer hold stock, reduce its quantity or cancel it. If Available is negative, see Why is my available quantity negative?. If the gap matches no order, send us the item's SKU, its On hand and Allocated numbers, and the warehouse selected at the top right.

​

Related articles

Did this answer your question?