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 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, help@efaru.com. 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
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
