Numbering Checker / Repair

Inspect current and next document numbers for billing, PO, GRN, and transfers, and repair sequences when needed.

Back to Setup
Numbering is branch-specific. Billing numbers are also series-specific, so you can check the live counter for each department and bill series.
Reset
Selected branch
Main Branch (MAIN)
Selected department
Pharmacy

Billing Numbers

Department Bill Series Current Sequence Latest Code Next Code Latest Date
Pharmacy Default / Standard - No record PHA-DSP2026070700009 -

Purchase Order Numbers

Department Current PO Next PO Latest Date
Pharmacy No record PHA-PO2026070700001 -

GRN Numbers

Department Type Current GRN Next GRN Latest Date
Pharmacy GRN No record PHA-GRN2026070700003 -
Pharmacy OPEN_STOCK No record PHA-OST2026070700003 -
Pharmacy TRANSFER_IN No record PHA-GRN2026070700003 -

Transfer Numbers

Department Current Transfer Next Transfer Latest Date
Pharmacy No record PHA-TRN2026070700001 -
Reset Numbering Destructive

Use the first option to restart billing sequences for the selected branch and department. Use the second option only if you want every pharmacy document number to start from 1 again.

Reset Billing Sequences

Clears only the live billing sequence rows for the selected branch and department. This is the safe option if you only want billing to start over.

Restart All Numbering

Clears all pharmacy transaction data and resets the document counters so PO, GRN, transfer, and billing numbers start from 1 again.

This ignores the selected branch and department filters because all document tables must be emptied together to restart from 1.
Base URL: https://www.emr.kch.lk