Imagine walking into your local pharmacy to collect medicine, only to learn the store just wrote off two lakh rupees worth of expired stock. For any pharmacy\u2014small or large\u2014this is a painful hit. Margins are tight, customer trust is crucial, and inventory is the lifeblood of the business. In this post, we\u2019ll peel back the layers on how a single outlet let \u20b92 lakh in medicines slip through the cracks, and show exactly how their ERP logs told the full story. We\u2019ll end with practical steps any pharmacy can take to prevent a similar disaster.<\/p>\n\n\n\n
It began with a routine month\u2011end audit. The store manager noticed unusually large disposal entries in the ERP system\u2014entries labeled \u201cStock write\u2011off\u201d totaling \u20b92,00,000 for expired medicines. No one on the counter team had flagged these items or suggested markdowns. It wasn\u2019t a one\u2011off SKU, but dozens of products across painkillers, antibiotics, and chronic\u2011care drugs. In one moment, inventory that cost the pharmacy significant capital simply had to be destroyed.<\/p>\n\n\n\n
Why did they discover it in the ERP, not on the shelf? Because the expired boxes were tucked away in the back, mixed with fine stock. They\u2019d missed every visual check. In an industry where every rupee matters, this oversight was more than a clerical error\u2014it was a wake\u2011up call.<\/p>\n\n\n\n
Before we dig into the logs, here\u2019s a quick profile of the outlet:<\/p>\n\n\n\n
This isn\u2019t a massive chain; it\u2019s a neighborhood pharmacy where stock moves quickly and relationships matter. Even here, a \u20b92 lakh loss represented nearly two weeks of sales\u2014a serious blow.<\/p>\n\n\n\n
Let\u2019s look at how the ERP told the story:<\/p>\n\n\n\n Without the ERP logs, this pattern would have been impossible to spot until the auditor\u2019s surprise walk\u2011through.<\/p>\n\n\n\n Why did this happen? The logs reveal several gaps:<\/p>\n\n\n\nDate<\/strong><\/td> Activity Type<\/strong><\/td> Description<\/strong><\/td> User\/Source<\/strong><\/td> Notes<\/strong><\/td> Date<\/strong><\/td> Activity Type<\/strong><\/td><\/tr> 12 Jan<\/td> Purchase Invoice<\/td> 100 strips of medicine entered in inventory<\/td> Supplier: MedHealth<\/td> Batch: MHTX-452<\/td> 12 Jan<\/td> Purchase Invoice<\/td><\/tr> 20 Jan<\/td> Sale Entry<\/td> 2 strips sold to customer<\/td> Counter Staff<\/td> Retail bill<\/td> 20 Jan<\/td> Sale Entry<\/td><\/tr> 18 Mar<\/td> Stock Check<\/td> Stock report shows 98 strips still available<\/td> SwilERP<\/td> No movement for 2 months<\/td> 18 Mar<\/td> Stock Check<\/td><\/tr> 02 Apr<\/td> Near Expiry Alert<\/td> System alert triggered for upcoming expiry<\/td> SwilERP<\/td> Ignored by user<\/td> 02 Apr<\/td> Near Expiry Alert<\/td><\/tr> 05 May<\/td> Stock Audit<\/td> Internal audit flags unused inventory<\/td> Inventory Manager<\/td> Escalated to owner<\/td> 05 May<\/td> Stock Audit<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n
<\/strong> Many items hadn\u2019t sold since December or January. No counter staff used them in February, even as expiry drew near.
<\/li>\n\n\n\n
<\/strong> Batches had 4\u20136 months of shelf life. Under normal turnover, they should have sold, but low demand or poor visibility kept them hidden.
<\/li>\n\n\n\n
<\/strong> Each disposal entry captured the original cost. Accounting saw \u20b92 lakh vanish in one click of \u201cApprove Disposal.\u201d
<\/li>\n<\/ol>\n\n\n\nUncovering the Root Causes<\/strong><\/h2>\n\n\n\n
1. No FEFO (First\u2011Expiry, First\u2011Out) Picking<\/strong><\/h3>\n\n\n\n