Why a stock history matters more than a stock total
Two shops each have 40 units of an item on the shelf, and the system agrees. One shop is in good shape. The other is about to get a surprise. The totals look identical. The only thing that separates them is the history.
Totals hide things
A running total is a tidy way to lose information. Say the number moves from 52 to 40. Did twelve units sell? Were they damaged? Was a delivery of 40 entered as 28? Did someone correct a count? The total cannot tell you. It only shows the latest answer.
A history keeps the sentence that produced the number. 'Picked 12 for order 8841 on the 14th.' Now the 40 means something. You can tell it apart from a 40 that came from a silent correction.
What a good record holds
Only a total
- Stock: 40
- No sign of how it got there
- A correction overwrites the old number
- A question gets a shrug
With a history
- Receipt of 52 on the 3rd
- Pick of 12 for order 8841 on the 14th
- Count on the 20th, adjusted by 0
- A question gets a date and a document
Both shops show 40 on the shelf. Only one can say why.
The 'why' is the one people skip, and the one that pays off. A receipt tied to a purchase order, a pick tied to a customer order, a count tied to a counting document. Reasons turn a pile of numbers into a story you can follow. A week in the life of one stock record shows one.
Fix the record, do not erase the past
Mistakes happen. A receipt gets entered against the wrong order. A pick is done for the wrong customer. What matters is how the correction is made.
In a weak system, you edit the number and the mistake vanishes. In a good system, you post a reversal, and both the mistake and the fix stay visible. That feels fussy until the day you need to explain a discrepancy to a supplier, an auditor or yourself.
A correction should add a line to the record, not remove one.
Accountability without blame
People worry that a detailed history is a surveillance tool. Used badly, it can be. Used well, it protects honest staff: when a number is wrong, the record shows where the process failed, not who to shout at.
Shops that treat the history as a way to find the broken step tend to get better records. Shops that treat it as a way to find the guilty person get quieter staff and worse records, because people stop reporting their own errors.
First reaction
History used as a trap
A lecture
History used to fix the process
A question about the step
The next mistake
History used as a trap
Hidden
History used to fix the process
Reported
Records over time
History used as a trap
Quieter and worse
History used to fix the process
Better
| History used as a trap | History used to fix the process | |
|---|---|---|
| First reaction | A lecture | A question about the step |
| The next mistake | Hidden | Reported |
| Records over time | Quieter and worse | Better |
What to ask any tool
- Can I see every change to an item, with a date?
- Is a correction a new entry, or an overwrite?
- Can I tell which order or delivery a movement belongs to?
- How long is the history kept?
A short story about a missing carton
A distributor notices that a carton of expensive filters is gone. In a shop with only a total, the owner can say 'we are one short' and stare at the shelf. In a shop with a history, the owner opens the item and reads the last ten lines.
Receipt of 6 on the 3rd. Pick of 2 on the 9th for order 4417. Pick of 2 on the 12th for order 4430. Pick of 1 on the 14th, with no order number. Count on the 20th: 0 on the shelf, 1 in the system.
The pick with no order number is the odd one. It might be a sample, or a favor, or a mistake. Whichever it was, it took thirty seconds to find, and the conversation that follows is about a specific pick on a specific day, not about trust in general.