You've seen the demos. AI-powered demand forecasting. Inventory optimization that predicts what customers need before they call. Then you get back to your desk, where you're running on a Dynamics GP instance with fifteen years of customizations, bolt-on integrations that break whenever someone updates a field, and a finance team that still reconciles in Excel because they don't fully trust the system.
If AI feels like it's for somebody else's company right now, you're not behind. You're at the actual starting line, and that's the right place to start. A 2026 study from Cloudera and Harvard Business Review found only 7% of enterprises say their data is completely ready for AI. If you're running distribution on GP, NAV, AX, or a heavily customized Business Central environment, that number probably feels about right. You don't need an AI strategy yet. You need a data foundation. AI is what you get to do later.
We're covering the practical steps in our webinar, Are We Prepared? A Straight Talk on Supportability and Data Readiness. Here's the starting point.
You Don't Have an AI Problem. You Have a Data Problem.
The pattern we see across distribution companies on older Microsoft platforms is consistent: the system works. Orders flow, invoices generate, inventory moves. But underneath, the data has drifted. A customer classification field that meant one thing in 2015 means something different after the reorg. Custom tables hold your actual freight cost allocations but no integration can reach them cleanly. Historical transactions sit in formats no analytics tool can parse without serious cleanup.
52% of organizations cite data quality and availability as their single biggest barrier to AI adoption. AI built on inconsistent data gives you inconsistent answers. If your team still reconciles in spreadsheets because the ERP numbers don't quite add up, that's the signal. The blocker isn't your technology budget. It's what's already inside the technology you have.
Right Now, Your Business Runs on People, Not the System
Most distributors we meet have made the old system work through sheer know-how. One or two people remember why the freight field behaves the way it does, which report you can trust, and which workaround keeps month-end moving. That knowledge is real, and it's valuable. It's also living in someone's head instead of in your data.
That's the quiet cost of staying put. Not that the system fails tomorrow, but that everything depends on the people who remember how it's held together. Getting your data into shape is how you move that knowledge out of the workarounds and into something the whole team can use.
What Happens to My Old Data When I Switch ERP Systems?
This question comes up in almost every distribution engagement we run: how much transaction history can I bring? Can I get all of it into the new system? What about data that doesn't migrate, do I lose ten years of business history?
Most migrations bring over open documents and starting balances. Importing years of old invoices into a live Dynamics 365 environment can distort your inventory levels and GL because those transactions weren't meant to exist in a new ledger. But that doesn't mean the data disappears. It means it needs somewhere better to live.
Not Every ERP Vendor Treats Your Data the Same Way
We recently worked with a distribution customer migrating off NetSuite who was given 48 hours to export their data. Forty-eight hours to pull years of transactions, reporting history, and operational records. That was the timeline they were handed, and it's the kind of situation that makes you think carefully about where your data lives.
Microsoft doesn't work that way. Your data is your own. If you ever move off a Microsoft product, your data leaves with you, on your timeline, and under your control. When you're choosing where your business data lives for the next decade, that difference in philosophy matters more than most feature comparisons.
The Data Lake: Where Your History Lives and Your AI Future Starts
The answer isn't cramming decades of legacy data into a new ERP. It's giving that data somewhere better to live — a data lake built on the Microsoft platform that brings your legacy ERP records, your spreadsheets, and your bolt-on system data together in one place.
Your controller needs cost trends from the old GP system for a vendor negotiation? They're there. An auditor asks for three-year AP history from before the migration? That's there too. Historical data doesn't disappear and doesn't have to squeeze into Dynamics 365. It becomes accessible for today's reporting and whatever AI capabilities you build toward tomorrow.
We've built this path for distribution companies. The specifics of how we get it working is what we walk through in our webinar: Are We Prepared.
What Clean Data Actually Buys You First
Long before AI enters the picture, consolidated data changes the everyday work. Your warehouse manager opens Power BI and checks stock across all three locations and your 3PL in one view, instead of guessing where product actually sits. Your controller compares margin by product line in the same dashboard where she tracks AP aging. On distribution's thin margins, knowing your real cost to serve isn't a nice-to-have, and you can't get there until the underlying data is trustworthy.
This is planned access, not a free-for-all. You still control who sees what. The difference is that "running a report" stops being a ticket to IT and a three-day wait, and starts being a five-minute task.
Getting Ready Before the Go-Live
Data readiness isn't a phase that starts when the ERP project kicks off. It's something you can work on now. Audit your data sources. Identify what needs to be cleaned versus archived versus migrated. Start thinking about which fields matter, which integrations are fragile, and where the gaps live.
The goal is data that any tool can use without dependence on a single vendor's proprietary format for today's reporting and tomorrow's AI.
Western Computer has spent 39+ years helping distribution companies figure out what to keep, what to clean, and how to build a data foundation they won't outgrow. More than 1,750 implementations, and the data conversation comes up in nearly every one. If you're weighing a move to Dynamics 365 and wondering what to do with everything you've accumulated, watch now
Are We Prepared? A Straight Talk on Supportability and Data Readiness →
