All Case Studies
Anonymized ERPNext Case Study · Confidentiality Preserved
How a pharma distributor gained batch-level stock control with ERPNext.
Per our confidentiality policy, client names, domains, document IDs, and private figures are omitted. All capabilities below describe the delivered ERPNext system behavior.
Client Type
Pharma & Medical Distributor
Platform
ERPNext / Frappe Cloud
Modules
Stock, QA, Buying, Selling, HR
Timeline
[N weeks — TO ADD]
The Problem
Without enforced batch and expiry rules in day-to-day warehouse operations, near-expiry stock accumulates silently while newer batches are picked first.
- • Picks not following earliest-expiry-first (FEFO) order.
- • Incoming goods entering sellable stock before Quality Inspection completes.
- • Customers exceeding credit limits on quotations and sales orders with only soft warnings.
- • Excessive email and notification noise across approval workflows.
What We Built
FEFO Picking & Batch Guardrails
- Items default to batch-tracked with inspection required.
- Pick Lists allocate earliest-expiry stock first and block FEFO violations.
- Option to pick a full line from a single batch; negative stock by batch/warehouse is blocked.
QA Quarantine & Split Receiving
- Separate accepted and rejected (quarantine) warehouses on Purchase Receipts.
- Multi-row batch splitting with deterministic per-row Quality Inspection links.
- Rejected batches return via Purchase Return and replacement receipt.
Credit Control & Named Overrides
- Per-customer credit limits enforced on both Quotation and Sales Order.
- Exceeding the limit blocks save and submit rather than showing a warning.
- Controlled override records an override flag and named approver on the order.
Approvals, Dispatch & Safe Delivery
- Multi-step approvals with role permissions tuned to cut notification noise.
- Custom Frappe app with automated tests, staging verification, and dry-run live updates.
- Batch recall traceability to see which customers received any recalled batch in minutes.
Results & Operational Outcome
System-Enforced Outcomes
- • Pick Lists enforce earliest-expiry-first allocation and block non-FEFO picks before dispatch.
- • Uninspected receipts cannot enter sellable stock; rejected batches maintain a full return paper trail.
- • Credit-limit breaches are blocked at order entry unless explicitly approved and logged.
- • Quantitative metrics & client quote: [TO ADD — pending written client consent]
Next Step
Need the same control in your warehouse?
Book a free 30-minute process review. You get a one-page summary of the top problems we find, whether or not you hire us.