Pharmacy · schema pharmacy
Early accessA retail chemist sells part strips, holds four batches of one tablet at three printed prices, and answers to a drug inspector about what left the shop and on whose prescription. This is built around those three facts.
It runs on the same login as every other Udyamik workspace, with its own database schema. A person who owns a pharmacy and sits on a school committee switches between them from the top bar.
245,140
medicines in the shared list
searchable by brand or salt
638
molecules on Schedule H, H1 and X
each citing its notification
882
DPCO ceiling prices
from NPPA
5%
GST on medicaments
HSN 3004, since 22.09.2025
| Medicine | Batch | Expiry | Qty | Amount |
|---|---|---|---|---|
| Dolo 650Paracetamol | DL2601 | 12/27 | 2 + 5 | 73.50 |
| Taxim-O 200H1Cefixime | TX2603 | 02/28 | 1 strip | 109.00 |
| Glycomet 500HMetformin | GM2605 | 05/28 | 2 strips | 66.00 |
| Thyronorm 50HLevothyroxine | TN2604 | 08/28 | 1 strip | 23.25 |
A bill in progress. Batch and expiry on every line, and the expired box is blocked rather than hidden.
Each of these exists because the drug trade requires it, and most of them are the reason a general-purpose billing package does not fit a chemist.
01
Stock is held per batch with its own expiry month and its own printed MRP. Two deliveries of one batch number at different prices are two rows, each billing at the price on its own pack.
02
Name a medicine and the soonest-expiring sellable batch is taken. Name a different one and the skipped batch is recorded against the bill, so an owner can see which shelf to walk to.
03
Two strips and five tablets is 35 tablets. Pack size, base unit and loose sale are properties of the medicine, so a six-tablet course bills correctly without arithmetic at the till.
04
The schedule is derived from the molecule against the gazette lists, not copied from a catalogue flag. H1 asks for the prescriber and patient before the bill commits, and the register is written in the same transaction as the sale.
05
Enter the stock already on the shelf batch by batch, with its expiry, printed MRP and what a pack cost, or upload three files in order: medicines, then customers and stockists with what each owes, then opening stock. Each upload is previewed row by row and committed all at once or not at all.
06
One server-rendered PDF for thermal 58mm, 80mm, A4 and dot matrix, chosen per shop with a per-bill override. Saving and delivering are separate acts: a shop with no printer sends the bill on WhatsApp or as a link instead.
07
An estimate is priced as the tax invoice would be and prints NOT A TAX INVOICE, in its own number series. It moves no stock and takes no money, and becomes a sale only when it is converted at the counter on the day. A sale order can take an advance against a receipt, and a delivery challan sends goods on approval to a hospital or a clinic.
08
A rate list for a hospital, a nursing home or a doctor, assigned to the party so the counter prices from it. Schemes take per cent off, an amount off, or buy N get M free, on a medicine, a therapeutic class or the whole bill.
09
Upload the invoice as a PDF or a photograph. Batch, expiry, quantity, free goods, rate and MRP come off the page as a draft you correct. Nothing reaches the shelf until somebody posts it.
10
Each branch has its cash drawer, and the business its bank and UPI accounts, each a running book that every bill, receipt, payment and expense posts to. The day closes with a counted drawer against the expected cash, and the Z-report prints or saves as a PDF.
11
A chain is one business with several branches, each with its own bill series and its own GSTIN where it has one. Stock moves between branches with its batch, expiry and printed MRP. A pharmacist or counter hand sees only the branches the owner ticks for them, and a counter hand never sees cost or margin.
12
GSTR-1 with B2B, B2CS, CDNR, HSN and DOCS tables, as JSON for the portal or CSV per table, and GSTR-3B. Credit notes carry their own number series, because the return counts them separately from invoices. E-invoices and e-way bills are raised in the background from the bill, the challan or the transfer, and the books export to Tally.
13
The khata for customers who pay later and the ledger for stockists you owe, both append-only. A correction is another row, never an edit.
A shop opening on Monday has four hundred medicines to enter before it can bill anything. The shared list holds 245,140 of them, searchable by brand or by salt, and taking one copies the composition, the dosage form, the manufacturer, the HSN code and the GST rate. The only thing it asks is how many are in the pack you buy, because that is the only thing it cannot know.
The list grows from the shops using it. A medicine you add that the list does not have is offered to it, and once it is reviewed every other pharmacy finds it too.
Drug schedules are matched from the molecule against the gazette lists rather than taken from a catalogue flag, so an amendment is a row and not a re-import. Where a composition came from a source that records at most two ingredients, the record says so instead of presenting a combination as complete.
Shared list · search "azithral"
Hot-swap between a school registry, a pharmacy counter, a shop’s bills or a clinic reception desk without signing in again. Each organisation keeps its business data in its own Postgres schema with row-level security on every table, so one account reaching two organisations never means one database holding everything in a column.
Switch the organisation below to see which navigation and which records the same login is given.
Bills
64
since 09:00
Takings
18,240
rupees, 2 counters
H1 entries
7
written as sold
To act on
5
batches, 90 days
| Medicine | Batch | Expiry | Sch | On shelf | Stockist | Next |
|---|---|---|---|---|---|---|
| Azithral 500 | AZ2511 | 11/26 | H | 9 strips | Shree Ganesh Pharma | Return to stockist |
| Dolo 650 | DL2555 | 12/26 | OTC | 4 strips | Shree Ganesh Pharma | Sell first |
| Pantocid 40 | PT2508 | 12/26 | H | 22 strips | Medplus Distributors | Return to stockist |
| Augmentin 625 | AG2549 | 01/27 | H | 3 strips | Medplus Distributors | Sell first |
| Electral ORS | EL2409 | 09/26 | OTC | 6 sachets | Shree Ganesh Pharma | Write off |
The counter sells the soonest-expiring batch first, and refuses one that has expired.
Worth saying plainly, so nobody discovers it after signing.
Onboarding is personal rather than self-serve. We set you up, move your data in, and stay close for the first month.
Talk to usRetail chemists · schema pharmacy
Udyamik