Conversion from Great Plains to SAP Business One

Jul 4 07:32 2012 Andrew Karasev Print This Article

First of all we would like to mention that data conversion scope should be limited.  ‘Let’s convert everything’ is generally not a good idea.

Business One is in competition with Dynamics GP formerly known as Great Plains.  Sometimes when IT people mention ‘Great Plains’ they actually are talking about Great Plains Accounting for DOS,Guest Posting Windows (archaic Microsoft Windows which was popular in mid 1990th) and Mac.  We will try to answer popular question on migration from GP to SAP B1:

Q.  How do we export data from Great Plains Dynamics 5.0 on Btrieve?A.  You should review table structure: Tools -> Resource Description -> Tables.  Customer master file name is RM00101.  If you can find it in table reference then you should be able to find all you need.  Popular tables are SOP30200 (Sales History Header), SOP30300 (Sales History Lines), GL20000 (General Ledger Open Year Entries), IV00101 (Inventory Item Master).  Second step is to produce DDF files.  Read manual about GenDDF routine.  File.ddf, Field.ddf and Index.ddf are required in order to connect via ODBC.  Connection tools could be Microsoft Access, Excel or Pervasive SQL Control Center

Q.  We are walking away from old Great Plains and we believe that it is DOS version 9.2.  How do we export data from there?A.  We recommend you to read ODBC manual available on 9.2 installation CD.  You need DDF files as GPA DOS is Btrieve based application.  In our opinion the most effective tool is Pervasive SQL 2000 Control Center.  The complexity is in exporting Historical Sales and Purchase Orders.  If you try to connect via MS Access then data will be shifted (mismatching columns).  You will need to produce limited to required fields SQL Select statement in Control Center.  In most of the cases GPA data export is outsourced to professional consultants

Q.  We are currently on Microsoft Small Business Financials and looking migrate our data to SAP B1.  Could you give us recommendations?A.  SBF is scaled down version of Dynamics GP.  Table structure is described in Tools -> Resource Description -> Tables.  Data is hosted in MSDE or MS SQL Server 2000 or 2005.  So data export tool is SQL Server Query Analyzer or MS SQL Server Management Studio

Q.  We were approached by SAP BO consulting firm.  We are on GPA DOS 9.5 and they indicated that the only option for us is to do data migration to Business One 9.0.  We are open to competing ERP platformsA.  You can upgrade your Great Plains Accounting all the way to Dynamics GP 2010.  This way should allow you to preserve all you historical tables and documents.  SB1 is also good way to go but it may require data conversion.  We recently did update to GP 10.0.  There are two steps.  First one is from Great Plains 9.5 to Dynamics GP 8.0.  Here you need to apply service pack.  And then it is directly to 10.0

Please call us 1-866-304-3265, 1-269-605-4904,  We have local presence in Chicagoland, Southern California, Atlanta Georgia, Southwest Michigan, Houston and Dallas areas of Texas. We serve customers USA and Canada nationwide and internationally via web sessions and phone conferences (Skype is welcomed).  We are working on Brazilian ERP consulting market in Sao Paulo since 2004

Source: Free Guest Posting Articles from

About Article Author

Andrew Karasev
Andrew Karasev

Andrew Karasev is SAP BO consultant and Great Plains Certified Master, MVP, 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project and founder of Alba Spectrum information space

View More Articles