Case Study
One warehouse across multiple ERP systems
Several ERP systems, each with its own version of customers, items and orders. We built one data warehouse in Microsoft Fabric that every system feeds, so reporting runs off one set of numbers.
One
Source of truth for reporting
Every ERP
Feeds the same warehouse
No
Hand-built consolidation spreadsheets
The challenge
- Each ERP reported its own numbers, and consolidating them was manual work every month.
- Customers, items and vendors were keyed differently in each system.
- Leadership questions needed someone to pull from several systems and reconcile by hand.
What we did
- Mapped the entities each ERP shares and agreed one definition for each.
- Built pipelines from every ERP into a Fabric lakehouse, with the mapping applied on the way in.
- Put reporting on the warehouse instead of on the individual ERPs.
- Scheduled and monitored the loads so a failed pull surfaces instead of going unnoticed.
More case studies
Thought leadership
Why your month-end report disagrees with the floor
Four common places a manufacturing close drifts from what the shop actually produced, and how to tell which one you have.
Map the process before you automate it
Automating a workaround just makes it permanent. A short argument for documentation first.
Customizations that survive an upgrade
The difference between a change that costs you once and one that costs you every release.
Made2Manage BOM and costing reports
Costed and exploded BOMs, a cost estimating system we built for quoting, and part availability across on hand, committed and on order.
Made2Manage tools we built
Communication Center, Workflow Management and Sales Order Import: three products we built to fill gaps in Made2Manage.
Made2Manage production reports
Four reports we built to show what the floor is building, where it is scheduled, who worked on it, and how the plant is performing.
Made2Manage quality reports
Two reports we built: one finds everywhere else a defect could be, the other shows which vendors deliver when they promised.
Made2Manage sales reports
Backlog, net bookings, commission liability and gross margin by order, including a bookings system we built for ERPs that cannot track bookings on their own.
Skills, tools, and your ERP: where AI should actually touch the data
AI gets useful in a shop when it is given the right things in the right order: written know-how first, live data through controlled tools second, and the power to change anything last.