About the client
Technoflux Engineers Private Limited delivers electrical power distribution projects in India. They supply the material, then install and commission it on site: 11 kV XLPE cable, cable jointing and termination kits, 630 kVA and 1000 kVA distribution transformers, metering cubicles, earthing and electrical installation services.
Their customers pay against the stage of the project, not the delivery. A typical cable contract releases 70% on supply of material. The remaining 30% comes in 5–10% tranches at installation, work completion, charging, commissioning and handover, and final retention. A single work order usually mixes staged material lines with one-off services that are billed in full, once.
The challenge
Standard ERPNext invoices by item quantity. Technoflux bills by project stage, and four gaps followed from that.
- One order, several payment schedules. ERPNext sets payment terms once per Sales Order. A Technoflux work order needs different schedules on different lines: staged for material, 100% for services.
- Partial billing distorts the numbers. Billing 70% of a fully delivered cable meant invoicing 70% of the quantity, which broke ERPNext's delivered and billed percentages.
- No Proforma Invoice. Customers release each milestone payment against a Proforma. ERPNext has no Proforma that stays off the books and later becomes the GST tax invoice.
- No single view of an order. Billed, unbilled and paid amounts were spread across Sales Orders, Delivery Notes, Invoices and Payment Entries.
Our approach
We kept ERPNext's own documents as the record and built a thin billing layer on top. Five design rules shaped the build:
- Never split the quantity, only the rate. Each milestone bills the full quantity at full rate × milestone %, so stock, delivered % and billed % stay correct.
- One Sales Order per payment schedule, generated automatically from the work order.
- Proformas stay off the books until they become a GST tax invoice.
- Delivery only where there is stock. Services never create a Delivery Note.
- No changes to ERPNext core. Everything lives in a separate Frappe app with fixtures, so upgrades stay safe.
What we built
- Sales Work Order. The customer's full bill of quantities in one place, grouped into sections such as Supply and Installation. On submit it creates one Sales Order per payment schedule in a single transaction, and rejects a PO number already used for that customer.
- Milestone billing engine. Each line carries a milestone-split flag. Split lines are billed once per milestone; services are billed once in full. Status and balance are tracked per item, per milestone.
- Proforma Invoice. A submittable document that applies GST but posts nothing to the ledger. It can cover several Sales Orders and converts one-to-one into a GST Sales Invoice; a second conversion is blocked.
- Order Management workspace. One screen runs the whole lifecycle: Grand Total, Total Billed, % Delivered and Balance, with tabs for Summary, Deliveries, Proformas, Sales Invoices and Payments. Raising a Proforma, converting it, recording a payment and creating Delivery Notes are all buttons on that screen.
- Configuration and custom fields on Sales Order, Sales Order Item and Sales Invoice, installed automatically with the app.
Worked example
10,000 m of 11 kV HT cable at ₹1,239/m (₹1,23,90,000) on a 70/10/5/5/5/5 schedule. Every Proforma carries the full 10,000 m; only the rate changes.
| Milestone | Share | Billed rate (₹/m) | Proforma value (₹) |
|---|---|---|---|
| Supply of material | 70% | 867.30 | 86,73,000 |
| Installation | 10% | 123.90 | 12,39,000 |
| Work completion report | 5% | 61.95 | 6,19,500 |
| Charging | 5% | 61.95 | 6,19,500 |
| Commissioning and handover | 5% | 61.95 | 6,19,500 |
| Final retention | 5% | 61.95 | 6,19,500 |
| Total | 100% | 1,239.00 | 1,23,90,000 |
Outcomes
Technoflux now runs project billing inside ERPNext, from work order to payment received.
- Entered once. The bill of quantities is keyed in once; Sales Orders for each schedule are created automatically.
- Milestone demands from the order. A Proforma is pre-filled at the milestone rate and full quantity.
- Numbers that stay true. Quantities are never split, so delivered %, billed % and stock match the site.
- A complete GST trail. Each tax invoice traces back to its Proforma, Sales Order and Work Order; e-Way Bills come from the standard India Compliance setup.
- One view of every order. Billed, unbilled, delivered and outstanding amounts sit on one dashboard.
- Upgrade-safe. ERPNext core is untouched.
Technology stack
Frappe Framework v15 and ERPNext v15 (Selling, Buying, Stock, Accounts, Projects), Frappe HR v15, India Compliance v15 for GST and e-Way Bill, and a custom Technoflux app with its own DocTypes and a JavaScript workspace.