Guides / Operating gaps

Software for machine builders, where the ERP runs out.

If you build special machines, automation cells or tooling to order, your paperwork problem isn't like a production plant's. Every job is a one-off, the scope moves, and the numbers you need don't sit still long enough for a canned report. Here's where that actually breaks, and what's worth doing about it.

Engineer-to-order work has a specific problem, and it isn't that your ERP is bad. It's that ERPs were designed around repeatable production, and you don't have any. Every machine is a one-off. The scope changes after the order. The estimate was built on engineering hours nobody could pin down at quote time, and by the time you know what it really took, the machine has shipped.

An ERP is very good at clean, finished data: purchasing, payments, accounting. Where it struggles is everything upstream of that. Budgets that are still moving. Material committed but not ordered. Change orders. Approvals that depend on context rather than a fixed rule. Your work lives almost entirely in that upstream half.

What that produces, and it has a name

It produces a shadow system. A set of spreadsheets running alongside the ERP that hold the things the ERP won't: the live project budget, the change orders that haven't been formalized, the committed-but-not-ordered material, the real status of six machines in build. Everybody has one. Nobody put it in the plan.

The shadow system isn't a failure of discipline. It exists because the work genuinely doesn't fit the tool, and somebody sensible built the missing piece out of the only thing available. The trouble is what it costs you:

The four places it actually bites

What's worth doing about it

Not replacing the ERP. It's doing the job it's good at, and an ERP migration on top of an active build schedule is a year you didn't plan to spend.

What works is reading what your systems already hold and assembling the answer outside them, on a schedule, so it arrives instead of being built by hand:

Why Michigan, briefly

Worth saying because it surprised me. Michigan has just under 3,000 industrial and special machinery companies, which is close to California's count and more than Ohio, Illinois, Wisconsin or Indiana. Most of them average around twenty people. If you build machines for a living in this state, you have a great deal of company, and almost none of the software written for manufacturing was written with you in mind.

From the work
Built for project work, not production runs

The systems I've deployed do exactly this shape of job. Connectors between an ERP and the accounting system so both sides can be read together. A morning brief that assembles cash, backlog and sales overnight. A vendor PO confirmation watcher that flags only the exceptions. A quote-to-actual loop comparing quoted against programmed against actual. All in daily use at a mid-size manufacturer, on the systems it already ran.

See selected work →

Common questions

We're an automation integrator rather than a machine builder. Same thing?

Close enough that it usually is. Long-lead projects, engineering hours that are hard to quote, scope that moves after the order, and status spread across several jobs at once. The paperwork problem is the same shape whatever you call the finished thing.

Our projects run six months or more. Does that change anything?

It makes capture matter more, not less. On a long build, anything reconstructed from memory is reconstructed from a much longer time ago, and a component that was never confirmed has months to stay invisible before it becomes a crisis.

Can you help with the estimating itself?

Not with the judgment, which is yours. What I can do is take the reading, extracting and typing off whoever estimates, and get last job's actuals in front of them before they price the next one. That's usually where the improvement is anyway.

We already have a project spreadsheet that works. Why change it?

If it genuinely works and more than one person can run it, don't. The question worth asking is what happens the week that person is out, and whether the numbers in it agree with the ERP. If both answers are comfortable, you're fine.

Related reading. The reporting wall in whatever ERP you run: JobBOSS custom reports, M1 ERP reporting, Global Shop Solutions reports, Epicor Kinetic reports. And if the shadow system is a stack of spreadsheets rather than an ERP problem, start with running on QuickBooks and spreadsheets.

Contact

Building machines, and running the project on a spreadsheet?

First call's free. About 30 minutes, a straight conversation about how your operation really runs, not a demo. If there's something worth building, I'll say so; if there isn't, I'll say that too.

Email Jason See selected work →