Microsoft Great Plains ERP or new name Dynamics GP requires precise approach in implementation, user training, initial data migration and conversion, reporting, EDI and possible customization and interface modification
Microsoft Dynamics GP consultant selection is often critical to the implementing process success. In this small publication we would like to review data massage and conversion recommendations and scenarios:
1. Data Export from your legacy ERP or accounting application. There are few possibilities, and this is dependent on your legacy MRP application platform. Usually old ERP allows you to export data in tab delimited or comma delimited text file format. However cheap small business accounting packages might be lacking export tool, and if this is your case, you should export data in the form of reports. Reports could be further massaged in Excel and then you should come to the next step – Great Plains Integration Manager data import
2. GP Integration Manager. IM can read text files as well as ODBC data sources. If you are sort of giving up in using IM and thinking that it doesn’t work in your case – you should read samples of advanced ODBC data sources. Advanced ODBC allows you to create advanced SQL Select, group and other aggregated statements. On MS Windows 2003 Server as well as on Vista or Windows XP workstations Microsoft Text driver has known issues and if you think it doesn’t do the job – we recommend you to call us in order to help you with advanced ODBC driver configuration
3. Excel data massage techniques. Here you typically process your initial export text file and make needed corrections
4. Data Conversion levels. Ideally you should import GL Chart of Accounts, Master records, such as Customers, Vendors, Employees, then you import your work transactions. In some cases you need to keep restricted number of open sales invoices while you are awaiting collection or payments
5. Great Plains Historical Data Conversion. This is what we do not really recommend or at least try to avoid that. GP History conversion is really tough process. Plus you will likely going to get data integrity issues while doing future check links in GP
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
