Solved

Anyone have experience with migrating from Dynamics GP to Quickbooks enterprise

Posted on 2012-03-21
5
2,156 Views
Last Modified: 2012-06-21
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?
0
Comment
Question by:tsaico
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 8

Accepted Solution

by:
KoiGirl earned 167 total points
ID: 37753003
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
 
LVL 11

Assisted Solution

by:stlinae
stlinae earned 167 total points
ID: 37754148
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
 
LVL 18

Assisted Solution

by:Victoria Yudin
Victoria Yudin earned 166 total points
ID: 37755020
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
 
LVL 9

Author Comment

by:tsaico
ID: 37788093
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

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crm iframe 6 107
Access to Qbooks 8 109
crm written in asp.net / c# 1 81
W-2 Hourly Consulting Rate versus 1099 Hourly Consulting Rate 5 92
Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question