Hexagon EAM → Dynamics 365 Business Central Integration

A large utilities operator was running two critical systems in parallel. Hexagon EAM (formerly Infor EAM) handled all plant-floor maintenance work: asset hierarchies, work orders, preventive maintenance schedules, and spare-parts consumption at the warehouse level. Meanwhile, Microsoft Dynamics 365 Business Central was the corporate financial system of record, owning the general ledger, vendors, purchase orders, and inventory valuations.

These two systems were not talking to each other. Every maintenance transaction that had a financial impact, work order issues, stock receipts, returns, purchase requisitions, was being manually re-keyed by finance staff based on printed reports and spreadsheets from the plant. The result:

• Material balances in EAM and BC were drifting apart, sometimes by weeks.
• Monthly close was taking 5+ extra days because of reconciliation work.
• Procurement decisions were being made on stale data, leading to over-ordering.
• Two full-time finance clerks spent most of their week on data entry instead of analysis.

I designed and built a bi-directional integration layer that synchronises inventory, procurement, and vendor data between Hexagon EAM and Dynamics 365 Business Central in real time, with full audit trails and controlled failure handling.