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)
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
Dexterity Basics for Microsoft Dynamics GP 9.0
Direct download of archive file
Dexterity Integration for Microsoft Dynamics GP 9.0
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.
The Modifier & VBA Articles & Links page and the Dexterity Articles & Links page have been
Something I am often asked is how to get started with Dexterity. As Dexterity is not really known outside
Time to get into some Dexterity code. I saw a posting today on the Microsoft Dynamics GP community forum.
Today I saw another posting on the Microsoft Dynamics GP Community Forum about an error when going into
Over the years I have had many requests for training on the various tools available for customising or
There have been a couple of great Dexterity related posts on the blogsphere recently. So, to make sure
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
For access to partnersource, you need to contact firstname.lastname@example.org as they would likely have to set up an account for you if your company doesn't already have one.
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.
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.
Is there anyone who came across this error attached below.
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.
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.
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,
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.
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.