Conversion,from,Great,Plains,S computer Conversion from Great Plains to SAP Business One
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
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 CenterQ. 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 consultantsQ. 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 StudioQ. 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.0Please call us 1-866-304-3265, 1-269-605-4904, [email protected]. 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
Conversion,from,Great,Plains,S