The Day We Learned That "In Stock" Doesn't Mean In Stock

The Day We Learned That "In Stock" Doesn't Mean In Stock
Day One : The Celebration
"'Our inventory accuracy is at 99.8%.'"
The dashboard was showing the green light.
Our operations manager put the report up on the conference room screen.
Everybody seemed happy.
The warehouse team was happy as counts matched the ERP numbers.
The finance team was happy as inventories looked properly valued.
The management team was happy as things looked better than they had ever looked before.
Even someone made the joke:
"At this point, we know our inventory better than Amazon."
We laughed.
None of us had any idea how little that figure meant to come.

Day 2 · The Complaint
Monday morning.
A customer places an order for 250 pieces of one of our best-selling products.
The company website shows:
Available Stock: 347
The ERP shows:
Available Stock: 347
The warehouse management system shows:
Available Stock: 347
Everything looks good until the warehouse supervisor calls.
"We've found only 83."
At first, I thought somebody miscalculated.
But then comes another phone call.
"We checked again. We still have 83."
And yet another one.
"We've looked everywhere."
Now the atmosphere got pretty quiet in the room.
Our system says 347, while reality says 83.
One of them must be lying.
Act 3 · The Investigation
We started tracing transactions.
Purchase orders.
Returns.
Transfers.
Cycle counts.
Adjustments.
Everything looked normal.
Then we found something interesting.
Six months earlier, a workflow had been introduced for damaged inventory.
The process looked simple:

1. Mark item as damaged.
2. Move it to quarantine.
3. Await inspection. The problem? The ERP deducted stock only after inspection. The website didn't know the difference. To the website: Damaged stock = Available stock. Quarantined stock = Available stock. Unsellable stock = Available stock. The system wasn't counting inventory. It was counting assumptions.

Act 4 · The Number Nobody Watched
I exported the data.
A simple query.
Inventory Status | Units
Available | 347
Quarantine | 189
Damaged | 75
Total Physical Sellable Inventory:
83
For six months, reports celebrated inventory accuracy.
Nobody was measuring inventory availability.
Those sound similar.
They aren't.
One tells you whether records match.
The other tells you whether customers can actually buy something.

Act 5 · The Real Cost
The customer order was delayed.
Then another order.
Then another.
Customer support tickets increased.
Sales blamed operations.
Operations blamed the warehouse.
The warehouse blamed the software.
The software was doing exactly what it had been told to do.
The process was wrong.
Within a week:
• 142 orders were affected.
• 37 orders were partially fulfilled.
• Thousands of dollars in expedited shipping costs were incurred.
• Multiple customers cancelled repeat orders.
All while the dashboard still showed:
Inventory Accuracy: 99.8%

Act 6 · The Fix
We didn't buy new software.
We didn't replace the ERP.
We didn't hire consultants.
We changed one rule.
Inventory could only be labeled "available" if it was physically sellable.
Then we created a second KPI.
Not Inventory Accuracy.
Inventory Availability.
Every morning both numbers appeared side by side.
The difference was shocking.
Accuracy stayed above 99%.
Availability dropped to 74%.
For the first time, leadership saw the real problem.
Three months later availability reached 96%.
Customer complaints dropped.
Backorders dropped.
Emergency shipments dropped.
Nothing magical happened.
We simply started measuring the right thing.

Act 7 · The Lesson
One number can tell a beautiful lie.
The dashboard wasn't wrong.
The inventory records were accurate.
The business conclusion was wrong.
Because accurate inventory and available inventory are not the same thing.
The most expensive inventory mistake I've seen wasn't a missing product.
It was trusting a metric without asking what it actually measured.
Have you ever seen a KPI that looked perfect while the business was quietly failing underneath it?