Custom ERP Solution for an Assam based Flour Mill
Industry: Flour Milling & Food Processing | Project Type: Custom Manufacturing ERP Development | Location: Jorhat, Assam | Timeline: 8 months
Eastern Flour Mills, a mid-sized flour milling operation based in Jorhat, Assam, had grown steadily over the previous decade — expanding capacity from a single roller mill to three production lines handling wheat atta, maida, suji, and bran. But the business systems supporting those lines had not kept pace. Procurement was still tracked on ledger books. Quality records were handwritten in registers. Distributor orders came in over the phone and were logged on Excel sheets. Every month, the management team spent days pulling together numbers that should have been available at a glance.
We were brought in to design and deliver a custom flour mill ERP system that would bring every function — wheat procurement, milling production, inventory, quality control, sales, dispatch, and finance — onto a single, integrated platform. This case study documents what we built, how we built it, and what it delivered.
Diagnosing the Problem: A Three-Week Discovery at the Mill
Before writing a single line of code, our team conducted a structured discovery phase at the Jorhat facility. We interviewed the mill manager, shift supervisors, the procurement officer, the quality inspector, the accounts manager, and the sales coordinator. We also spent two full days observing production across shifts. The problems we identified were specific and costed:
- No real-time production visibility: The mill manager had no live picture of output at any milling section. Shift summaries were entered manually the following morning — by which time any process deviation had already caused losses.
- Reactive wheat procurement: Raw wheat stocks were monitored manually by walking to the godown. Stock-outs were discovered only when a line stopped. There was no minimum-stock alert.
- Disconnected quality records: Every batch test — moisture, ash, protein content — was recorded in a paper register. Monthly quality trends could not be computed without significant manual effort. FSSAI audit preparation took the quality team more than a week every time.
- No batch traceability: Once milled flour left the facility in bags, there was no system to link a specific finished-goods batch back to the wheat lot it came from. A quality complaint from a distributor could not be traced to its source.
- Finance reconciliation delays: Wheat purchase invoices were matched to GRNs manually, taking 5–6 working days. Distributor outstanding statements were prepared once a month.
Our assessment confirmed that a custom ERP was the right approach. Off-the-shelf manufacturing software does not account for the specific nuances of flour milling — extraction ratios, by-product handling, variable moisture corrections on wheat weight, or FSSAI record formats. Our article on Custom ERP vs Off-the-Shelf Software: What Small Manufacturers Must Know covers this trade-off in detail.
Solution Architecture
Technology Stack
- Backend: ASP.NET (C#), RESTful Web API
- Frontend: Responsive web application (HTML5, CSS3, JavaScript)
- Database: Microsoft SQL Server 2019 (on-premise, dedicated server)
- Reporting: SSRS with embedded Excel export for all operational reports
- Weighbridge Integration: Direct interface with the factory weighbridge for automatic truck-weight capture on wheat inward
- Barcode Scanning: Bag-level barcode tracking for finished-goods dispatch
- Email & Alerts: SMTP-based alerts for low stock, quality failures, pending approvals
- Deployment: On-premise server with daily automated backup to cloud storage; no internet dependency for core operations
A Snapshot: How the Eight Modules Connect
Modules Developed
1. Wheat Procurement & Vendor Management
Wheat procurement at a flour mill is high-frequency and high-value. The module managed the full procurement cycle: raising purchase orders to approved wheat dealers, capturing truck arrivals with direct weighbridge data (eliminating manual weight entry), recording variety and moisture readings at inward, and generating goods receipt notes (GRNs) automatically. Vendor performance — delivery reliability, moisture consistency, price — was scored quarterly, enabling better supplier negotiations. For more on effective procurement workflows within ERP, see our guide on ERP Integration with Accounting Systems.
2. Milling Production Planning & Job Cards
The planning module converted confirmed sales orders into a shift-wise milling schedule. It accounted for each line's rated capacity, the wheat-to-flour extraction ratio (configurable per wheat variety and season), and current raw material availability. Digital job cards were generated for each production batch and were available on shared terminals at the mill floor. Supervisors updated actual output — flour yield, bran yield, waste — at the end of each shift. Any yield that fell more than 2% below plan triggered an automatic alert to the mill manager.
3. Inventory Management (Raw Wheat, WIP & Finished Goods)
The inventory module maintained three distinct ledgers, updated in real time: raw wheat (tracked by lot, variety, and moisture-corrected weight); work-in-progress (wheat under conditioning or milling); and finished goods (atta, maida, suji, and bran, tracked by pack size — 5 kg, 10 kg, 25 kg, and 50 kg bags). Minimum stock thresholds were configurable per SKU. When any finished-goods SKU dropped below its reorder level, the system raised an automatic production requisition. For more on ERP-driven inventory management, read: Inventory Management Software for Businesses.
4. Quality Control & FSSAI Compliance
This was one of the most business-critical modules for Eastern Flour Mills. Every inward wheat lot was tested for moisture content, foreign matter, and insect infestation — results recorded digitally against the GRN. Every finished-goods batch was tested for moisture, ash content, and gluten strength before release. The system maintained a complete digital quality register, replacing the paper registers entirely. FSSAI inspection reports could now be generated with a single click, pulling structured data across any date range. Quality rejection trends by supplier, wheat variety, and shift were visible on the management dashboard.
5. Sales Order Management & Distributor Portal
Sales orders from distributors across Assam and other northeastern states were entered by the sales coordinator against a product master that defined valid SKUs, current prices, and minimum order quantities. The system validated available finished-goods stock and production schedule before confirming a dispatch date. Distributors received automated order acknowledgements by email. The sales coordinator tracked every order from confirmation through milling, packing, dispatch, and delivery — all from a single screen. Automated balance statements were emailed to each distributor on the 1st of every month.
6. Finance, Costing & Profitability
The finance module covered accounts payable, accounts receivable, and — critically — job-order costing. For every production batch, the system captured actual wheat consumed (at moisture-corrected weight), milling electricity units, labour hours per shift, and packaging material used. This gave the finance team a precise cost-per-quintal of flour for every batch. The management dashboard showed real-time gross margin per product line. Three-way matching of purchase orders, GRNs, and vendor invoices was automated, cutting the accounts-payable cycle from 5–6 days to the same working day. Integration hooks exported accounting vouchers in Tally-compatible format, preserving the finance team's existing workflow without disruption.
7. Dispatch & Delivery Tracking
Once a finished-goods batch passed quality release, the dispatch module managed the full outward cycle: packing list generation, bag-level barcode printing, lorry receipt (LR) capture, and e-way bill reference recording. The sales coordinator and the distributor could both track dispatch status in real time. Proof of delivery (signed LR copy, uploaded by the logistics team) triggered invoice generation and accounts-receivable entry automatically — eliminating the previous practice of invoice generation two to three days after dispatch.
8. Management Dashboard & Reports
The owner and management team received a live dashboard showing: production output vs. plan (shift-wise and cumulative monthly), current raw wheat position in days of production, finished-goods stock by SKU, pending distributor orders, quality rejection rates, and a cash flow snapshot (outstanding receivables and payables due in the next 14 days). Ten standard operational reports — daily production report, milling yield analysis, raw material consumption report, quality rejection analysis, distributor sales report, vendor performance scorecard — were emailed automatically to the relevant manager every morning.
Development & Implementation Workflow
Before vs. After: Measurable Results
| Metric | Before ERP | After ERP | Improvement |
|---|---|---|---|
| On-time dispatch rate | 68% | 92% | +35% improvement |
| Wheat stock-outs per month | 6–8 incidents | 0–1 incidents | "90% reduction |
| Milling yield accuracy vs. plan | Ad-hoc, untracked | Monitored per shift | Full accountability |
| Quality rejection rate | 5.2% | 1.8% | 65% reduction |
| Batch traceability (wheat lot to bag) | Not available | 100% traceable | Full traceability |
| AP reconciliation cycle | 5–6 days | Same day | "90% faster |
| FSSAI audit preparation time | 8–10 days manual | 1 click, 20 minutes | Fully automated |
| Management reporting effort | 2.5 days manual collation | Automated daily emails | Zero manual effort |
Why Flour Mills in Northeast India Need Purpose-Built ERP
Flour milling sits at a unique intersection of food processing, commodities trading, and FSSAI-regulated manufacturing. Standard ERP platforms — whether entry-level accounting tools or large-enterprise suites — are not built for milling-specific requirements: moisture-corrected wheat weight calculations, extraction ratio tracking, by-product (bran) yield accounting, or batch-level FSSAI record generation.
A purpose-built custom ERP for flour mills addresses these gaps directly. It is sized and priced for an SME, built precisely around existing processes, and can grow as the operation grows. Our full guide on Custom ERP Software for Small Manufacturing Companies includes a vendor evaluation checklist and a total-cost-of-ownership comparison. For businesses exploring whether to build or buy, our article How Custom Software Is Helping Indian Small Businesses Compete with Large Enterprises offers a broader perspective.
Scalability & Future Roadmap
The ERP was delivered with a modular, API-first architecture. After the initial go-live, the client requested two enhancements: a distributor self-service portal for order placement and real-time balance checking, and an automated FSSAI e-filing integration that we are currently building. The platform is also designed to accommodate IoT-based sensor data from the roller mills — enabling predictive maintenance alerts — when the client is ready for that next step.
For background on why an API-first foundation matters for long-term ERP scalability, see: The Role of APIs in Modern Software & ERP Development. You may also find our blog post on How to Scale Your Business with Custom Software Solutions useful for planning your own growth roadmap.
Related Resources
- Software Solutions for Manufacturing Companies
- How to Successfully Implement Custom ERP in a Small Manufacturing Company
- Case Study: How a Small Manufacturer Automated Production and Reduced Waste by 35%
- Cloud-Based ERP vs On-Premise ERP: Cost, Security & Scalability Compared
- Software Development Lifecycle (SDLC): Phases Explained in Detail