ERP workflow
The ideal ERP workflow for a food manufacturing business, enquiry to GST return
What is the ideal ERP workflow for a food manufacturing business?
The ideal food ERP workflow is one unbroken chain: enquiry → quotation → sales order → production plan → purchase order → GRN with incoming QC → lot storage with expiry → recipe and BOM → material issue under FEFO → production batch with yield, by-product and rejection → finished-goods QC → batch stock → dispatch with e-invoice and e-way bill → collection → accounting and GST return. Each stage must inherit its data from the previous one, so nothing is re-entered and every batch stays traceable in both directions.
Key takeaways
- The test of a food ERP is not module count, it is whether each document is created from the previous one instead of typed again.
- Two flows must be separated but linked: the demand chain (enquiry → order → dispatch → collection) and the supply chain (plan → purchase → batch → stock).
- Incoming QC belongs before put-away, not after. Material that failed QC must be physically and systemically unable to reach a batch.
- The production batch is the pivot of the whole system. If yield, by-product, rework and rejection are not captured there, no downstream report can be trusted.
- GST is not a month-end module. E-invoice and e-way bill are dispatch-time events, so compliance either happens in the flow or becomes a reconciliation project.
- Implement in this order: masters, then purchase-to-stock, then batch production, then sales-to-collection, then GST. Sequencing wrong is the usual reason go-live slips.
Key figures
- 14
- Stages in a complete food manufacturing transaction chainBasis: Enquiry, quotation, sales order, production plan, purchase order, GRN with incoming QC, lot storage, recipe, material issue, production batch, FG QC, dispatch with e-invoice, collection, accounting and GST.
One chain, two halves
Food manufacturers usually buy software one problem at a time — billing here, stock there, production in a register, accounts in Tally — and then spend the next three years reconciling. The alternative is not "more modules". It is one chain in which every document is born from the document before it.
The chain has two halves that must be separated conceptually and joined operationally:
Enquiry → Quotation → Sales order → Dispatch plan → Batch allocation → GST invoice + e-invoice + e-way bill → Receipt → Ageing & follow-up
Production plan → Purchase requisition → Purchase order → GRN + incoming QC → Lot storage with expiry → Recipe/BOM → Material issue (FEFO) → Production batch → FG QC → Batch stock
They meet in two places: the production plan, which must be driven by real orders and stock rather than by hunch, and the batch allocation at dispatch, which is what makes a recall possible later. If either link is manual, the system is decorative.
The 14 stages and what each must capture
| # | Stage | Must capture | Failure avoided |
|---|---|---|---|
| 1 | Enquiry | Source, product interest, quantity, expected date, owner | Leads dying in WhatsApp with no owner |
| 2 | Quotation | Rate, validity, tax treatment, terms, approval if below floor price | Salesmen quoting below cost from memory |
| 3 | Sales order | Confirmed quantity, delivery date, credit check against limit and overdue | Producing for a customer who cannot pay |
| 4 | Production plan | Orders + stock + shelf life + seasonality, per SKU per day | Overproduction, then expiry write-offs |
| 5 | Purchase requisition / PO | Supplier, rate, quantity from BOM shortfall, expected date | Buying on hunch and blocking working capital |
| 6 | GRN with incoming QC | Lot number, quantity received vs ordered, fat/SNF or equivalent specs, accept/reject | Bad material entering a batch |
| 7 | Put-away | Warehouse or tank, manufacturing date, expiry date, storage condition | Losing the expiry clock the moment stock lands |
| 8 | Recipe / BOM | Versioned quantities, temperatures, timings, standard yield, expected by-product | Yield comparisons that mean nothing |
| 9 | Material issue | Batch reference, FEFO lot selection, planned vs actual issue, reason code on extras | Silent over-consumption found at stock count |
| 10 | Production batch | Good output, by-product, rework, rejection with reason, measured loss, forced balance | A wastage figure nobody can act on |
| 11 | Finished-goods QC | Spec results, pass/fail, hold status, batch release authority | Out-of-spec product reaching a customer |
| 12 | Batch stock | Batch-wise quantity, manufacturing and expiry dates, FEFO pick order | Selling near-expiry stock while fresh stock ages |
| 13 | Dispatch and invoice | Batch allocated per line, GST invoice, e-invoice IRN, e-way bill, vehicle | A recall you cannot execute; compliance gaps |
| 14 | Collection and accounting | Receipt against invoice, ageing bucket, follow-up owner, automatic journals | Chasing payments from memory; month-end reconstruction |
Stage 6 deserves its own rule: QC before put-away
The most common structural mistake in food ERP implementations is recording the GRN, putting material into general stock, and running QC afterwards as a report. By then the material is issuable, and in a plant that runs three shifts it will be issued.
- Received material lands in a quarantine or QC-hold location, not in issuable stock.
- Incoming QC records the actual parameters — fat, SNF, moisture, acidity, temperature, foreign matter, whatever your specs are — against the supplier lot.
- Only a pass moves it to issuable stock. A fail routes to rejection or conditional acceptance with a rate adjustment, which is also how you build a real supplier scorecard.
- The supplier lot number must survive into the production batch. Without that link, backward traceability from a customer complaint stops at your gate.
Stage 10 is the pivot: what a batch record must force
Everything upstream feeds the batch, and everything downstream — cost, yield, wastage, traceability, margin — is derived from it. So the batch close should be strict about a small number of things and fast about everything else.
01Recipe version stamped automatically
Not chosen from a dropdown at close. The version used must be the version issued against.
02Material balance forced to tie
Good output + by-product + rework + rejection + measured loss + variance = issued input. The batch cannot be marked complete until the equation closes.
03Reason codes mandatory on rejection and extra issue
Dropdown, not free text. Anything you cannot group, you cannot fix.
04By-product output with its own item code and rate
Whey, cream, residue, trim. Its value allocates back so the main product's effective cost falls.
05Cost computed at close, not at month-end
Material + conversion − by-product credit. The plant should see the batch's cost per kg the same shift.
06Under two minutes on a phone or tablet
If batch close is a ten-minute desktop form, it will be backfilled from memory at shift end and the data becomes fiction.
The formulas behind those numbers are set out in yield, wastage and by-product formulas, and the control loop that uses them is in how to reduce wastage in a food factory.
Stage 13: compliance happens at dispatch, not at month-end
In India, an invoice is not finished when it is printed. Depending on turnover and consignment value, it needs an e-invoice IRN and an e-way bill, both generated at dispatch time. Treating GST as a month-end module guarantees a reconciliation project.
- Batch allocation per invoice line. This is the only thing that makes forward traceability possible later. It costs nothing at dispatch and is unrecoverable afterwards.
- E-invoice IRN and QR generated from the same invoice record, not re-keyed into a portal.
- E-way bill with vehicle and distance, linked to the same dispatch.
- GSTR-1 and GSTR-3B derived from live transactions, with period locking after filing so nobody edits a filed month.
- Credit and debit notes linked to the original invoice, because unlinked notes are the most common GST reconciliation defect.
Stage 14: the loop that pays for the project
Most manufacturers justify an ERP on efficiency and are actually paid back by collections. Once every invoice carries a due date, an ageing bucket and a named follow-up owner, days-sales-outstanding falls without anyone becoming more diligent — the system simply stops forgetting.
- Receipt allocated against specific invoices, not dumped on the party ledger as an on-account balance.
- Ageing buckets (0–30, 31–60, 61–90, 90+) with an owner per customer.
- Credit limit and overdue check at sales order stage, before production is planned — the cheapest place to stop a bad sale.
- Automatic journals from every operational document, so the trial balance is live and month-end is a review rather than a reconstruction.
What the owner should actually watch, and how often, is covered in the five-minute owner dashboard.
Implementation order, and the two sequencing mistakes
- Masters first. Items, units and conversions, parties with GSTIN, warehouses and tanks, tax rates, chart of accounts. One owner, zero duplicates, signed off.
- Purchase to stock. Prove that QC-failed material cannot be issued before you build anything else.
- Recipes and BOMs for the top ten SKUs. Not all of them.
- Batch production with forced material balance. Live on those ten SKUs only.
- Sales to collection, including e-invoice and e-way bill.
- Accounting and GST reconciliation against a month you already filed manually — this is your correctness proof.
- Dashboards and alerts last.
If you have not selected a system yet, run this chain as the demo script — the scoring version is in best ERP for food manufacturing in India.
Implement the food manufacturing ERP workflow in the right order
01Clean and own the masters
Items, units and conversions, parties with GSTIN, warehouses and tanks, tax rates, chart of accounts. One named owner. No duplicates. Nothing else starts until this is signed off.
02Wire purchase to stock
Purchase order → GRN → incoming QC → put-away with lot, manufacturing and expiry dates. Prove that QC-failed material cannot be issued.
03Enter recipes and BOMs for your top SKUs
Versioned, with standard yield and expected by-product. Top ten SKUs by volume only.
04Run batch production end to end
Material issue under FEFO, batch execution, good output, by-product, rework, rejection with reason codes, forced material balance, FG QC, batch stock with expiry.
05Connect sales to collection
Enquiry → quotation → sales order → dispatch with batch allocation → GST invoice with e-invoice and e-way bill → receipt → ageing and follow-up.
06Close the accounting and GST loop
Confirm every operational document posts its own journal entries, then generate GSTR-1 and GSTR-3B from live transactions and reconcile against the returns you filed manually last month.
07Switch on dashboards and alerts
Owner dashboard, wastage and yield dashboard, stock and expiry alerts, credit-limit and overdue alerts. Only now — dashboards on incomplete data destroy trust.
Frequently asked questions
What is the correct order of stages in a food manufacturing ERP?
Enquiry, quotation, sales order, production plan, purchase order, GRN with incoming QC, lot put-away with expiry, recipe and BOM, material issue under FEFO, production batch with yield and by-product, finished-goods QC, batch stock, dispatch with GST invoice plus e-invoice and e-way bill, then collection with automatic accounting and GST returns. Each stage should inherit data from the previous one rather than being typed again.
Should incoming QC happen before or after the GRN?
Record the GRN into a quarantine or QC-hold location, then run incoming QC before put-away into issuable stock. If QC runs after material is already in general stock, a three-shift plant will issue it before the result arrives. Only a QC pass should make a lot issuable; a fail routes to rejection or conditional acceptance with a rate adjustment.
When should e-invoice and e-way bill be generated?
At dispatch, from the same invoice record that the sale is booked on — not re-keyed into a portal afterwards. The e-invoice IRN and QR belong on the invoice as it is issued, and the e-way bill needs the vehicle and distance at the same moment. Generating them later turns compliance into a reconciliation exercise and risks movement without valid documentation.
Which ERP module should be implemented first in a food factory?
Masters, then purchase-to-stock with incoming QC. Dashboards should be last. The most expensive sequencing mistake is launching dashboards on partially captured data, because it teaches the organisation that the system cannot be trusted — an impression that takes far longer to reverse than the implementation itself.
How does production connect to accounting in this workflow?
Every operational document posts its own journal entries: GRN creates the purchase and stock entries, material issue moves value into work-in-progress, batch close converts it into finished-goods value net of by-product credit, and dispatch books the sale with GST. Because the postings happen at the transaction, the trial balance stays live and month-end becomes a review rather than a reconstruction.
Can this workflow run if we still use Tally for accounts?
Yes, and that is the common transition path. Run the plant chain — purchase, QC, batch, yield, dispatch, GST-ready invoices — in the manufacturing system, and sync vouchers, masters and balances two-way with Tally so the books stay aligned. Keep one system as the source of truth per document type, and reconcile a full month against a manually filed month before switching over.
This page also answers
- What is the order-to-cash flow in a food factory?
- Where should incoming QC sit in the purchase flow?
- How should a production batch be recorded in ERP?
- When are e-invoice and e-way bill generated?
- In what order should ERP modules be implemented?
- How do you connect production to accounting and GST?
References
Run this inside one system
naffo.tech is an all-in-one business management and manufacturing platform for Indian SMEs: versioned recipes and BOMs, batch-wise material issue under FEFO, yield, by-product and reason-coded wastage capture, in-process and finished-goods QC, batch traceability to dispatch, GST invoicing with e-invoice and e-way bill, and double-entry accounting that closes live.
Related answers
ERP selection
Best ERP for food manufacturing in India: an honest shortlist and how to test it
Which ERP is best for a food manufacturing business in India?
Compliance & traceability
Batch traceability and mock recall for a dairy or food plant, in four hours
How do you set up batch traceability and run a mock recall in a food plant?
Business operations
The five-minute owner dashboard: run your business without doing everything yourself
How should a business owner manage a manufacturing business more efficiently?