Free Articles, Free Web Content, Reprint Articles
Sunday, November 19, 2017
 
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles
 

Conversion from Great Plains to SAP Business One

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, 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 platforms
A.  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, help@efaru.com.  We have local presence in Chicagoland, Southern California, Atlanta Georgia, Southwest MichiganBusiness Management Articles, 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 Articles from ArticlesFactory.com

ABOUT THE AUTHOR


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



Health
Business
Finance
Travel
Technology
Home Repair
Computers
Marketing
Autos
Family
Entertainment
Education
Law
Communication
Other
Sports
ECommerce
Home Business
Self Help
Internet
Partners


Page loaded in 0.320 seconds