Microsoft Dynamics GP, current version 10.0 as of June 2008 is pretty flexible platform if you are looking for modifications, custom modules programming, add-ons and extensions.
As many mid-size ERP GP has multiple customizing tools and you have to get some excurse into each one of them to select the best in your situation. Before rushing into modifications overview, please think through the fact, that GP is owned and supported by Microsoft Dynamics subdivision (former Microsoft Business Solutions) and as such you should expect it to be tightly linked with such Microsoft technologies as .Net, MS SQL Server, MS Office, Sharepoint, SRS (or SQL Server Reporting Services). Plus, you should know the history of GP design – it was originally designed by Great Plains Software in earlier 1990th with popular shell IDE and programming language approach: Great Plains Dexterity (compare to SAP ABAP or Navision C/Side – shells were believed to resolve computer platform dependence). Now is the time to review:
1. Microsoft Dexterity. As we already mentioned this IDE was written in C programming language and so it is theoretically portable to any computer platform, however in practice Great Plains tried it one or couple of times (to translate Dexterity from Watcom C to Microsoft Visual C) 1998. Dexterity is virtually all-mighty in GP customization and programming, however it is not really simple language and tool to learn, if you do not have previous experience. We recommend Dex programming if your customization needs to be tightly integrated with GP interface and security realm. If this is not a concern, and what you are designing is rather integration with third database or product, then consider eConnect
2. eConnect. This is SDK with encrypted stored procedures and it has exposure to various development tools: SQL developer (obviously can call stored procs directly), MS Visual Studio C# or VB – you should do your pleasant research as programmer
3. VBA. This customization option typically comes together with Modifier Module. In essence Modifier exposes GP screens as old-good-days OLE server. Modifier uses Dex forms, however it is not obvious to VBA developer, until he or she has to refer to GP objects descriptions: tables, forms, variables
4. SQL Stored Procedures. Theoretically SQL can do everything on the database level (obviously it is lacking user interface, comparing to GP fat client or Dexterity). If your objective is just integration routine, then, please review first GP Integration Manager and you do not find relevant functionality there (which is very unlikely event), go down to SQL scripting
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
