Skip to content

Industries · Manufacturing

When production status lives in spreadsheets

TechNewWings connects sales orders, bills of materials, purchasing, stock, production and GST invoicing in one ERP for manufacturers outgrowing Tally and Excel. We start with an audit of how orders actually move, then roll out inventory and order visibility first, with production, costing and automation added in phases.

Common operational problems

  • •Nobody can say where a customer order sits without calling the shop floor
  • •Stock in Tally, Excel and the store register never agree at month end
  • •Raw material shortages surface only after a work order has started
  • •Bills of materials live in one person's spreadsheet and change without version control
  • •Purchase orders, GRNs and supplier invoices are retyped two or three times
  • •Delivery dates are promised without checking capacity or material availability
  • •Costing and margin per product are estimated, not calculated

Example workflow

Order to plan

Sales orders and dealer enquiries land in one system that checks stock and BOM requirements before a delivery date is confirmed.

Purchase & receive

Shortages raise purchase requests, approved POs go to suppliers, and GRNs update stock without retyping into Tally.

Produce & track

Work orders move through defined stages, with material issue, output and rejections recorded where the work happens.

Dispatch, invoice & report

Delivery notes, GST invoices and e-way bills come from the same record, and dashboards show orders, stock and margins without manual consolidation.

What we can connect

  • → ERP (ERPNext, Odoo or custom) for inventory, BOM, production and purchasing
  • → Accounting and GST compliance, synced with or replacing Tally
  • → B2B CRM for dealer, distributor and project enquiries
  • → Dealer or customer portal for order placement and status
  • → WhatsApp Business API for order and dispatch updates
  • → AI document extraction for supplier invoices and POs
  • → Management dashboards across plants and warehouses

Technology opportunities

  • → Reorder alerts when raw material falls below a set level
  • → Material shortage check before a work order is released
  • → Dispatch and delivery updates to customers on WhatsApp or email
  • → Supplier invoice and PO extraction into draft entries for human approval
  • → Daily exception digest for delayed work orders and overdue POs
  • → Quote and proforma generation from price lists and BOM costs

Most growing manufacturers are not short of software. They have Tally for accounts, Excel for stock and production plans, WhatsApp groups for the shop floor and email for suppliers. The problem is that none of these agree with each other, so every delivery date, reorder decision and margin estimate depends on someone reconciling them by hand.

When does a manufacturer need ERP instead of Tally and Excel?

You need an ERP when answering “can we deliver this order by Friday?” requires checking more than one file or calling more than one person. Tally is strong for accounting and GST, and Excel is flexible, but neither tracks bills of materials, work-in-progress and stock reservations together. An ERP gives one live record from order to invoice.

Common signs we look for during an audit:

  • Stock figures differ between the store register, Excel and Tally.
  • The same purchase order or invoice is typed into two or more places.
  • Production planning depends on one person’s spreadsheet.
  • Month-end reports take days of consolidation.

If several of these are true, read our guide on moving from Excel to ERP before choosing a vendor.

What should a manufacturing ERP actually own?

A manufacturing ERP should own anything that more than one team reads or changes: items, bills of materials, stock, purchase orders, work orders and invoices. Accounting can stay in Tally if your accountant prefers it, provided the ERP pushes vouchers automatically. The goal is one source of truth per record, not one tool for everything.

System What it owns Typical integrations
ERP (ERPNext, Odoo or custom) Item master, BOM, stock, purchasing, work orders, dispatch Tally, GST e-invoice and e-way bill portals, barcode scanners
Accounting Ledgers, GST returns, payments ERP voucher sync, bank statements
B2B CRM Dealer and project enquiries, quotes, follow-ups ERP sales orders, website forms, WhatsApp
Dealer or customer portal Order placement, order status, invoices ERP orders and dispatch records
WhatsApp Business API Order confirmations, dispatch updates ERP, CRM
Dashboards Orders, stock, delays, margins ERP, accounting

Where off-the-shelf modules fit your process, we configure them. Where they do not, for example job-work cycles or made-to-order fabrication, we build the missing pieces through custom software development rather than forcing your team into a workaround.

How do you roll out ERP without stopping production?

You roll it out in phases, each one live and trusted before the next begins. Inventory and orders come first because every later module depends on accurate stock. Production tracking comes after, once item masters and BOMs are clean. Running a phase in parallel with the old spreadsheet for a short period catches gaps before anyone depends on the new system.

A typical phased rollout:

  1. Audit. Map how an order moves from enquiry to dispatch, who touches it and where data is retyped.
  2. Foundation. Clean item masters, units, BOMs and opening stock. Set up GST and Tally sync.
  3. Orders and inventory. Sales orders, stock movements, warehouses and basic reports.
  4. Purchasing. Purchase requests, approvals, POs and GRNs linked to stock.
  5. Production. Work orders, material issue, output, rejections and stage tracking.
  6. Costing and dashboards. Actual cost per product, margin reports and plant-level views.
  7. Automation. Alerts, document extraction and customer updates on top of trusted data.

Cost depends on scope and how much is configured versus built. Our article on custom ERP cost in India explains the main drivers.

Where does automation help on the shop floor and in the office?

Automation helps most where people currently copy data or chase status. Reading supplier invoices into draft purchase entries, alerting buyers when stock drops below reorder level, and sending customers dispatch updates on WhatsApp are reliable first steps. A person approves anything involving payments, stock write-offs or delivery commitments.

We apply AI automation only after the ERP holds clean data. Automating on top of inconsistent stock figures only spreads the errors faster.

Can one system work across plants, warehouses and countries?

Yes. A well-structured ERP treats each plant or warehouse as its own location with separate stock and work orders, while management sees consolidated reports. For groups operating in India and the UAE, the same system can hold separate companies with their own tax settings, GST in India and VAT in the GCC, under one login.

We are based in Kakkanad, Kochi, and work remotely with teams across Kerala, the rest of India and the Gulf. If you want to see where your current setup stands, start with an audit.

FAQ

When does a small manufacturer need an ERP instead of Tally?▾

Tally handles accounting and GST well, but it was not built to plan production, track work-in-progress or manage bills of materials. Once you run more than a few products with shared raw materials, or customers ask for delivery dates you cannot confirm quickly, a manufacturing ERP pays for itself in fewer stock-outs and less retyping. Many teams keep Tally for books and sync the ERP to it.

Should we choose ERPNext, Odoo or a custom ERP?▾

ERPNext and Odoo both cover inventory, BOM, production and purchasing out of the box and suit most discrete manufacturers. A custom build makes sense when your process is unusual, such as job-work, made-to-order fabrication or complex batch tracking, and off-the-shelf modules would need heavy modification. We recommend after an audit of your actual order-to-dispatch flow, not before.

Do we have to implement everything at once?▾

No. A phased rollout is safer. Most manufacturers start with item masters, stock and sales orders so everyone trusts the inventory numbers. Purchasing and GRNs follow, then work orders and production tracking, then costing and dashboards. Each phase goes live and stabilises before the next begins, which keeps the shop floor working while the system grows.

Can the ERP connect with our existing machines or shop-floor tools?▾

Often, yes. Where a machine or tool exposes an API, a database or scheduled file exports, we can bring counts, status or quality data into the ERP. Where it does not, a simple tablet or mobile entry screen at each stage usually gives better visibility than spreadsheets. We check integration feasibility during the audit so there are no surprises later.

Where does AI automation help a manufacturer first?▾

The safest starting points are repetitive document work and alerts: reading supplier invoices and purchase orders into draft entries, flagging delayed work orders, and sending dispatch updates. A person still approves anything that touches payments, stock adjustments or customer commitments. We avoid automating decisions until the underlying data in the ERP is clean and trusted.

Have you implemented ERP for manufacturers before?▾

Not yet as a published manufacturing case study. Our ERP, CRM and automation work for other sectors is listed on our work page. For a manufacturer, we start with a free Business Technology Audit, mapping your order, purchase and production flow, so you can judge our understanding before committing to a build.

Let's build the technology behind your manufacturing business.

Start with a free Business Technology Audit or explore automation opportunities.