We had shipped batch tracking, we had shipped first-expiry-first-out, and we thought expiry was solved. Then we stood behind a counter for a week.
What we saw
The pharmacist never looked at the expiry screen. Not once. Not because it was bad - because at the moment she needed it, both her hands were busy and a customer was waiting.
Every decision that mattered happened during dispensing, in about four seconds. Our carefully built reporting screen was answering a question nobody was asking at a time when nobody could look.
What we changed
We moved the whole thing into the dispensing flow. The batch is chosen for you. If the oldest usable batch is close to expiry, the counter says so on the line you are already looking at. The report still exists, and is still good, and is now for the owner on a Sunday rather than the pharmacist on a Tuesday.
The lesson we keep relearning
A feature that is correct but arrives at the wrong moment is not a feature. It took a week of standing still to see something no amount of specification review had caught.