Inventory and ERP tools vs formulation software: don't rebuild formulation on your ERP

A common instinct when a supplement business outgrows spreadsheets is to push the formula into the system it already has — the inventory tool or the ERP. After all, the ERP already tracks ingredients and production, so why not make it handle the formula too? It sounds efficient. In practice, it is one of the most expensive and frustrating paths a manufacturer can take. Here is why, and what to do instead.

Inventory tools hit a wall fast

Lightweight inventory and order-management tools are excellent at what they do — stock levels, lots, expiry dates, fulfilment. But they are not built for the regulated detail of a formula. As soon as you have complex formulations, multi-level recipes, or real compliance needs, these tools hit a ceiling: they track quantities, not elemental content, permitted forms, or compliant panels. Manufacturers who try to run formulation on a basic inventory tool consistently find it cannot carry the load.

ERPs aren't built for the formula either

A full ERP runs operations beautifully — purchasing, production scheduling, finance, inventory. But the formula, with its elemental calculations, market-specific compliance, claims, and label generation, is outside what an ERP natively understands. An ERP knows you used a kilogram of an ingredient; it does not know that ingredient's elemental contribution, whether its form is permitted in your markets, or how to lay out a compliant Supplement Facts panel.

So to make an ERP "do formulation," you have to customize it — and that is where the real cost appears.

The cost of building it on an ERP

Customizing a major ERP platform to genuinely handle supplement formulation — elemental calculations, market-aware compliance, claims, document generation — is a serious software development project. Realistically, building this kind of capability on top of a large ERP can run from roughly €100,000 for something simple to €800,000 or more for an advanced, genuinely useful implementation.

And the upfront build is only the start. Custom ERP development typically comes with:

Bugs and fragility — bespoke modules built on a general platform are prone to defects, and the more specialised the logic, the more there is to go wrong.

Practical unusability — these custom builds are often so complex and brittle that they are painful to actually operate day to day, which defeats the purpose.

Ongoing maintenance cost — you remain dependent on expensive development partners and consultants to maintain, update, and fix the customisation, year after year. The bill never really stops.

In other words, you are paying a fortune to rebuild — imperfectly — something that already exists as dedicated software.

Don't reinvent the formula layer

The lesson is simple: do not try to reinvent formulation on top of your ERP. The specialist work — elemental content, compliance, claims, labels — has already been solved by dedicated formulation software, built and maintained for exactly this purpose. Buying it costs a fraction of building it, comes without the custom-development bugs, is designed to be usable, and is maintained for you rather than by a development partner on your dime.

They work together

The right architecture is not formulation software instead of your ERP — it is alongside it. The ERP runs operations: inventory, purchasing, production, finance. The dedicated formulation software owns the formula, the compliance, and the documents. Each does what it is best at, and you avoid the enormous cost of forcing one to do the other's job.

Where Lemoniq fits

Lemoniq is the dedicated, ready-made formulation layer — already built and maintained, so you don't spend €100k–€800k customising an ERP to approximate it. It handles elemental calculations, market-aware compliance, claims, and document generation out of the box, is designed to be usable rather than brittle, and is maintained for you. It sits alongside your inventory tool or ERP, owning the formula layer those systems were never built for.

The takeaway

Inventory tools hit a wall on complex formulations, and making an ERP do real formulation means a custom build that can cost €100k–€800k, arrive buggy, prove painful to use, and carry endless maintenance fees. Dedicated formulation software has already solved this — usable, maintained, and a fraction of the cost. Don't reinvent the formula layer on your ERP; use a tool built for it, alongside the systems you already have.

Lemoniq is the ready-made formulation layer — no €100k–€800k ERP customisation, no bugs, no endless maintenance bills, working alongside your existing systems. We solve this exact problem. See how it works