Data Conversion phase should be taken seriously as it is one of the most popular reasons for Corporate ERP implementation project to fail.
It is recommended to do testing and final data import into Business One in Data Transfer Workbench where you first have to work out CSV templates population process in Excel. This is not really a challenge except probably manual data massage in Excel with numerous templates. Today we would like to talk about exporting data from Microsoft Dynamics GP, Small Business Financial, Great Plains Dynamics and its predecessor DOS version of Great Plains. Let’s begin with the most difficult one:
1. Great Plains Accounting for DOS, Windows and Mac versions 9.5, 9.2 and earlier. Consider two methods. First one is printing GPA reports into text file and the cleansing and filtering data rows in custom MS SQL Table. This method doesn’t look like a piece of cake but it is abstracting you from such painstaking actions as creating ODBC connection, preparing DDF files and then cleansing records again in Pervasive SQL Control Center. And the second method is what we just mentioned in the second half of the previous sentence. Plus there is additional complication as GPA was hosting several Btrieve tables in the same DAT file and this is why you may see records in SQL Select statement results with unreadable characters. If you are still negotiating with SAP Business One Reseller it might be better idea just to pay for Dynamics GP software licenses and upgrade all the way through to current version of Microsoft Dynamics GP
2. Great Plains Dynamics on Pervasive SQL Server 2000. These are versions 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and earlier. Consider ODBC connection to Btrieve database which requires Data Definition Files. However they are not really difficult to produce via GenDDF routine. File.ddf, Field.ddf and Index.ddf files then should be copied into company folder on the server. Company folder is typically located in Dynamics folder. The good news is the fact that Great Plains Dynamics didn’t share the same Btrieve file to host several tables. You can pump out table rows either in Pervasive SQL Control Center or in ODBC compliant tools such as Microsoft Access. If you are not planning massive historical data export, cleaning and migration project we would recommend you to consider alternative export by creating custom report in GP ReportWriter where you are just exporting data from one table at the time. Table structure could be researched via client interface: Tools -> Resource Description -> Tables
3. Dynamics GP on MS SQL Server platform where earlier versions were known as GP eEnterprise and Dynamics C/S+. According to our experience exporting records from MS SQL Server is not something that you cannot do on your own. To research table structure please read previous paragraph
4. Small Business Financials 7.0, 8.0, 9.0. This was a scaled down version of Dynamics GP. It was in time also recommended for walking away from GPA for DOS. Code base is Dynamics.dic dictionary and it is Dexterity coded application. Table structure is similar to traditional Great Plains Dynamics
5. Please call us 1-866-304-3265, 1-269-605-4904 (for international customers, where our representatives pick up the phone in Naperville, IL and St. Joseph, MI call centers). help@efaru.com. We have local presence in Atlanta, Chicago, Southern California, South West Michigan, Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico and Brazil nationwide and internationally via web sessions and phone conferences (Skype is welcomed). Our consultants speak English, Spanish, Portuguese, Russian and Chinese. One of our experiences is international Corporate ERP and Consolidated Financial reporting
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
