ERP Integration for Perth Construction Business
Eliminated 3 hours of daily manual data entry by building an event-driven integration hub connecting MYOB, ProjectPath, and custom inventory systems.
3hrs → 0
Daily Manual Entry
40%
Error Reduction
100%
Reconciliation Automated
The Challenge
A Perth-based construction company was running three completely disconnected business systems: MYOB for accounting, ProjectPath for project management, and a custom-built inventory system for materials tracking. Every piece of data that crossed a system boundary required manual re-entry.
Staff spent an estimated three hours per day on double and triple-entry work — copying invoice data from MYOB into ProjectPath, reconciling purchase orders between ProjectPath and inventory, and manually matching job costs at month end. The error rate was significant, with reconciliation discrepancies taking additional time to resolve.
The business had grown to the point where this overhead was actively blocking hiring and project expansion. They needed integration without replacing any of the three systems, with a clear audit trail for every data movement.
The Solution
We architected a .NET Core integration hub deployed as an Azure App Service, with Azure Service Bus providing the message backbone. Each system was assigned a dedicated adapter that translated between the system's native API/format and a canonical internal event schema.
When an invoice was created in MYOB, it published a domain event to the Service Bus. The integration hub consumed that event, validated it against business rules, and propagated the relevant data to ProjectPath — automatically matching it to the correct project by reference code. Azure Functions handled scheduled reconciliation jobs and retry logic for failed message deliveries.
A React-based admin dashboard gave the operations manager full visibility into event flow, failed messages, and reconciliation status. All data movements were logged to SQL Server with full before/after snapshots, satisfying the audit requirements. The rollout was phased system by system over 8 weeks, with the existing manual processes maintained in parallel until each integration was signed off.
Architecture Overview
Technologies Used
The Results
3hrs → 0
Daily Manual Entry
40%
Error Reduction
100%
Reconciliation Automated