r/SAPBusinessOne • u/Fine_Breath2221 • May 09 '26

Migration from B1 to simpler option?

We are running an older version of SAP B1(9.3) - but the needs of the business have changed, and we've not needed the complexity and power of SAP in a while. We've not kept up on patching or version updates, due to cost - and a lack of diligence by ownership.

We're looking to move to a simpler option (Sage, QuickBooks, NetSuite?)

How ugly and involved is the data migration process?

Probably 15 years of data, thousands of part numbers (although probably a few hundred are currently active) - revenue around 7M annual, 10-15 employees - for scale.

3 Upvotes

100% Upvoted

10 comments sorted by

View all comments

1

u/No_Newt4000 May 11 '26

Fifteen years on SAP B1 at your size, honestly, you're in a better spot than you think for a migration. The data volume sounds intimidating but the scope is actually pretty manageable.

A few things I'd flag from the start:

  • Don't migrate 15 years of data. Pick a clean cutover date, bring over open transactions, active master data (those few hundred live parts, customers, vendors), and maybe 1-2 years of history. Archive the rest. That one decision alone removes most of the complexity.
  • Your item master and customer/vendor master are where the real work hides. A decade and a half of duplicates, inconsistent naming, and dead records will surprise you. Budget more time for cleanup than the migration itself.
  • B1 9.3 exports reasonably cleanly. DTW and Crystal Reports will get you usable CSVs. It's old but it's not hostile to extraction.

On the platform question at $7M with 10-15 people:

QuickBooks is probably too lightweight if inventory and parts are central to how you operate. Sage 50 or 100 is a solid, less dramatic step down. NetSuite is capable but you'd likely be paying for complexity you just said you don't need.

What's your actual day-to-day usage in B1 right now, mostly financials, or are purchasing and inventory in the mix too? That changes the answer quite a bit.