Dynamics GP Development Tools
Dexterity is the development tool used to create Microsoft Dynamics GP Application. It can be utilized by software developers to create both user interface and database integrations. The most highly-integrated products are created with Dexterity.
Note: Extensions developed using Dexterity are supported on both GP Standard (Desktop) and Web Clients.
Extender is a customization tool that can be used to modify Microsoft Dynamics GP without requiring the developer to write code. It allows you to "extend" Microsoft Dynamics GP by adding data entry windows that work alongside the GP windows already in the system.
Note: Forms developed using Extender are supported on both GP Standard (Desktop) and Web Clients.
Visual Studio Tools
Visual Studio Tools for Microsoft Dynamics GP is a development SDK that allows developers to add custom windows to Microsoft Dynamics GP. It provides three main capabilities:
Custom Windows Forms: Developers can add .NET Windows Form that can be accessed via menu options & shortcuts inside Dynamics GP. The appearance of the WinForms matches the appearance of Dynamics GP.
Dynamics GP Dictionary Access: Applications developed using Visual Studio Tools have access to the numerous resources available in Microsoft Dynamics GP dictionaries including forms, windows, window fields, table fields, global variables, commands, procedures, and functions.
Dynamics GP Event Notifications: Applications can be notified of events such as a open window, or change of focus in Dynamics GP. This allows developers to perform actions like verifying field values or opening additional windows.
Note: Forms developed using VST are supported on GP Standard (Desktop). They could also be made to work with GP Web Client but require special considerations and code modifications.
Continuum & sanScript
Continuum is the Component Object Model (COM) API that is available for Microsoft Dynamics GP. Development Environments that support COM can use the Continuum API to interact with Microsoft Dynamics GP.
Dynamics GP COM objects used by Continuum API provide two basic actions.
- Allow actions to be executed in Microsoft Dynamics
GP, such as pushing a button or setting the value of a window field.
- Notify the integrating application when certain events occur in Microsoft Dynamics
GP, such as when a form opens or the value in a field changes.
SanScript is the language used by the Dynamics GP Dexterity development system. Using Continuum API, developers have the ability to call Dexterity functions from Dynamics GP dictionaries.
Note: Extensions developed using Continuum and sanScript are only supported on GP Standard (Desktop).
Modifier with VBA
Modifier is a customization tool that can be used to modify appearance and functionality of any Dynamics GP window. It can be used to make three basic types of modifications: modifying the appearance of windows, making global changes to the interface, and adding new
All changes and additions made via Modifier are stored in the Forms Dictionary separate from Dynamics GP Dictionary. They can be enabled or disabled using Alternate/Modified Forms and Reports window in GP Setup.
Note: Forms updated or created using Modifier are supported on both GP Standard (Desktop) and Web Client provided they do not use VBA. VBA scripts are only supported on GP Standard.
Direct SQL Access
External applications can use ADO.NET & other ODBC interfaces as well as SQL Scripts & SQL Jobs to access Dynamics data directly. The Direct SQL Access does require more sophistication to set up and use, especially when data is being written to the Dynamics GP database.
Knowledge of the Dynamics GP database and table structures is essential when using this method.
Note: External application developed using .NET or other technologies that do not utilize one of the above supported methods will not work on GP Web Client.
Infographics: Dynamics GP Development and Integration Tools
Dynamics GP Integration & Automation Tools
Web Services for Microsoft Dynamics GP
Web Services for Microsoft Dynamics GP provide an ideal way for external applications to integrate with Microsoft Dynamics GP. They provides access to primary documents and transactions in the Dynamics GP system. Through Web Services, integrating applications can retrieve documents, create new documents, update existing documents, and delete or void documents.
GP Web Services use eConnect to get access to Dynamics GP data, but no knowledge of eConnect is required to use the web service. The Dynamics GP web
service interface completely isolates the web service developer from eConnect. The eConnect interfaces can still be used when the Dynamics GP web service is
Another advantage of GP Web Services is that its fully integrated with Dynamics GP Security. The administrator of the Web Services can configure security so only
specified users are allowed to perform actions like creating or updating sales documents.
Web Services are also development tool independent. They can be used from any development environment that supports calling .NET WCF or Standard SOAP Web Services.
eConnect is a collection of tools, and APIs that allow applications to programmatically interact with Microsoft Dynamics GP. It uses XML to import or export data leveraging existing transaction-based business logic of Microsoft Dynamics GP. The key eConnect components and interfaces include:
- .NET API
- Microsoft BizTalk Application Integration Component (AIC)
- Microsoft Message Queuing (MSMQ) services
These eConnect interfaces allow external applications like web storefronts, web services, point-of-sale systems, or legacy applications to integrate with Microsoft
Dynamics GP. It allows external applications to perform actions like creating, updating, retrieving, and deleting back office documents and transactions.
Note: Although eConnect includes a large number of documents, not all Microsoft Dynamics GP transactions & routines are available through eConnect.
Integration Manager for Microsoft Dynamics GP is a GUI-based data integration tool designed to move data quickly and easily into Dynamics GP without the need for custom programming or extensive knowledge of application databases.
Integration Manager allows users to create an integration by specifying sources, destinations, and destination mappings. Sources include the data to integrate into a destination, such as text files or ODBC databases. A destination indicates where to integrate the source data within Microsoft Dynamics GP, such as General Journal or Payables Transaction.
Alba Spectrum’s Order Connector is a set of SQL Stored Procedures coupled with Web Services that provides integration between e-commerce & sales order entry system to back office Dynamics GP environment.
It does not use eConnect or GP Web Services and can be deployed with minimum effort. It currently supports Sales Document, Customer & Item integration into Dynamics GP.
Advanced Workflow framework can be used to collect, review and integrate data into Microsoft Dynamics GP. It provides support for workflow-enabled web forms that can collect data from the users and route it through hierarchy of review & approval steps before integrating it into Dynamics GP.
Advanced Workflow can effectively provide configurable business process automation across the enterprise. More information is available in the Workflow section of our web site.