Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrating from Quickbooks

Status
Not open for further replies.

disintegration

IS-IT--Management
Feb 24, 2005
46
Hi, we're about to migrate from Quickbooks to Great Plains. I'm curious if anybody has any advice or warnings.

Thank you!

-----
Space travel's in my blood.
 
I'm working on a QB migration myself right now.

MBS offers a service for migrating QB data to GP. It ususally works well. Be advised that they will only migrate master records, customers, vendors, etc. and only open invoices.

MBS will not migrate data from the enterprise versions QB. If you want to use integration manager you can export your master records out of QB into spreadsheets and move the data in. There is also a QB ODBC driver lurking out there that will allow you to connect into the database directly so that you can link to the tables using Access or Excel.

I hope this helps
 
My 2 cents would be to take a serious look at whether you need all the data from QB. I have had a lot of customers ask to bring their last X years of data into GP when migrating from QB, but when you really start looking at the need for it in relation to the price, it becomes evident to most people that it is not worth it.

So my advice would be to limit the data you migrate to open transactions and related master records and save some money and hassles.
 
I'm working on a QB to GP migration myself.

MBS has a service that will migrate you QB data to GP. This will only migrate master records, customers, vendors, etc. and only open invoices. No history. They will not migrate data from the Entreprise versions of QB. If you are using one of these version you can export the master records from QB to Excel and then use Integratin Manager to import the data.

There is also a QB ODBC driver out there whcih will allow you to connect directly to the QB database.
 
We were planning on keeping our Quickbooks system in place to do historical queries... and only bring over the current year's data to prepare for a 4th quarter close in Great Plains.

The ODBC driver is interesting. I'm going to research that, just in case.

I appreciate the comments, guys.






-----
Space travel's in my blood.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top