Dexterity Articles & Links

This is a page to provide links to Dexterity related articles and materials. Note that articles which mention specific versions are often valid for other versions as well.

Getting Started Knowledge Base (KB) Articles

How to set up the development environment when you use Dexterity in Microsoft Dynamics GP (KB 949622) Secure Link

Description of product IDs for Dexterity in Microsoft Dynamics GP (KB 914899) Secure Link

How to create a chunk file in Dexterity in Microsoft Dynamics GP (KB 894700) Secure Link

Creating a Microsoft Dynamics GP Chunk File 

How to use an index file and the Microsoft Dynamics GP Dexterity source code control functionality to make sure that the resources that you create maintain the same resource ID in different builds and versions of your code (KB 894699) Secure Link

How to use an Index File

How to upgrade a Dexterity-based application in Microsoft Dynamics GP or in Microsoft Great Plains by using the Dexterity Source Code Control Service (KB 910527) Secure Link

Description of the different ranges in Dexterity for Microsoft Dynamics GP (KB 922057) Secure Link

 

Working with v8.00 Knowledge Base (KB) Articles

Tips and references for upgrading your Great Plains Dexterity-based application to Great Plains 8.0 Dexterity (KB 894701) Secure Link

How To Create a Company and Copy in my Existing Data for Great Plains on Pervasive.SQL 2000 or C-tree (KB 850489) Secure Link

 

Working with v9.00 Knowledge Base (KB) Articles

Menus for a third-party product appear in Microsoft Dynamics GP but do not appear in the "by Menu" view of the Advanced Security window (KB 927701) Secure Link

Information about version numbers and build numbers of Dexterity in Microsoft Dynamics GP (KB 920831) Secure Link

How To Create a Company and Copy in my Existing Data for Great Plains on Pervasive.SQL 2000 or C-tree (KB 850489) Secure Link

 

Working with v10.00 Knowledge Base (KB) Articles

Error message when you try to open a lookup window in Dexterity debug Test Mode in Microsoft Dynamics GP 10.0: "Form Load Failed" (KB 942326) Secure Link

 

Working with SQL Server Knowledge Base (KB) Articles

How to control the location of the Dexterity tables in SQL Server by using Dexterity path names in Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions - Great Plains (KB 919347) Secure Link

How to create SQL tables for an integrating Dexterity program (KB 874554) Secure Link

How to use the Table_SetCreateMode function library command and the Table_SetDeleteOptions function library command in Dexterity in Microsoft Great Plains (KB 910700) Secure Link

How to write "Passthrough" SQL statements and "Range Where" clauses in Microsoft Great Plains Dexterity (KB 910129) Secure Link

How to pass dates and times to SQL Server from Dexterity in Microsoft Dynamics GP (KB 929786) Secure Link

How to use a "Range Where" clause that is based on more than one table in Dexterity in Microsoft Dynamics GP (KB 922056) Secure Link

 

Best Practices Knowledge Base (KB) Articles

Rules to maintain alternate windows when you make customizations in Dexterity in Microsoft Dynamics GP (KB 929211) Secure Link

Referring to third party fields in focus triggers (KB 850482) Secure Link

Error message when you access new fields from an alternate window in Microsoft Dynamics GP: "Illegal Address for field 'field name' in script 'script name'" (KB 941327) Secure Link

Information about how to handle literal string warnings by using messages in Dexterity in Microsoft Dynamics GP (KB 943178) Secure Link

Guidelines for how to write code that can be easily translated and that can be run in multiple languages in Dexterity in Microsoft Dynamics GP (KB 942749) Secure Link

Description of the Language ID global system variable in Microsoft Dynamics GP (KB 942751) Secure Link

Description of "permanent" temporary tables in Dexterity in Microsoft Dynamics GP (KB 921638) Secure Link

A third-party customization is still triggered even if a user cannot log on to the company in Microsoft Dynamics GP (KB 943959) Secure Link

Information about table hierarchy inconsistency errors in Dexterity in Microsoft Dynamics GP (KB 921637) Secure Link

 

Advanced Techniques Knowledge Base (KB) Articles

How to add Named Printers support to a report by using triggers in Microsoft Dynamics GP (KB 921636) Secure Link

How to combine the Dynamics.dic core dictionary and an extracted dictionary by using Dexterity Utilities in Microsoft Dynamics GP (KB 930350) Secure Link

How to improve the performance of user-defined Report Writer functions in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains (KB 920830) Secure Link

How to use multiple string formats in a scrolling window by using Dexterity in Microsoft Dynamics GP (KB 949623) Secure Link

Using the Script Debugger in runtime (KB 850487) Secure Link

Useful functions for developers to use instead of creating alternate reports in Microsoft Dynamics GP (KB 888884)  Secure Link

 

Cross Dictionary Development Materials 

Cross Dictionary Dexterity Development conference sessions materials

 

Training Materials

Dexterity Basics for Microsoft Dynamics GP 9.0 Secure Link

Direct download of archive file

Dexterity Integration for Microsoft Dynamics GP 9.0 Secure Link

Direct download of archive file

Note: The training materials are for version 9.0. Don't worry, this is the latest version and everything is still valid for later versions of Microsoft Dynamics GP and Dexterity.

  

Dexterity Development System Downloads

You might need to check both the PartnerSource and CustomerSource pages as sometimes the latest versions are not updated on both pages.

Dexterity Development System Releases for Great Plains 8.0 Secure Link (PartnerSource)

Dexterity Development System Releases for Great Plains 8.0 Secure Link (CustomerSource)

Dexterity Development System Releases for Microsoft Dynamics GP 9.0 Secure Link (PartnerSource)

Dexterity Development System Releases for Microsoft Dynamics GP 9.0 Secure Link (CustomerSource)

Dexterity Development System Releases for Microsoft Dynamics GP 10.0 Secure Link (PartnerSource)

Dexterity Development System Releases for Microsoft Dynamics GP 10.0 Secure Link (CustomerSource)

Dexterity Development System Releases for Microsoft Dynamics GP 2010 Secure Link (PartnerSource)

Dexterity Development System Releases for Microsoft Dynamics GP 2010 Secure Link (CustomerSource)

  

11-Oct-2010: Added Links for Dexterity Development System Releases for Microsoft Dynamics GP 2010. 

26-Apr-2011: Add direct links to training materials.