Convert Quickbooks data to Great Plains

[Stapp@discussions.microsoft.com Clay Stapp]

My client has recently implemented Great Plains. They would like to convert
all Quickbooks data (history, chart of accounts, gl information) into Great
Plains. Any recommendations on tools to use?

Thanks.

C

[Eric Huebschman]

Integration Manager works but depending on what data they had in QB you most
likely will have to modify some of the data and maybe export it to excel and
add a couple more columns so that it will integrate sucessfully.

I've done a few QB to GP conversions that way.

"Clay Stapp" <Clay St...@discussions.microsoft.com> wrote in message
news:6622EA51-6D73-42D0...@microsoft.com...

[GloriaB]

We recently completed a conversion of 70,000 GL QB trx to Great Plains,
dumping all data through Excel. I had also attempted an ODBC link to QB, but
was amazed to find an overly complex set of transaction files that only a QB
developer would understand. Ultimately the "gotcha's" were that the QB dump
of data to Excel files sets up an unreliable formatting of fields. When
Integration Manager is reading a string, if that string format methodology
changes in Excel, Integration manager stops reading data.

We had account numbers that were
"301" " 301" "301 " "301." "301. " "301.0" "301.00" -- note the
misplaced spaces and zeros. Somehow QB pulled these altogether into 1 or 2
accounts, but Excel and Integration Manager read them literally. So with
only 1700 GL accounts, we ran into the Integration manager standard
limitation in the translation table of a little over 2000 translation lines.

So my suggestions are to break down the import if necessary using a clearing
account so that you can setup adequate translation tables. Verify your
import source and end results on a daily basis because that's how GP and Int
Mgr will create the journal entries most easily. We had days drop out of the
integration without error simply because the format of the date field changed
in Excel (something like 3/2/05 versus 03/02/2005 randomly). Int Mgr just
wouldn't read the data so it also didn't report that it had a problem with
the data.

I spent 20 hours that should have taken 2 hours. Maybe your client is a
little more disciplined creating their account numbers in QB. Good luck.
glo...@computeration.net

[Dawn Langlie]

Hi Clay,

Microsoft Business Solutions does provide a servicel that will migrate
Quickbooks to Great Plains.
For information on the service please email mbsp...@microsoft.com

Dawn
Microsoft Online Support Engineer - MBS Developer Support

Get Secure! - www.microsoft.com/security

=============================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=============================================
This posting is provided "AS IS" with no warranties, and confers no rights.