Dynamics GP Customization Tools: VST, VBA, Extender, eConnect, Microsoft Dexterity

Utilizing custom programming for your corporate ERP system can be a daunting task.  However, starting with the necessary research on the available coding instruments - and which tools will best fit your requirements - is an excellent first step that will make the rest of your ERP customization project much more manageable.  Most corporate ERP systems offer a number of development tools, and Microsoft Dynamics GP (formerly known as Great Plains Dynamics) offers a wide selection that can be used to tailor your Dynamics GP installation to your company's exact requirements.

Visual Studio Tools for Dynamics GP (VST): VST is the most recent programming and development platform made available for Dynamics GP. It uses either C# or VB.NET instead of Dexterity's Sanscript. The main difference is that Dexterity's resources are placed in a dictionary, while with VST, the compiled code resides in an assembly. With VST, a developer has very similar capabilities to build integrating applications with Dynamics GP.

VBA (Visual Basic for Applications) and Modifier: VBA for Dynamics GP is very similar to the customization tool embedded in Excel, Word and other MS-Office applications. Although simple, these tools are limited in terms of what can be accomplished. Additionally, VBA customizations are not as "sturdy" as those developed with Dexterity. Modifier and VBA are especially useful when a company has VBA developers within its IT staff and the objective is to make simple modifications to forms or reports.

Extender: It is available in two versions, one is directly from Microsoft Business Solutions (so called Standard) and the second one is from its original software developer eOne (here it is called Enterprise). It 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 additional data entry windows that work along with windows already in the system

eConnect: This tool was created in 2003 specifically for Great Plains eCommerce customers to open GP objects to shopping carts (in both B2B and B2C ecommerce scenarios.) Later on, eConnect was expanded to cover the majority of native Dynamics GP modules (initially SOP and Inventory Control, then POP, General Ledger, Payroll, Human Resources and Project Accounting). eConnect does not cover the Great Plains Invoicing module (it is recommended that you choose the Sales Order Processing module instead). When it comes to technology, eConnect is in essence a set of SQL encrypted stored procedures and several stacks of programming calls built on this platform: web services, XML, Integration Manager connectors, etc.

Great Plains Dexterity: The Great Plains Software IDE (Integrated Development Environment) was created to be a shell for Great Plains. Dexterity allows you to customize or alter everything in Dynamics GP (or older Great Plains versions) from the user interface to the database side. Dexterity has its own scripting language, Sanscript, with an integrated development environment where you can modify existing Dynamics GP forms and reports and add new objects such as tables, forms, reports. However, altering existing tables is not supported.  Instead, one can create new tables and link them to existing tables.

 In essence, selection of the appropriate tool depends on the capabilities of your IT staff and/or your Microsoft partner, as well as the specific needs your company is trying to address. If you have specific questions about Dynamics GP Customization Options, or need assistance in integrating and customizing Dynamics GP feel free to contact us at Alba Spectrum Corporation website |1-866-528-0577 | sales@albaspectrum.com).

About Alba Spectrum: Alba Spectrum Corporation website |1-866-528-0577 | sales@albaspectrum.com) is a Chicago, Illinois based Gold-Certified Microsoft Dynamics Partner. We specialize in developing solutions and extensions for Microsoft Dynamics GP (Great Plains Dynamics) in the areas of System Integration, Financial applications, E-Commerce and Warehouse Management (WMS). We also provide strategic consulting on the use and adaptation of Dynamics GP within variety of industries. We serve Microsoft Dynamics Clients and Partners worldwide including United States, Canada, Latin America, Europe, Middle East, Asia & Australia. Local services are available in Chicago, Naperville, Los Angeles, Irvine, San Diego and Houston.