Case study · Manufacturing

ERP Case Study: Manufacturing ERP Modernization with Business Central

A mid-sized manufacturer moving from a legacy system plus spreadsheets to Microsoft Dynamics 365 Business Central, phased by function rather than cut over in one weekend.

The situation

A manufacturer was running an aging ERP alongside spreadsheets that had become the real system of record for inventory and production. Reporting was rebuilt manually each month, and inventory variance was high enough that purchasing decisions were being made on intuition.

01

Process before configuration

We mapped the actual flow from receiving through shipping with the people doing the work, and documented where data was re-entered and where it waited. Several problems turned out to be handoffs, not software.

That distinction changed the scope. Two of the issues originally described as ERP limitations were resolved by changing who entered a transaction and when, before any configuration happened.

02

Why the data cleanup came first

Item records had accumulated years of inconsistency: duplicate items, units of measure that disagreed between purchasing and production, and BOMs that reflected how a product used to be built. Migrating that as-is would have produced an ERP that was wrong faster.

Cleanup was treated as its own phase with its own sign-off, because inventory cutover is the point where bad data becomes permanent.

03

Architecture and phasing

  • Purchasing, vendors and receiving stabilized first
  • Item, unit-of-measure and BOM data cleaned before inventory cutover
  • Warehouse locations and bins designed around physical flow
  • Production orders and consumption posting introduced next
  • Dimensions structured for operational, not only accounting, reporting
  • Power BI reporting added once definitions were settled
04

The infrastructure work that made it possible

Barcode scanning on the floor only works if wireless coverage holds in the aisles and between racking, so coverage was surveyed and corrected before scanning went live. Users needed Entra ID accounts, MFA and correct licensing, and the reporting layer needed a data model rather than exports.

This is the part most ERP projects treat as somebody else's problem. Running both sides removed the handoff.

05

Result pattern

Transactions were recorded where the work happened rather than transcribed later, monthly reporting became a refresh instead of a rebuild, and inventory data became trustworthy enough to plan against.

Outcomes are described qualitatively because we do not publish customer metrics without approval.

06

What we would repeat

  • Document the current process with operators before touching configuration
  • Make data cleanup a phase with a sign-off, not a task inside cutover
  • Design warehouse setup around how material physically moves
  • Change one department's workflow at a time
  • Settle metric definitions before building dashboards
  • Fix wireless coverage before depending on scanners

Common questions

Straight answers, no sales theater.

How long does a manufacturing ERP implementation take?

Phased implementations for small and mid-sized manufacturers typically run several months rather than weeks, driven mostly by data cleanup and how many modules go live. Phasing extends the calendar but reduces the risk of a failed cutover.

Why phase an ERP rollout instead of a single cutover?

A single cutover asks every department to change on the same day, which means every problem surfaces at once and nobody has capacity to fix any of it. Phasing by function keeps the failure surface small and lets each team stabilize before the next change.

Is Business Central a realistic replacement for a legacy manufacturing ERP?

For most small and mid-sized discrete manufacturers, yes — it covers BOMs, routings, production orders, warehousing and multi-location inventory. Heavily customized legacy systems may do specific things it does not, which is a scoping question to answer before committing.

What usually causes manufacturing ERP projects to fail?

Undocumented current processes, dirty item and BOM data migrated as-is, dimensions designed only for accounting, and asking the plant to absorb too many workflow changes at once. Very few failures are caused by the software itself.

Reviewed by the Machina IT engineering team ·

Schedule an IT assessment.

We review your network, security posture, cloud tenant and recovery plan, then hand you a plain-language report of what we found and what it means for the business.