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) 

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

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

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) 

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) 

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

 

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) 

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

 

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)

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

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

 

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) 

 

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) 

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

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

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

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

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

 

Best Practices Knowledge Base (KB) Articles

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

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

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) 

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

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) 

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

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

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

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

 

Advanced Techniques Knowledge Base (KB) Articles

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

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

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

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

Using the Script Debugger in runtime (KB 850487) 

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

 

Cross Dictionary Development Materials 

Cross Dictionary Dexterity Development conference sessions materials

 

Training Materials

Dexterity Basics for Microsoft Dynamics GP 9.0 

Direct download of archive file

Dexterity Integration for Microsoft Dynamics GP 9.0

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  (PartnerSource)

Dexterity Development System Releases for Great Plains 8.0  (CustomerSource)

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

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

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

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

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

Dexterity Development System Releases for Microsoft Dynamics GP 2010  (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.

Comments

• Anonymous
  July 24, 2008
  The Modifier & VBA Articles & Links page and the Dexterity Articles & Links page have been

• Anonymous
  August 10, 2008
  Something I am often asked is how to get started with Dexterity. As Dexterity is not really known outside

• Anonymous
  October 15, 2008
  Time to get into some Dexterity code. I saw a posting today on the Microsoft Dynamics GP community forum.

• Anonymous
  October 15, 2008
  Today I saw another posting on the Microsoft Dynamics GP Community Forum about an error when going into

• Anonymous
  October 20, 2008
  Over the years I have had many requests for training on the various tools available for customising or

• Anonymous
  February 04, 2009
  There have been a couple of great Dexterity related posts on the blogsphere recently. So, to make sure

• Anonymous
  May 02, 2010
  Dear David, I am a Senior .NET Developer. I want to explore Dexterity Article and Links but I am not able to explore because I am not registered in the Partner source. Can you help me to register with you my MSN ID is [redacted for privacy]@hotmail.com Regards Azhar Jamal

• Anonymous
  May 02, 2010
  Azhar, For access to partnersource, you need to contact voice@microsoft.com as they would likely have to set up an account for you if your company doesn't already have one. patrick

• Anonymous
  May 04, 2010
  I am calling my reports developed in Crystal Reports 9 from GP 10 using Dexterity code in a 3rd Party dictionary which i use a Crystal Report Viewer. Users login to the GP Server remotely and launch GP. When the reports were based on tables, my code worked fine. When the report was based on a Stored Proc, the code failed. Now users cannot view any report. They get an error "The user is not associated with a trusted SQL Server connection." I have created a generic user id in SQL to connect to the reports. When I am a member of Administrators group on the server, I don't have issues. Other users who are not members of Administrators get the error message when they launch the Crystal Report from GP. What can I do? I am quite desperate. Thanks. Saras

• Anonymous
  May 05, 2010
  Hi Saras This issue sounds like it might be a problem with Crystal Reports. Using comments on the blog is not the correct way to get support for issues, especially if they are urgent. Can I suggest logging a support incident with the Crystal Reports team. Thanks David

• Anonymous
  August 14, 2010
  Hi All, Is there anyone who came across this error attached below. EXCEPTION_CLASS_OBJECT_EXCEPTION Exception subclass :-2147467263 It occurred while trying to generate a crystal report from GP using dexterity. Or  can u guys have the code and steps for callling the crystal report using dex? Thanking you all in advance. Regards

• Anonymous
  August 15, 2010
  Hi Thomas Have a look at the sample applications on blogs.msdn.com/.../dexterity-samples.aspx Download  COMCrystal.zip and have a look at the sample code. If you need further technical assistance, please use the forums/newsgroups or log a support case. Thanks David

• Anonymous
  February 18, 2011
  Hi, I am using dexterity10 for GP10 customization. In my dexterity code, I am calling store procedure which having one input parameter and two output parameter. Now my customization is working good in GP with store procedure. Now in my dexterity code I already added warning message for code value. Thats why it was give me a message ‘SQL_SPROC_ERROR constant, -127′ in GP10 when I run my customized form. But when I checked in SQL, my SP was working correctly. So I want to know why it was gave me above error and How ro resolved it? Thanks & Regards, Tanuja

• Anonymous
  February 20, 2011
  Hi Tanuja Blog comments are not a good support platform. Can I suggest asking on the newsgroups so others can help and also others can benefit from the answer.  There are links for newsgroups and forums on the right hand side of the blog page blogs.msdn.com/DevelopingForDynamicsGP.  The other option is to open a support incident. Please note that we have seen issues with handling of dates which works from SQL but fails from inside GP. blogs.msdn.com/.../smartlist-builder-based-on-sql-view-not-returning-data.aspx David