| When you need customization specification for | | | | and atomic stored procedures to read, update |
| Microsoft Dynamics GP, formerly known as Great | | | | and create new records. Obviously Dex indexes |
| Plains Dynamics and eEnterprise, one of the major | | | | are now in synch and on the top of MS SQL |
| tools in Microsoft Dexterity. In fact, historically | | | | Server indexes |
| Great Plains architecture has Dex foundation, and | | | | 3. Dexterity customization distribution. It is |
| Dexterity is in turn a shell, programmed in C | | | | distributed in so-called chunk files and chunk file is |
| programming language, as it was popular in earlier | | | | recognized on the next user logon to GP and |
| 1990th. In this small publication we would like to | | | | users gets request on new logic integration. |
| give you initial Dexterity highlights, assuming that | | | | 4. Dexterity dictionaries. Samples could be found in |
| you are not a programmer, but rather Great | | | | GP workstation directory. Simply open for editing |
| Plains support in IT department, or project | | | | Dynamics.set file and read it – you will see |
| manager, responsible for Dynamics GP system | | | | Dynamics.dic, Forms.dic and Reports.dic. Here the |
| implementation, new features addition, reporting | | | | first one is business logic metadata, second |
| and day-to-day support: | | | | contains modified forms (through so-called GP |
| 1. Dex forms and reports. Dynamics GP user | | | | Modifier) and the third contains modified reports |
| workstation application has Dexterity forms (or | | | | (through ReportWriter) – SOP Blank Invoice |
| screens), reports. If you are considering | | | | report with your custom logo is one of the most |
| customizing existing objects, such as forms and | | | | common examples |
| reports, you move them to your new Dex | | | | 5. Programming in GP Dexterity. It may sound as |
| project as alternate forms and reports. This type | | | | a good idea to learn new tools, especially if you |
| of customization creates new functionality, which | | | | are proactive software developer and coding |
| is completely in line with base GP user interface | | | | enthusiast, however Dex is not a simple tools to |
| and security realm | | | | add to your expertise. Plus, GP customization is |
| 2. Dexterity tables. Since version 8.0 Dynamics GP | | | | not something that you do every day at work. |
| is only supported on MS SQL Server platform, | | | | We recommend you outsource Dexterity coding |
| meaning that the tables are in SQL Server. | | | | and even specification to Dynamics GP Dexterity |
| However, being developed for multiplatform | | | | Source Code Authorized Partner. |
| environment, Dexterity supports its own indexes | | | | |