How a Textile Manufacturer Cut Inventory Holding Cost by 42% with ERPNext
A mid size woven fabric manufacturer replaced 14 disconnected Excel sheets with one ERPNext system and freed up 1.8 crore of working capital tied up in slow moving stock.
14 Excel sheets, 3 godowns, and no one who could say what was actually in stock.
This textile manufacturer produced 350 plus fabric SKUs across yarn count, weave pattern, and finishing variations. The product catalogue had grown over the years, but the tracking systems had not. Every department maintained its own Excel sheet. The mill supervisor had one for production. Stores had one per godown. Sales kept its own for what was promised to customers.
The result was predictable. Customers were quoted lead times based on stock that did not exist. Production was scheduled for fabric variants that were already in another godown. The CFO closed the books at the end of every month and routinely discovered 8 to 12 percent variance between physical stock and what the system claimed.
The leadership team had tried two ERP vendors before. The first quote was for SAP at 65 lakhs, which the board rejected. The second was an Odoo partner who promised go live in 6 weeks and disappeared after 9. By the time we were called in, the team was sceptical that any system could actually fix the chaos. They wanted proof, not promises.
Mapping the Real Workflow Before Touching the Software
- Fabric variants were ordered in bulk to chase volume discounts, then sat unsold when customer demand shifted to other patterns
- Yarn purchase orders were placed against gut feel rather than against confirmed production plans, causing chronic overbuying
- Three godowns held overlapping stock because each was managed by a different team with no shared view
- Quality rejections were recorded on paper and rarely fed back into the supplier scorecard, so the same defects kept arriving
- Sales teams had no way to check live stock before quoting, so promises were made that production could not honour
-
🏭ManufacturingProduction plans built from confirmed sales orders, with multi level BOM for yarn, weave, and finish
-
📦Inventory ManagementLive stock across all 3 godowns, with FIFO costing and aging reports flagging slow movers
-
🛒Purchase ManagementYarn purchase suggestions triggered by MRP, with vendor scorecards built from quality data
-
💼Sales Order ManagementSales team quotes against live stock and confirmed production capacity, not gut feel
-
🛡Quality InspectionIncoming yarn and finished fabric checks logged digitally, feeding supplier ratings automatically
Live in 16 Weeks. Zero Production Stops.
The rollout was sequenced so the mill never stopped weaving. Each phase built on the previous one, with operators learning the new system on their own SKUs and their own customer orders.
We sat with the mill supervisor, godown in charges, sales lead, and CFO. We mapped how a customer order travelled from quote to dispatch, catalogued every Excel sheet in use, and identified the four handoff points where stock data went stale.
Item master was rationalised from 1,400 entries down to 380 active SKUs. BOMs were rebuilt for the top selling weave patterns. Opening stock was physically counted across all three godowns and uploaded as the new baseline. Approval flows mirrored existing factory practice so adoption would not require a culture shift.
A batch of real customer orders ran through ERPNext alongside the legacy Excel workflow. The parallel run surfaced edge cases in fabric finishing handoff which were resolved before full cutover. Operators on the looms had four weeks to get comfortable before Excel went away.
ERPNext became the only system of record across all three godowns and the head office. Training was tailored by role. A 30 day hypercare window followed, with same day issue resolution and a daily standup with the leadership team.
Numbers Measured in the First Quarter After Go Live
For fifteen years we ran the mill on Excel and instinct. Within ninety days of going live on ERPNext, our stock variance at month end dropped from twelve percent to under two. Sales is finally quoting on real numbers.
Your Mill Could Free Up Cash Like This
We start with a free 30 minute assessment of your current setup. No commitment. No pressure. Just a clear picture of what is possible for your operation.