For mid-market ERP and MRP application, such as Microsoft Dynamics GP there is relatively strong, but maybe a bit narrow customizations and modifications market, where projects are spread across the USA, Canada, Australia, UK, Mexico and Central America.
This means that having GP Dexterity developers in consulting staff is probably impractical, as it is not always possible to provide full workload and if programmed is used only on the case by case basis, then her or his software development experience maybe weaker than for the programmer working in centralized Great Plains Dexterity Software development factory. We would like to review Dexterity development projects and specialization in this small publication:
1. GP Dexterity overview. This software development environment was specially created for Great Plains Software Dynamics ERP project in earlier 1990th as the shell written in C programming language. Dex has its own scripting language Sanscript which is somewhat proprietary. When Microsoft purchased Great Plains Software, Dexterity was enriched by such instruments as COM object call procedures, direct SQL stored procedures calls, etc.
2. Dexterity customization examples. The simplest Dex customization is Dex trigger, where if something happens with one of the fields on the form, or in the scrolling window, Dex trigger automatically updates mirroring record in the custom Dex table. More sophisticated customizations create Dex custom window, which could be called from GP workstation interface and work with existing and newly created custom GP tables. Also Dex can modify existing GP windows. One of the most popular GP windows in Sales Transaction Entry screen. One of the most popular GP tables, involved in customizations are: SOP10100 – Sales Document header, SOP10200 – Sales Document Line, IN00101 – inventory item master
3. Dexterity versus eConnect. eConnect is open to Microsoft Visual Studio C#, VB developers, who are familiar with MS SQL Server stored procedures and SQL Server in general. eConnect, in essence imitates Great Plains Dexterity logic in its encrypted SQL stored procedures to do similar job as Dex, and initially it was dedicated to ecommerce web developers to integrate eCommerce web sites with GP SOP and Inventory modules. eConnect is very popular tool, it lacks sutomatic batch posting logic, where you need to deploy Alba Spectrum Posting Server
4. Great Plains Software Development Factory. This centralized facility is dedicated to GP Dex, eConnect and generic Great Plains Integration projects. This facility also includes Great Plains Remote Support call center
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
