Pharmacy ERP

The problem

Generic billing software treats a medicine as one product. The same SKU actually sits on the shelf in three batches at three expiry dates and sometimes three printed MRPs, so batch tracking lived in a paper notebook beside the till — which meant expiry losses were discovered during stock-taking, after the supplier return window had closed.

What we built

Inventory modelled at batch level from the ground up, with first-expiry-first-out selection at billing so old stock clears before it becomes a write-off. Expiry alerts fire in 90/60/30-day tiers grouped by supplier, so one return covers a dozen items. Schedule H dispensing is blocked server-side until the prescribing doctor and prescription reference are captured. Reorder points compute from real sales velocity against supplier lead time rather than a fixed minimum.