Overview
Stock is only an asset until the expiry date says otherwise
A pharmacy's stock figure is two different numbers wearing one label. There is what is on the shelf, and there is what can still be sold. The gap between them is expiry, and in a shop running on a supermarket billing package that gap is invisible until a strip is picked up at the counter and somebody reads the date out loud. By then it is not stock, it is a write-off, and nobody recorded when it became one.
ClinicNP holds stock per batch, and every batch carries its own cost and its own expiry. Near expiry is a screen rather than a memory, with warnings at thirty, sixty, and ninety days. Expired stock is held back from sale outright, with no override, ever — not a confirmation dialog, not a manager password. Overselling is blocked the same way. The oldest expiry is chosen automatically on every line, and can be overridden per line when a batch genuinely has to be picked by hand.
The counter is built for the way medicines are actually sold here. A single item has a rate as a box, as a strip, and as a tablet, and the person serving switches unit with one key. The quantity picker draws the medicine in its real shape — a strip of ten, a bottle, a tube — so the quantity can be seen rather than trusted to a number typed under pressure. One search box finds the item, and the whole counter has a key for every action.
Where stock goes when it does not get sold is a register in its own right. Stock out is recorded with a reason: returned to supplier, expired, damaged, lost, used in the clinic, given as a sample, or a counted correction. That produces the number an owner actually wants at month end and almost never has — what did I lose this period, and to what? Alongside it sit profit by item, stock valuation, the purchase register, a VAT summary when the company is registered for it, and the expiry and slow-moving report that says what is dying on the shelf and what never moves at all.
Worth reading alongside this: software development company in Nepal, our software products, and web development in Nepal.