A statutory, running log of every movement of a controlled substance — receipts in, dispensing out, and destruction/wastage — with a live balance per drug. Auditors and regulators expect this to reconcile with physical stock.
This screen is a read-only report. It is built directly from your real stock movements, so it can never drift from what actually happened in the ERP. There is nothing to type in and nothing to reconcile between two lists — every row here is a genuine Purchase, sale, adjustment or transfer.
Before you start
- A drug only appears here if its Schedule = Controlled on the item's Pharmacy tab. Set that first.
- Every movement is captured automatically: selling/dispensing a controlled drug produces an Out row, receiving a Purchase produces an In row, and an Inventory Adjustment produces the In or Out for destruction, wastage or a stock correction.
Steps — read the register
- Open Pharmacy → Controlled Drug Register.
- Optionally filter by Drug, and by a From / To date range.
- Each row shows the date, drug, batch, direction (In/Out), quantity, the running balance after the movement, and its accountability trail — for a sale that's the patient, prescriber and who dispensed; for a receipt it's the purchase number and supplier; the Ref column names the source document.
How to add or remove controlled stock
You no longer add rows here by hand — you record the real ERP document and the register updates itself:
- Received new stock? Enter it as a Purchase (receive the goods). It shows as an In row referencing the purchase.
- Destroying, wasting or correcting stock? Raise an Inventory Adjustment (record the destruction certificate reference on the adjustment). It shows as an In or Out row referencing the adjustment.
Tips
- The Balance column is a true running total per drug, carried forward across the date filter — set a From date and the opening balance is still included.
- Reconcile the register balance against physical stock regularly; investigate any gap before it grows.
Common problems
- A controlled drug shows no rows. → It has had no stock movements yet, or its Schedule wasn't Controlled at the time. Set the schedule on the item's Pharmacy tab; movements recorded from then on will appear.
- I need to add a receipt/destruction but there's no button. → That's by design — record a Purchase (receipt) or an Inventory Adjustment (destruction/wastage) and it appears here automatically.
- I can't open the register. → You need the Medical Resources permission.