GP to BC - How I Helped My Client Go from 70,000 to 1500 GL Accounts Even Before They Moved to BC

Recently, I had the pleasure of chatting with Anya Ciecierski from ERP Software Blog about a project that really highlights why I'm so passionate about GP data cleanup. In this “One Fail, One Fix” video I talked about a company that had accumulated 70,000 GL accounts over 20 years - yes, you read that right, 70,000!

Here's the thing: I see so many companies waiting until they're ready to move to Business Central before thinking about cleanup. But here's my not-so-secret secret - the best time to start cleaning up your GP data is RIGHT NOW.

Why Start Now?

Let me paint you a picture. Imagine you're moving to a new house. Would you wait until moving day to sort through 20 years of stuff in your garage? Of course not! You'd start early, sorting through what you need and what you don't, making the actual move so much smoother (and cheaper).

The same goes for your GP data. When you start early:

  • Your team can work at a comfortable pace without the pressure of a migration deadline

  • You'll save money by not paying migration consultants to clean up years of messy data

  • Your current GP system becomes easier to use right away

  • You'll have a clearer picture of what you actually need in BC

Working Together with Your Partner

Here's something I love about my role - I get to be the Swiss Army knife in your GP toolkit! I work alongside your existing Dynamics Partner, complementing their expertise with specialized data cleanup and training support. Many Partners bring me in to help their clients prepare for BC migration because they know that a well-prepared client makes for a smoother (and less expensive) migration project.

Real Talk About Cost Savings

Remember that company with 70,000 GL accounts? Think about the cost of migrating all that unnecessary data to BC. Now think about the ongoing costs of:

  • Training new staff to navigate unnecessary accounts

  • Time wasted searching through inactive vendors

  • Fixing mistakes from wrong account selections

  • Creating workarounds for messy processes

When you clean up now, you're not just saving on migration costs - you're investing in your team's daily efficiency and peace of mind.

Ready to Start Your Cleanup Journey?

Whether you're planning to move to BC next month or next year (or even if you're just thinking about it), now is the perfect time to start your cleanup journey. I've developed tools, SQL views, and processes that make this manageable and even - dare I say it - fun!

And the best part? You don't have to do it alone. I'm here to help you:

  • Analyze your current GP data

  • Create a cleanup strategy that works for your team

  • Train your staff to maintain clean data

  • Document your processes (including those secret sticky notes!)

  • Prepare for a smooth BC migration

Want to chat about your GP cleanup needs? Whether you're working with a Partner or flying solo, I'd love to help you get started. Let's turn your GP data from overwhelming to awesome!

Amber Bell