Morning triage

What needs attention today — not every row.

My first version of this told a coordinator 918 items needed reordering. The real number was 113 — the file is a transaction log, not a stock snapshot, and I had never asked what one row actually represented.

This version reads the same export and returns the 113 that need a decision today. It also flags the 12 where the supplier's own reorder quantity doesn't cover the shortfall beside it — one by 56 units — because a number that quietly under-orders is worse than none.

Same reason the expiry panel says DEMO: that dataset ends in 2022. A tool that hides its limits is the one you stop trusting.

Why this exists — who it's for and what it fixes
  1. The role. An inventory coordinator at a dairy distributor — the side that holds the stock in 15 places and ships it to shops, not the shop — opens a 4,325-row export every morning and has to decide what to reorder before the delivery window closes.
  2. The problem, and its root cause. That file is a transaction log, not a stock snapshot — one row is one recorded reading, not one item — so "how much do I have right now" is not a question the export can answer directly, and reading it the obvious way turns 113 real shortages into 918.
  3. What changes. She finishes the reorder decision before the delivery window instead of after it, knows which items are deepest below their minimum, and on a quiet day can tell the difference between nothing being wrong and the tool being broken.
  4. The flow. Open the page, read one line, pick a location, switch to supplier view, copy that supplier's order.
  5. What to watch. The "still N short" flag — on 12 of 113 items the supplier's own reorder quantity doesn't cover the gap printed beside it — and the DEMO label admitting the expiry panel runs against an export that ends in 2022, because a tool that hides its limits is the one you stop trusting.

Loading…

This morning —

Reorder now — stock below its minimum threshold

Expiring soon — within 14 days

Needs review — items the tool couldn't read