Microsoft Dynamics GP, or also commonly known as Great Plains is Microsoft SQL Server database application and at the same time it has its own IDE and programming language, known as Great Plains Dexterity.
Dexterity in turn is written on C as a shell. Recent versions, such as 10.0, 9.0 are tightly integrated with Microsoft Outlook, plus version 10.0 has integration with Sharepoint and SQL Server Reporting Services (or SRS). Having said that, however we would like to inform you that installation itself is streamlined and not overly difficult. Let’s review:
1. Server Side. When installation wizard loads application files, it launches Dexterity Utilities to create DYNAMICS and then company databases. Here you should interact and enter maximum account length and number of segments. We recommend you in order to install lesson company to have at least three segments and length of the first three should be 3, 4 and 2. If you would like to know what is really going on and which objects are installed – atomic stored procedures (needed for Dexterity engine to manage tables by Dex indexes), tables: master, setup, work, open and historical, SQL stored procedures including eConnect encrypted ones
2. Workstation. Here when you add users workstations, for versions 9.0 and newer you don’t need to create ODBC connection manually – installation does it for you. If you are curious and would like to understand technical side, please review Dynamics.set file to review modules installed. Each module, listed in this set file has three lines: one for code logic dictionary, one for modified forms dictionary and one for modified reports dictionary.
3. Implementation. As GP is mid-size business ERP application, to implement it you need professional GP implementation consultant, who should help you install software, map business processes, perform data conversion and migration from legacy MRP to GP, train users, modify reports and customize the system if required
4. Integration. It is often the case, when your new ERP should be integrated with other systems and databases. In GP you should review Integration Manager module, which allows you to integrate text files as well as connect to other databases via ODBC connection
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
