Pharma ERP software for a Gujarat API manufacturer: manufacturing, exports and field sales in one system
How Yukti AI built a working pharma ERP prototype for GM Healthcare, an API manufacturer and exporter at Saykha GIDC, Bharuch. Raw material, purchase, production, QC, FEFO inventory, sales orders, a mobile field-force app, schemes, targets, credit control, collections and an API export book read from one dataset, with an Ask Your ERP assistant on top.
GM Healthcare manufactures and exports Active Pharmaceutical Ingredients from Saykha GIDC Estate, Vagra, Bharuch, Gujarat. Yukti AI built it a pharmaceutical manufacturing, sales and distribution ERP prototype of about 60 screens on React and TypeScript: nine roles, a separate mobile field app, FEFO batch allocation, an expiry radar, end-to-end batch traceability, a 14-mechanic scheme engine, a target engine with a pace line, credit control, an API export book and Ask Your ERP. It runs on a seeded demo dataset (no backend yet), so every figure on this page is labelled demo data.
What this case study covers
Quick facts
| Client | GM Healthcare (G M Healthcare), a pharmaceutical API manufacturer and exporter |
|---|---|
| Location | C-303/1, Saykha GIDC Estate, Vagra, Bharuch, Gujarat, India |
| Industry | Pharmaceutical manufacturing (APIs), exports, and branded formulation distribution |
| Core challenge | Manufacturing, batches, expiry, sales, field force, schemes, credit and exports must read from one set of numbers instead of separate sheets and registers |
| Solution | Pharma ERP software with an AI-assisted analytics layer: one dataset from raw material to collection |
| Scope | About 60 screens in 12 navigation groups, 9 roles, a separate mobile field-force interface |
| Products modelled | 11 real API molecules plus an illustrative range of 60 branded formulation SKUs in 14 therapeutic categories |
| Pharma logic | FEFO allocation, expiry radar, batch traceability, 14-mechanic scheme engine, target engine, credit control, Schedule H/H1/X flags, drug licence tracking, HSN-wise GST, e-invoice IRN, e-way bill |
| Status | Working front-end prototype on a seeded demo dataset, deployed as a live demo. No backend, login or persistence yet. Not a production deployment with real customers. |
| Stack | React 18, TypeScript (strict), Tailwind CSS, Recharts, React Router, Vite, hosted on Vercel |
| Built by | Yukti AI, Surat, Gujarat |
What is pharma ERP software? A system that connects a pharmaceutical business end to end: purchase, production, quality control, batch-wise stock, sales, dispatch, collections and analytics. For an Indian manufacturer it also has to carry expiry management, batch traceability and statutory flags such as Schedule H, drug licences, GST and e-invoicing.
Is it live? It is a live demo of a working prototype, not a production rollout. It shows how the system behaves, on sample data, so a plant and its sales team can review the workflow before the backend is built.
What does GM Healthcare do, and why does it need two channels in one ERP?
GM Healthcare's actual business is manufacturing and exporting Active Pharmaceutical Ingredients from its plant at Saykha GIDC, Bharuch. The company's published profile covers a tagline, vision, mission, goals, a 2020 to 2025 milestone timeline, facility-design points and three named directors, and all of it appears on a Company Profile screen in the prototype.
The prototype models the API business and a branded formulation range side by side, because a pharma company that makes its own molecules often also sells finished products through chemists, distributors and agencies. The two channels behave very differently, so the ERP keeps them apart while sharing the plant.
| API and exports | Formulations (illustrative) | |
|---|---|---|
| Products | The 11 molecules listed on the company site | 60 branded SKUs across 14 therapeutic categories |
| Unit | Kilograms, 5 kg and 25 kg drums | Strips, bottles, tubes |
| Buyers | 18 formulators and importers in 9 countries (names illustrative) | 432 chemists, distributors, agencies and hospitals |
| Terms | Letters of credit, 60 to 90 days | 15 to 60 day credit |
| Owner | Export desk (the three directors) | 20 field executives across 12 territories |
| Shared plant | Manufacturing, batch records, QC release, warehouse and expiry radar | Manufacturing, batch records, QC release, warehouse and expiry radar |
The 11 API molecules are Benfotiamine, Carbamazepine, Minoxidil, Tadalafil, Dapoxetine, Oxcarbazepine, Etoricoxib, Hydrochlorothiazide, Quetiapine Fumarate, Hydroquinone and Linagliptin. Each carries its therapeutic use, regulatory filings, HSN code, per-kilogram contract pricing and its own batch inventory.
Backward integration is modelled. Four demo brands (Tadaforce 20, Dapoforce 60, Tadaforce-D and Benfogem 150) are formulated from GM Healthcare's own API. Open a brand and the product page shows the molecule it is made from; open the molecule and it lists the brands consuming it. That link is the commercial argument for making the API in-house.
Who this pharma business management system is built for
This case study is written for the people who actually run a pharma company in India day to day, not for an IT department. If you own or manage an API manufacturing unit in a GIDC estate around Bharuch, Ankleshwar, Vapi or Ahmedabad, a formulation company with a team of medical representatives, or a pharma distribution business in Surat or elsewhere in Gujarat, the problems this system answers will probably sound familiar.
The common thread is batch-controlled stock that expires, a sales team that works on schemes and targets, customers who buy on credit, and an owner who wants one honest number instead of three different reports. The table below shows how the same pharma ERP software would be used by different kinds of businesses.
| If you are | The part of the system you would lean on most |
|---|---|
| An API or bulk-drug manufacturer | Production orders, raw-material consumption variance, QC release, batch traceability and the export book for molecules, buyers, drums and letter-of-credit receivables |
| A formulation company with a field force | The medical rep app, beat plans, GPS visits, the scheme engine, the target engine and the leaderboard |
| A pharma distributor, stockist or C&F agent | Batch-wise pharma inventory, FEFO picking, the expiry radar, chemist credit control, collections and e-way bills |
| A company doing both manufacturing and distribution | All of the above on one dataset, which is exactly the GM Healthcare situation this prototype models |
| A nutraceutical or wellness brand sold through chemists | Schemes, targets, the field app, FEFO and expiry management, without needing the export book |
It is less suited to a single retail medical store. A counter-billing tool is usually enough there; this system is meant for businesses that make, hold and move stock in batches across a team.
What problems is this pharmaceutical manufacturing software built to solve?
A pharma business runs on chains: a raw-material batch becomes a production batch, a QC release, finished stock, an invoice and a customer. When each link lives in a different register, one question takes hours. The left column describes this manual work in general terms, not in the client's own words; the right column is how the prototype behaves.
Without one system
- Stock tracked by product, not by batch, so the earliest-expiring stock is not sold first
- Expiry noticed late, when little can be done except write off
- A batch complaint needs files from purchase, production, QC and dispatch to trace
- Scheme and incentive maths done by hand in sheets, with disputes at month end
- Credit limits checked after the order, not before
- Management asking for numbers that differ by report
With the system
- FEFO picks the right released batch and states the reason
- Expiry radar buckets stock and lists customers to push it to
- Raw-material GRN to customer in one traceability chain
- 14 scheme mechanics with liability accruing only on qualification
- Credit check blocks at 100% utilisation, in the field app too
- A dashboard number equals the number on the screen it links to
Why custom pharma ERP software instead of a generic distribution system?
Generic ERP and billing tools treat stock as a quantity per product. Pharma needs it per batch, with an expiry date, a QC status and a licence-controlled customer at the other end. A pharma ERP also has to serve two commercial models, API export and formulation distribution, without mixing their units, terms and owners. A custom build lets the data model follow the plant, the field team and the export desk. That is the principle behind every AI-powered business management system Yukti AI builds, and it applies the same approach as its manufacturing ERP software.
The design rule was simple: there is no second set of dashboard numbers. Company total, territory performance, product ranking, customer ranking, leaderboard, incentive slabs and scheme progress are all roll-ups of the same order lines.
How is the pharma ERP put together?
The whole chain reads from one deterministic dataset: raw material, purchase, production, QC, finished goods, inventory, sales order, field force, scheme and target, dispatch, collection and analytics. Change the seed and every dependent figure changes coherently.
AI for pharma owners: the command centre, alerts and Ask Your ERP
The first screen a director sees is a target hero, a leaderboard and links into every underlying report. Around it sit tools that tell the owner what needs attention without opening ten reports. This is the AI-assisted layer of the AI-powered business management system: the software reads the data and briefs the owner.
- Management dashboard. Month-to-date sales against target, outstanding, orders pending and the executive leaderboard. Each tile links to the screen that produced it. In the demo dataset the company target is shown as 2.25 Cr with 1.85 Cr booked (82.1%); these are sample figures.
- Ask Your ERP. A plain-language question screen. It resolves named products, customers, territories and executives, answers from the live roll-ups and links to the source screen. Example questions: who sold the most this month, which salespeople are below 70% target, how much stock of a named product, which batches expire in 30 days, which scheme is costing the most. It is a data-query engine over the ERP's own numbers, not a generative AI model.
- Alert Centre. Severity-ranked alerts generated from the same data: batches nearing expiry with a suggested action (return to supplier or clearance sale), executives drifting behind pace, accounts over credit limit, stock below reorder level and pending QC.
- Automation Centre. A library of trigger-action rules: a reorder breach raises a purchase alert, a batch inside 60 days of expiry starts a clearance workflow, a credit breach blocks billing, a 90% target nudges the manager. See the automation section below for the full list and what is simulated.
- WhatsApp Hub. Message templates for order confirmation, invoice with PDF, payment reminder, dispatch update, scheme notification, payment receipt, outstanding statement and target achievement. In the prototype the send buttons show a confirmation toast; the WhatsApp Business API is the integration step.
Pharma sales and distribution software: orders, customers and credit control
The sales side covers the order-to-cash view for chemists, distributors, agencies and hospitals, the counter types a pharma company in India sells to.
- Sales overview and orders. Order register with pending orders, order detail with batch allocation, and invoices that carry HSN-wise GST and an e-invoice IRN. The demo dataset holds about 1,470 orders and 1,400 invoices, generated from a fixed seed.
- Customer master. 432 demo accounts across 10 customer types, with pages for distributors, agencies, medical stores or chemists, and hospitals or institutions. Each customer page shows orders, ledger, schemes and the products they buy.
- Customer, product and territory analytics. Intelligence views for what a counter buys, which territories lead, and which customers are going quiet.
- Credit control. Sanctioned limit, utilisation and available credit per customer. A hard block applies at 100% with a logged override request. The field app runs the same check before an order is placed.
- Returns and credit notes. Sales returns with saleable, damaged and expired routes, and a credit-note and debit-note workflow.
- PTR and PTS price control. Separate retailer and stockist pricing, with MRP, PTR and PTS held per SKU and margin guardrails.
Pharma field force automation: a separate mobile app for medical representatives
The field app lives at its own route and is designed as its own interface, not a squeezed desktop. It has a bottom tab bar (Home, Visits, Orders, Schemes, Profile), a floating order button, GPS check-in cards and thumb-reachable quantity steppers.
- Today's visits and beat plans. A representative sees the day's calls from a weekday beat route. Managers see beat compliance and customer visit history.
- GPS check-in and attendance. Visits are checked in with GPS and feed an attendance grid, distance and compliance reporting.
- Suggested order. On a counter visit the app suggests an order from that customer's purchase history.
- Order booking with automatic schemes. Add quantities, and the scheme applies automatically (a 10 plus 1 free-goods example is in the demo). Then cart, credit check, place order and a confirmation with a WhatsApp share.
- Collections on the move. Record a collection against a customer's outstanding from the same app.
- Scheme progress. Representatives see how close they and their customers are to the next slab.
- Staff 360 profile. For managers: a profile per executive with target, achievement, pace, visits, orders and scheme position.
Pharma sales scheme software and a target engine with a pace line
Schemes and targets are where pharma sales teams lose the most time to spreadsheets. The prototype treats them as engines, not tables.
- Scheme engine, 14 mechanics. Buy X Get Y, quantity slabs, revenue slabs, cashback, free goods, gifts, travel rewards, performance schemes, product schemes, category schemes, new-customer schemes and collection incentives. Slab tables show the reward per tier.
- Liability only on qualification. Scheme cost accrues only when a customer or executive actually qualifies, so management sees real exposure, not a theoretical maximum.
- Scheme dashboard and campaigns. Separate views for customer, agency and medical schemes and campaigns. A demo campaign shows a closing-week leaderboard of participants who are qualified, almost there or behind. That campaign's cohort is calibrated for demonstration.
- Target engine. 7 target types, 4 periods and 4 assignee levels, measured against a pace line (the share of the month elapsed) rather than a flat percentage. It shows required daily run-rate and projected close.
- Incentives and payouts. Staff incentive slabs and incentive payouts computed from the same order lines.
FEFO, expiry radar and batch traceability: pharma inventory management software
Pharma stock is never just a quantity. It is a quantity in a batch, with an expiry date and a QC status. This is the part of the system most specific to pharma.
How does FEFO allocation work?
FEFO means first-expiry-first-out. Allocation picks the earliest-expiring released batch with enough free stock, and enforces a 90-day minimum residual shelf life before falling back to another batch. The order and picking screens state the reason for the batch chosen, so the decision is explainable.
What does the expiry radar show?
Live batches are bucketed Expired, 0 to 30, 31 to 60, 61 to 90 and 90+ days. Each bucket has the commercial action that prevents a write-off, and each batch has a customer action list.
Can a batch be traced from raw material to customer?
Yes. Batch traceability follows raw-material GRN, production order, consumption variance, QC test results, warehouse stock and every customer the batch reached, with returns recorded against it.
Other inventory screens
- Finished goods, raw materials and batch inventory with batch detail pages.
- Stock movement, stock transfer and stock adjustment across seven stock points in four branches.
- Low stock, near expiry and dead stock lists with reorder levels.
- Product master with categories, pricing, composition, units and substitutes.
Pharmaceutical manufacturing software: production, QC and purchase
For an API manufacturer, the plant is the product. These modules connect the shop floor to stock and sales.
- Production planning and orders. Production orders with stages, batch production records and planning against demand and stock.
- Raw material consumption. Consumption recorded per batch with variance against the standard.
- Quality check. QC records with test results and a release decision. Only released batches are eligible for FEFO allocation, and an alert escalates a batch that sits at QC for more than 48 hours.
- Suppliers, purchase orders and GRN. Supplier master, purchase orders, goods receipt notes, purchase invoices and purchase returns. Raw materials span API, excipient, packaging and solvent types.
- Reorder alerts. Raw-material and finished-goods reorder levels raise an alert and a draft purchase alert.
Warehouse and dispatch: picking, packing, e-way bill and proof of delivery
Dispatch turns an approved order into a delivered one. The picking list shows the FEFO-recommended batch and the reason for it, then packing, then dispatch with transporter, LR number and e-way bill, then shipment tracking and proof of delivery.
- Pending dispatch queue with order value.
- Packing and dispatch orders with delivery challan.
- E-way bill for consignments above 50,000 rupees, with transporter and vehicle capture.
- Shipment tracking and POD to close the loop.
- Multi-warehouse and multi-branch stock with inter-warehouse transfers.
Collections and receivables: who owes what, and for how long
Accounts sees the same numbers the sales team sees. A typical path is receivables, then an ageing bucket such as 60+ days, then the customer, then the ledger, then record payment.
- Receivables and ageing. Outstanding invoices in ageing buckets, each clickable down to the customer.
- Customer ledger and outstanding. Full ledger per customer with statements.
- Collections and payments. Record receipts against invoices; collection incentives feed the scheme engine.
- Payables. Supplier payables from purchase invoices.
- Credit limits and expenses. Limits and utilisation, plus an expenses view.
- Margin reports. Profit and margin reports from the same order lines.
API manufacturer ERP: the exports book for molecules, buyers and consignments
Because GM Healthcare's core business is APIs, the export desk has its own section rather than being a tab on domestic sales.
- Export overview. Molecule scorecard, buyer league table, export share and destination countries.
- Molecules. The 11 APIs with use, regulatory filings, HSN, per-kilogram contract pricing and batch inventory.
- Buyers. 18 demo formulators and importers in 9 countries. The buyer names are illustrative; the molecules, markets and company profile are real.
- Consignments. Drum-wise shipments in 5 kg and 25 kg packs, with export invoices.
- Export receivables. Letter-of-credit terms of 60 to 90 days and the outstanding by buyer.
In the demo dataset the API book is shown as 2.68 Cr for October against 1.85 Cr for formulations. These are sample figures, shown only to demonstrate how the two channels compare on one screen.
Pharma compliance software features built into billing and stock
Statutory details are part of the data model rather than a separate checklist.
| Feature | What it does |
|---|---|
| Schedule H, H1 and X flags | Schedule classification on every SKU, with register prompts at billing for H1. |
| Drug licence tracking | Licence number and expiry held against each customer, with a renewal reminder and a compliance hold flag. |
| HSN-wise GST | HSN code and GST slab on every line. |
| E-invoice IRN | An IRN reference on every sales invoice. |
| E-way bill | Raised for consignments above 50,000 rupees. |
| Batch traceability | Raw material to customer, with returns. |
| Audit logs | A log of who did what, in the Administration group. |
Recall management, distributor and customer portals and secondary-sales capture are listed on a Pharma Capabilities screen as Beta or Planned, so the roadmap is stated openly instead of implied.
Automation for pharma: the rules that make the ERP act on its own
Each automation rule is a trigger, an action, a channel and a recipient. The prototype ships ten of them, and a manager can switch each one on or off.
| Trigger | Action |
|---|---|
| Stock falls below reorder level | Notify the Purchase Manager and draft a purchase requisition |
| A batch enters the 60-day expiry window | Notify warehouse and sales, tag for clearance, build a customer action list |
| Outstanding exceeds the sanctioned credit limit | Alert Accounts and the executive, hold further billing pending override |
| Executive crosses 90% of target | Nudge the Sales Manager and pre-compute the incentive |
| Customer or executive crosses a scheme slab | Notify management, lock the reward against liability, raise the claim |
| Invoice passes due date by 3, 15 and 30 days | WhatsApp payment reminder with statement and a UPI collect link |
| Dispatch marked In Transit | WhatsApp dispatch update with invoice PDF, LR number and ETA |
| Batch sits at QC for more than 48 hours | Escalate to the QA Head and Production Manager |
| Active customer has not ordered in 45 days | Create a win-back visit task and flag the account |
| Drug licence within 30 days of expiry | Request the renewed licence and flag a compliance hold |
The rules and alerts are generated from the live demo data, but export, print, WhatsApp send and approval buttons raise a confirmation toast instead of performing the action. They show where the action sits in the workflow. Connecting them to the WhatsApp Business API, email and an e-invoice provider is an integration step. See WhatsApp automation and workflow automation for how Yukti AI wires these up.
Every feature in the pharma ERP, and what it means for the business
A feature list on its own does not tell an owner much. What matters is what changes on an ordinary working day once the feature exists. The table below goes module by module through what Yukti AI built into the GM Healthcare prototype and the practical business benefit each one is designed to give. These are benefits the system enables; because the prototype runs on demo data, none of them is presented as a measured result.
| Feature | What it does | Business benefit |
|---|---|---|
| Management dashboard | Target, month-to-date sales, outstanding, pending orders and the leaderboard on one screen, every tile linked to its source | The owner starts the day knowing where the month stands, and can click into any number instead of asking someone to prepare a report |
| Ask Your ERP | Plain-language questions answered from live roll-ups, with a link to the source screen | A director can ask "which batches expire in 30 days" or "who is below target" and get an answer in seconds, without knowing which report to open |
| Alert Centre | Severity-ranked alerts for expiry, pace, credit, reorder and QC delays | Problems surface while there is still time to act, rather than at month end |
| Automation Centre | Ten trigger-action rules that a manager can switch on or off | Routine follow-ups (reorders, reminders, escalations) stop depending on someone remembering them |
| Customer master and analytics | Chemists, distributors, agencies and hospitals with orders, ledger, schemes and buying pattern | Sales managers can see which counters are growing and which are going quiet, and plan visits around that |
| Credit control | Sanctioned limit, utilisation and a hard block at 100% with a logged override | Credit risk is checked before the goods leave, which protects cash flow and makes exceptions visible |
| PTR / PTS pricing | MRP, price to retailer and price to stockist held per SKU | The right trade price lands on every invoice, and margin leakage from manual pricing is reduced |
| Returns and credit notes | Saleable, damaged and expired return routes with credit and debit notes | Returns are settled against the right batch and customer, so stock and ledgers stay accurate |
| Medical rep mobile app | Visits, GPS check-in, suggested order, auto-applied schemes, credit check, collections | A medical representative books a cleaner order in less time at the counter, and the office receives it without retyping |
| Beat plans and attendance | Weekday routes, GPS attendance and visit compliance | Managers see field coverage as it happens instead of relying on end-of-day phone calls |
| Scheme engine | 14 mechanics with slab tables and liability accruing on qualification | Scheme cost is known in real time, and disputes over who qualified for what are settled by the data |
| Target engine | 7 target types, 4 periods, 4 assignee levels and a pace line | Shortfalls are visible by the middle of the month, while there is still time to recover |
| Incentives and payouts | Staff incentive slabs computed from the same order lines | The field team trusts the incentive number, because it comes from the same orders they booked |
| FEFO allocation | Earliest-expiring released batch with a 90-day minimum residual shelf life, with the reason shown | Older stock moves first, customers do not receive short-dated goods, and the warehouse can explain every pick |
| Expiry radar and action list | Stock bucketed by days to expiry, with a ranked list of counters to push each batch to | Near-expiry stock becomes a sales task for the field team instead of a write-off for accounts |
| Batch traceability | Raw-material GRN to production, QC, warehouse and every customer reached, with returns | A batch complaint or a regulator's question can be answered from one screen path |
| Production and consumption variance | Production orders, stages and raw-material use against standard | Plant managers can spot over-consumption batch by batch |
| QC check and release | Test results and a release decision; only released batches can be sold | Unreleased stock cannot slip into an order by mistake, and slow QC is escalated |
| Purchase, GRN and reorder levels | Suppliers, purchase orders, receipts, invoices, returns and reorder alerts | Raw materials and packaging are reordered before they run out, not after production stops |
| Dispatch board | Pending dispatch, FEFO picking, packing, transporter, LR, e-way bill and POD | Every order has a visible status from approval to delivery, so customers and sales get straight answers |
| Receivables and ageing | Outstanding by ageing bucket, down to the customer ledger and payment entry | Accounts chases the right customers first, and collections feed straight back into credit limits |
| API export book | Molecules, buyers, drum-wise consignments and letter-of-credit receivables | The export desk works on the same plant data as domestic sales, with its own units and terms |
| Compliance flags | Schedule H/H1/X, drug licence expiry, HSN-wise GST, e-invoice IRN and e-way bill | Statutory checks happen inside billing and dispatch instead of on a separate checklist |
| Roles and audit logs | Nine roles from a permission matrix, plus a log of who did what | Each person sees only their own work, and changes can be traced back to a user |
| Reports centre | Sales, product, staff, territory, customer, scheme, inventory, purchase, production, dispatch, collection and margin reports | Every report reads from the same order lines, so two reports never disagree |
How does pharma ERP software help a company sell more?
Most pharma companies do not lose sales because the product is wrong. They lose them in small, everyday ways: a representative forgets a product the chemist usually buys, a scheme is explained badly, a target shortfall is noticed too late, stock expires on the shelf, or a good customer is put on hold because nobody chased the last payment. The GM Healthcare prototype is designed to close each of those gaps. Here is how each part contributes, in plain terms.
1. The field force spends its time selling, not writing
The medical representative or field sales app opens on today's visits from the beat plan. At the counter, the representative checks in with GPS and sees a suggested order built from that customer's purchase history, with quantities already filled in. Instead of trying to remember what a chemist bought last month, the rep starts from a sensible list and adjusts it. That makes it far less likely that a regular product is simply forgotten, and it shortens the time spent on each call. The order goes to the office the moment it is placed, with a WhatsApp share for the customer, so nothing is retyped from a notebook later.
2. Schemes that apply themselves are schemes that get used
A scheme only drives sales if the customer understands it and the representative applies it correctly. In the app, schemes apply automatically as quantities are added (the demo shows a 10 plus 1 free-goods offer), and the representative can see how close the customer is to the next slab. That gives the rep a natural, honest conversation at the counter: "two more boxes and you reach the next slab". On the management side, the scheme engine accrues cost only when someone actually qualifies, so the owner can see which schemes are really pulling volume and which are only costing money.
3. Targets measured against pace, not a flat percentage
A flat "60% achieved" means very different things on the 10th and on the 28th. The target engine compares progress with a pace line (the share of the month already gone), shows the required daily run-rate and projects the close. A sales manager can see by the middle of the month which executives and territories are drifting, and the automation rules nudge the manager when someone crosses 90%. The point is simple: shortfalls are visible while there is still time to recover them.
4. Reorder suggestions that keep counters stocked
The suggested order is effectively a reorder prompt for each counter. On top of it, the automation rule for an active customer who has not ordered in 45 days creates a win-back visit task and flags the account. Customer analytics show which chemists and distributors are going quiet. Together, these help the sales team protect repeat business rather than discovering a lost account weeks later.
5. Expiry push lists turn near-expiry stock into sales
This is one of the most pharma-specific ideas in the system. When a batch enters the 31 to 60 day window, the expiry radar builds an action list of every counter that has bought that product before, ranked by volume, with a suggested push quantity. That list can be sent to the field team. Stock that would otherwise be written off or returned gets a real chance to sell while it still has usable shelf life, through customers who already buy it.
6. Credit control and collections protect cash flow, and cash flow protects sales
Selling more on credit only helps if the money comes back. Credit is checked before the order is placed, in the field app as well as the office, with a hard block at 100% utilisation and a logged override for genuine exceptions. Receivables are shown in ageing buckets, payment reminders are scheduled at 3, 15 and 30 days past due (as a simulated WhatsApp action in the prototype), and representatives can record collections on the same visit. When payments come in faster, credit limits free up and good customers can keep ordering without being put on hold.
The sales story is not one magic feature. It is a chain: the right products are suggested, schemes are applied correctly, shortfalls are seen early, near-expiry stock is pushed to the right counters, and cash is collected so credit keeps flowing. This is the same thinking Yukti AI applies in its custom CRM software and AI CRM work, adapted here to the way pharma distribution actually works in India.
How this system makes a pharma business AI-enabled, honestly
"AI" is used loosely in a lot of software marketing. This section separates what is genuinely in the GM Healthcare prototype today from what could sensibly be added next. The short version: the intelligence that exists today is data-driven and rule-based. It reads the ERP's own numbers, spots what needs attention and tells the right person. It does not call a generative AI model.
What is built today
- Ask Your ERP. An owner or manager types a question in ordinary language. The system recognises the products, customers, territories and executives named in it, works out the answer from the live roll-ups and links to the screen the number came from. In the code it covers questions such as an executive's orders, collections and rank; who is below target or behind pace; the sales leaderboard; stock of a named product by batch; batches nearing expiry; customers with the highest outstanding; collections; orders pending dispatch; which schemes cost the most; and a molecule's regulatory filings and HSN. Because it reads the same data as the dashboard, its answer always matches the screen.
- Data-driven alerts. The Alert Centre ranks problems by severity: a batch close to expiry with a suggested action, an executive falling behind the pace line, an account over its credit limit, stock below reorder level, a batch stuck at QC. Nobody has to go looking for these; the system raises them.
- Insight from history. The suggested order on the medical rep app is computed from each customer's purchase history, and the expiry action list ranks counters by how much of that product they have bought. Both are decisions made from data rather than memory.
- Explainable decisions. FEFO allocation does not just pick a batch; it states why. That matters in pharma, where a warehouse team and an auditor both need to understand the reasoning.
- Automation rules. Ten trigger-action rules turn insight into action: a reorder breach drafts a purchase requisition, a credit breach holds billing, a scheme slab locks the reward against liability.
Possible next steps (not built yet)
The following are natural extensions on the same data. They are not part of the current prototype, and are listed so the roadmap is clear rather than implied.
- A generative AI daily briefing that reads the roll-ups each morning and writes the owner a short note: what moved, which batches need pushing, which executives are behind and which customers are overdue.
- Demand forecasting by product and territory from order history, to guide production planning and raw-material purchase.
- Smarter reorder and scheme suggestions, for example proposing which scheme mechanic tends to move a slow product, based on past scheme performance.
- A WhatsApp ordering assistant for chemists, built on the WhatsApp Business API, that takes a repeat order in chat and creates it in the ERP. Yukti AI already builds WhatsApp AI chatbots and AI agents of this kind for other businesses.
- Collection risk flags that highlight customers whose payment pattern is slipping before they cross the credit limit.
The reason these are realistic next steps is that the hard part, one clean and consistent pharma dataset, already exists. AI is only as good as the data it reads, and in this design every number reconciles. That is the foundation of an AI ERP.
Before vs after: the manual work this pharma ERP removes
The left-hand column below describes how this work is commonly done in Indian pharma businesses that run on Excel, registers, phone calls and WhatsApp groups. It is a general description, not GM Healthcare's own account of its operations. The right-hand column is how the prototype handles the same job.
| Job | Before: Excel, registers and phone | After: in the system |
|---|---|---|
| Booking a field order | The rep writes the order in a diary or sends a WhatsApp message; someone in the office retypes it into billing | The rep books it in the app from a suggested order; it arrives in the office ready to process |
| Applying a scheme | The rep or billing clerk works out the free goods by hand, often differently each time | The scheme applies automatically from its slab table, the same way for everyone |
| Checking credit | Accounts is phoned after the order is taken, or the overdue is discovered after dispatch | The credit check runs before the order is placed, with a logged override for exceptions |
| Choosing which batch to send | The warehouse picks whatever is at the front of the rack | FEFO picks the earliest-expiring released batch with enough shelf life and states the reason |
| Finding near-expiry stock | A periodic stock count, by which time little can be done | The expiry radar buckets every batch continuously and produces a push list of counters |
| Tracing a batch | Files from purchase, production, QC and dispatch are collected and matched by hand | One traceability chain from raw-material GRN to every customer, with returns |
| Tracking targets | A monthly sheet compiled from sales figures, often a week late | Live achievement against a pace line, by executive, territory and level |
| Calculating incentives and scheme payouts | Month-end spreadsheets and arguments over who qualified | Computed from the same order lines, with liability accrued only on qualification |
| Chasing payments | Accounts goes through a ledger and phones customers one by one | Ageing buckets show who to chase first; reminders are scheduled at 3, 15 and 30 days overdue |
| Reordering raw material | Noticed when production is about to stop | A reorder-level breach raises an alert and drafts a purchase requisition |
| Following up drug licence expiry | Remembered, or not, when the customer's licence lapses | A rule flags licences within 30 days of expiry and requests the renewed copy |
| Answering the owner's questions | Someone is asked to prepare a report, which differs from another report | Ask Your ERP or the dashboard answers from the same data, linked to its source |
One order, step by step
Here is a single field order traced through the system, so the "after" column is concrete rather than abstract.
At no point in that chain does anyone retype the order, recalculate the scheme, phone accounts about credit or hunt for the right batch. Each step reads what the previous step wrote. That is what workflow automation means in practice for a pharma company, and it is the same approach behind Yukti AI's workflow automation and Excel and Tally replacement projects.
What a working day looks like in a pharma company running on one ERP
This is an illustrative day, built from the workflows the prototype supports. It shows how the different roles touch the same data without passing spreadsheets to each other.
Morning: the owner and the sales manager
The director opens the command centre and sees month-to-date sales against target, the leaderboard and total outstanding. The Alert Centre has already flagged a handful of batches inside the 60-day expiry window, two executives behind the pace line and one distributor over its credit limit. Rather than calling a meeting to collect numbers, the director asks Ask Your ERP which salespeople are below target and opens the staff 360 profile for the one furthest behind. The sales manager, looking at the same screens, adjusts that executive's beat for the day.
Mid-morning: the field force
Across the territories, medical representatives open the mobile app on today's visits. At each chemist they check in, start from the suggested order, let the scheme apply, pass the credit check and place the order. Where the expiry radar has pushed a batch to their list, they offer it to the counters that already buy that product. Where a customer has an overdue invoice, they record the collection on the spot.
Afternoon: the warehouse and dispatch
The warehouse manager works from the pending dispatch queue. Each picking list already shows the FEFO batch and the reason for it. Packing, transporter, LR number and the e-way bill for consignments above 50,000 rupees are recorded on the dispatch board, and a dispatch update is queued for the customer on WhatsApp (a simulated send in the prototype).
Through the day: plant, QC and purchase
The production manager tracks production orders by stage and checks raw-material consumption variance. QC releases tested batches, and any batch waiting more than 48 hours is escalated. A raw material dropping below its reorder level raises an alert and a draft requisition for the purchase manager. The export desk updates drum-wise consignments and letter-of-credit receivables for API buyers on the same plant data.
Evening: accounts and the close of day
Accounts opens receivables by ageing bucket, works through the 60+ day customers, opens each ledger and records payments received. By the end of the day the dashboard, the target screen, the scheme progress and the receivables all reflect what actually happened, because every one of them is a roll-up of the same order lines.
What each person in a pharma company gets from the system
Every team sees a different slice of the same pharma business management system. These are the practical benefits each team is designed to get.
Owner / Director
One honest view of sales, targets, outstanding, stock risk and exports, with Ask Your ERP for quick questions. Decisions are made from current numbers, not last week's sheet.
Sales Manager
Live target achievement against pace, a leaderboard, staff 360 profiles, scheme progress and early nudges when someone is close to target or falling behind.
Medical Rep / Field Sales
A phone app built for the counter: today's visits, a suggested order, automatic schemes, credit check, collections and a clear view of their own incentive.
Warehouse Manager
FEFO picking with reasons, an expiry radar with push lists, multi-warehouse stock and a dispatch board from packing to proof of delivery.
Production Manager
Production orders by stage, consumption variance against standard, and QC status that decides what can be sold.
Purchase Manager
Reorder alerts with draft requisitions, supplier and purchase order tracking, and GRNs that start the batch traceability chain.
Accounts
Ageing receivables, customer ledgers, collections, payables and credit limits that the sales team also sees, so there is one version of who owes what.
Export desk
A dedicated API export book with molecules, buyers, drum-wise consignments and letter-of-credit receivables, on the same plant data as domestic sales.
HR / Admin
Staff records, GPS-based attendance, roles and incentive data, without a separate attendance register.
Nine roles, two interfaces
Navigation is generated from a permission matrix, so a warehouse manager does not have finance routes registered at all. Roles switch from the avatar menu in the prototype.
Super Admin
Everything, including roles and permissions, users, audit logs and settings.
Management / Owner
Command centre, targets, schemes, finance, reports and the automation centre.
Sales Manager
Team performance, targets, schemes, customers and collections.
Medical Rep / Field Sales
The mobile field app: visits, order booking, collections and scheme progress.
Purchase Manager
Suppliers, purchase orders, GRN and raw material.
Warehouse Manager
Stock, batches, expiry radar and dispatch.
Production Manager
Planning, production orders, consumption and QC.
Accounts
Invoices, receivables, payables, collections and ledgers.
HR / Admin
Staff, roles, attendance and incentives.
What is real in this pharma ERP case study, and what is demo data?
This page states the status plainly so that nobody mistakes a prototype for a production rollout.
| Real | Demo or illustrative |
|---|---|
| Company name, registered address, tagline, vision, mission, goals, milestones and directors, taken from the company's published website | Statutory registration and licence numbers in the demo are sample values and are not shown on this page |
| The 11 API molecules and the destination countries the company has published | The 18 API buyer company names are invented |
| The software: roughly 60 screens, 9 roles, the field app, FEFO, expiry radar, traceability, scheme and target engines | The 60 formulation SKUs, brand names, compositions, prices and the 432 customers |
| The logic: every dashboard number is a roll-up of the same order lines | All order, stock, sales and collection figures, generated from a fixed seed in the browser |
| The deployed live demo | There is no backend, login or persistence yet; anything added lives for the session only |
| The stated roadmap | Beta and Planned capabilities appear in the interface but are not wired |
No client testimonials, results or percentages are claimed. Figures that appear on this page, such as 2.25 Cr, 1.85 Cr or 82%, belong to the demo dataset and illustrate how the screens read.
Technology and the path to production
The prototype is a React and TypeScript single-page web app that generates its dataset in the browser from a fixed seed, so every reload is identical and every number reconciles. It runs in a browser on desktop or phone with nothing to install, and is deployed on Vercel as a live demo with an automated deployment pipeline.
To go live the build would add a database and backend, real authentication and role enforcement, data migration from the client's existing records, and integrations such as Tally, the WhatsApp Business API, and e-invoice and e-way bill providers. The screens and data model do not need to be redesigned for that, because they were already reviewed against the seeded data.
Full technical stack
- React 18 and TypeScript (strict), built with Vite.
- Tailwind CSS for the desktop shell and a separate mobile shell for the field app.
- React Router for about 60 screens with role-based navigation.
- Recharts for dashboards, ageing, targets and export charts.
- Deterministic seeded data layer in typed modules for catalog, people, customers, inventory, sales, targets, schemes, exports, operations, field and analytics.
- Vercel hosting with GitHub Actions deployment.
Terms used in this case study
- API
- Active Pharmaceutical Ingredient: the active molecule in a medicine, made in bulk by a manufacturer such as GM Healthcare.
- FEFO
- First-expiry-first-out: sell the batch that expires earliest, provided it is released and has enough shelf life left.
- GRN
- Goods receipt note, recording raw material received from a supplier.
- PTR / PTS
- Price to retailer and price to stockist, the trade prices used alongside MRP.
- Beat plan
- A recurring route of customer visits for a field executive.
- IRN
- Invoice reference number issued under India's GST e-invoicing system.
What can be added on the same data
None of the items below are part of the current prototype. They are the natural next phases and would build on records the system already holds.
Backend and login
A database, real authentication, role enforcement and data migration, turning the prototype into a production system.
Generative AI briefings
A daily owner briefing drafted from the roll-ups, with flags on slow-moving batches and executives falling behind pace. Today, Ask Your ERP answers from data rules and does not call a generative model.
WhatsApp Business API
Real sends for order confirmations, dispatch updates and payment reminders, and WhatsApp order capture from chemists.
Compliance integrations
A live e-invoice and e-way bill provider, and Tally sync for accounts.
Portals
Customer and distributor portals for ordering, ledgers, scheme progress and secondary-sales upload.
Recall management
Batch-level recall with downstream customer notification, reusing the traceability chain.
Is this pharma ERP right for your business?
It suits Indian pharma businesses that make, store and sell batch-controlled products and want one set of numbers.
- API and bulk-drug manufacturers that also export
- Formulation companies with a field sales force, schemes and targets
- Pharma distributors and C&F agents who manage batch and expiry stock and chemist credit
- Nutraceutical and wellness brands selling through chemists and distributors
Related reading: AI automation for healthcare, AI automation for manufacturers and AI ERP.
Built in Surat, for businesses across Gujarat and India
Yukti AI is a software company at 220, Leonard Square, Yogichowk, Varachha, Surat, Gujarat, building custom business management systems across Surat, Gujarat and India. Other manufacturing builds include an ERP for a box factory, a fastener manufacturing ERP and a manufacturing system for Splenzo.
How is a pharma ERP quoted, and how long does it take?
Yukti AI does not sell this as a subscription package. After a free workflow audit, each business gets a fixed quote for a one-time custom ERP build covering only the modules it needs.
| What moves the quote | Why |
|---|---|
| Number of modules | A batch inventory and sales start is smaller than manufacturing, field force, schemes and exports together |
| Roles and access | Each role adds screens and permission rules |
| Integrations | Tally, the WhatsApp Business API, e-invoice and e-way bill providers each add work |
| Mobile field app | A mobile-first interface is a separate build from the desktop screens |
| Data migration | How many products, batches, customers and open invoices move in from Excel or Tally |
For what drives the price of custom software in India, read Custom ERP software cost in India. If your records are in spreadsheets today, replacing Excel and Tally with one system explains how the move is made.
Questions pharma manufacturers and distributors ask
Explore more
Manufacturing ERP Software
Production, batches and stock for manufacturers, built around your plant.
Custom ERP Software
An ERP built around your own workflow, statuses and documents, not a generic template.
AI Business Management System
CRM, ERP, billing and WhatsApp in one platform, with an AI layer that reads your data.
AI ERP
How an AI layer analyses business data and tells the owner what needs attention.
Healthcare
AI automation for healthcare and pharma businesses in India.
Manufacturing
AI automation for manufacturers: production, inventory and dispatch.
WhatsApp Automation
Order confirmations, dispatch updates and payment reminders on WhatsApp.
All case studies
More systems Yukti AI has built for Indian businesses.
Contact
Book a free workflow audit with Yukti AI in Surat.
Summary
- Yukti AI, a software company in Surat, Gujarat, built a working pharma ERP prototype for GM Healthcare, an API manufacturer and exporter at Saykha GIDC, Bharuch.
- The pharmaceutical manufacturing software covers purchase, production, QC, finished goods, sales, dispatch, finance, exports and analytics on one dataset, with about 60 screens and nine roles.
- FEFO allocation picks the earliest-expiring released batch with a 90-day minimum residual shelf life, and an expiry radar buckets stock and lists customers to push it to.
- Batch traceability links raw-material GRN, production, QC, warehouse and every customer reached, with returns.
- A 14-mechanic scheme engine and a target engine with a pace line, plus credit control that blocks orders at 100% utilisation, support the pharma field force, which has its own mobile app.
- Ask Your ERP answers plain-language questions from live roll-ups and links to the source screen; it is a data-query engine, not a generative model.
- It is a front-end prototype on seeded demo data with no backend or login yet, not a production deployment with real customers.