Anyone have experience with migrating from Dynamics GP to Quickbooks enterprise

I have a new client that tried out Dynamics GP and it has turned out horrible for them.  They pretty much fired everyone associated with the project, and now the owner wants to go back to Quickbooks.  The accountant that was hired wants to move to QB enterprise.  I am tasked with finding how to migrate the historical data to the new instance of QB.  

I found a couple of posts on the Intuit community asking about this, and both of them reference a company that does data conversions, but it seems a little "spammish" and a shameless plug.

http://community.intuit.com/posts/great-plains-to-quickbooks-please

Anyone have any idea on the best way to do this?
LVL 9
tsaicoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Annaliese DellSec-TreasCommented:
Hello.

I use QODBC to write data to QuickBooks from Microsoft Access. QODBC also works with QuickBooks Enterprise. It uses SQL and Pass-Through queries. If you can export the data from Dynamics GP to Microsoft Access, this may be a good solution for you.

You can find examples on my blog: VBQuick.com. I just finished a short tutorial on migrating trasactions that should give you an idea of how it works.

Best of luck! Let us know what your solution turned out to be.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
stlinaeCommented:
It comes down to one thing, what can you get out of GreatPlain with reports or exporting? Importing into QuickBooks is something a lot of people can do, so I wouldn't worry about that part, yet. If you can get the data out, then find either a Certified ProAdvisor that know ES or, as Simon suggested in the post, an ISP that can help. If QBES was just bought, Intuit may do the conversion, no history, for you.

I use to work on the QuickStart, Data Conversion team for Intuit, and GP was one of the conversions that did not include history because it data couldn't be exported out of GP. As Simon says in the link you posted, they can include historical summary's but no detail. (And to be fair, I was involved in that post)

I agree the site for the company given in the last post seems a bit fishy, I never like it when people who post answers don't fill out any profile information. Makes me question their intent, but that's just me.
0
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Any data that is in GP can be exported out.  However, sometimes it gets a little tricky, as there are a LOT of tables and if you do not know the system well, it's not always obvious where to find what you need.  I have a blog that can help with the common tables for the major modules and has a bunch of SQL code posted that may help with this: http://victoriayudin.com/.  You may also be able to get most (or possibly all) of what you need out of SmartLists in GP without having to do anything in SQL.  It will come down to what data you need and how you need it formatted.
0
tsaicoAuthor Commented:
Well, we ended up moving forward with a Intuit recommended consultant firm for this purpose.  They are based in Washington and their website looks just as "Spammy" as the other one, http://www.accountingsoftwaresecrets.com/, but they were referred directly from Intuit, so who knows?  

I will look into the other suggestions and posts as well as the blog and see if I can learn some other tips before we actually kick off the project.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.