Mining & Resources Operator — BC + MEX Integration

Home Success Stories Mining & Resources Operator — BC + MEX Integration

Customer Background

The client is a Mining & Resources company operating across Finance, Procurement, Inventory, Fixed Assets, and Maintenance. To improve efficiency and integration, they undertook a 6-month system implementation with a focused team of four members.

Industry

Mining & Resources, Full Finance, Procurement, Inventory, Fixed Assets and Maintenance Integration, 6-month implementation, 4-person team

The Challenge

The client operated a large-scale open-cut mining operation with a fleet of heavy equipment including haul trucks, excavators, dozers, and processing plant machinery—all managed through MEX, an industry-standard maintenance management system.

Finance and procurement teams relied on disconnected spreadsheets and a legacy accounting system with no integration to maintenance workflows, causing delays in purchase requisition processing, duplicate data entry across systems, and lack of real-time visibility into maintenance-driven expenditure.

Equipment downtime directly impacted ore extraction volumes, making fast and accurate procurement of spare parts and maintenance consumables critical to profitability. Data integrity was a major concern—historical data from the legacy system needed to be migrated accurately, and the client required evidence-based sign-off on every data entity before going live.

Our Approach

  • We followed a structured implementation methodology beginning with a detailed discovery phase to map existing maintenance-to-finance workflows, procurement approval hierarchies, and reporting requirements.
  • A key focus was the integration architecture between MEX and Business Central. We designed a bidirectional integration layer using MEX’s OData API and Business Central’s REST API, with a middleware component handling data transformation, error management, and logging.
  • Data migration was executed using a rigorous 8-step methodology with formal sign-off gates at each stage, including row-count reconciliation, field-level spot checks, and Trial Balance verification.

Solution Delivered

  • Finance & Accounting: General Ledger, Chart of Accounts, and Financial Dimensions configured for multi-cost-centre reporting aligned to mine sites and equipment categories. Accounts Payable with 3-way matching (PO → Receipt → Invoice), payment proposal automation, and vendor approval workflows. Accounts Receivable for ore sales revenue with automated aging and dunning. Fixed Assets register with depreciation schedules aligned to mining equipment lifecycle.
  • Procurement & Inventory: Purchase Requisitions originating from MEX work orders, automatically creating Purchase Orders in Business Central. Item Master synchronization between MEX and BC ensuring consistent part numbers, descriptions, and costing. Inventory management with location-level tracking across main warehouse, workshop stores, and field locations.
  • MEX Integration: Bidirectional sync of Customer, Vendor, and Item master data. Automated Purchase Requisition → Purchase Order → Purchase Invoice flow from maintenance work orders. Financial postings flowing back to MEX for cost visibility against assets and work orders. Error handling with retry mechanisms, logging dashboard, and exception alerting.
  • Go-Live: Post-migration Data Verification sessions with entity-by-entity reconciliation against source files. Configuration Delta Checklist comparing all UAT setup changes against Production environment. Zero Tolerance Policy for go-live gates ensuring no unresolved critical issues at cutover.

Key Outcomes

  • Procurement cycle time reduced by approximately 80%—from days to hours for maintenance-driven purchases.
  • Duplicate data entry across finance and maintenance systems fully eliminated.
  • 100% data migration reconciliation sign-off across all master and transactional data entities.
  • Go-live achieved on schedule with zero critical defects in production.
  • Full audit traceability from maintenance work order through to financial posting.

Technology Stack

Microsoft Dynamics 365 Business Central (SaaS), MEX Maintenance Management, MEX OData API, BC REST API, Custom Middleware (Azure-hosted), Power BI for maintenance cost dashboards.

Use when

Prospect operates heavy equipment or assets with a separate maintenance system. Integration between ERP and operational systems is the key pain.

Free Assessment
Let's figure out if Business Central is the right move
Tell us where you are today. We'll tell you honestly whether BC makes sense and what the path looks like. No pitch deck. No automated follow ups. Just a straight conversation.

Client Testimonial

quote
Sigma Solve Inc. has been the go-to company for our IT consulting projects. They have consistently delivered enterprise software solutions exceeding our clients' expectations while working within tight schedules and budgets. I highly recommend them.

Jeff Hillier

Affordable projects are completed on time as promised, always! Friendly, excellent communication. They have the best Project Manager and technology strategists. I have worked with Sigma Solve Inc. on many projects for years, and they never failed me. I will continue to work with them.

Andy Narendra

Sigma Solve Inc. is the best web development company I have ever worked with. They are highly responsive, and what is equally important is they care very much about the quality of their work. I highly recommend them.

Tim Krejdovsky