Developing for Dynamics GP

by Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Dexterity Articles & Links

Dexterity Articles & Links

  • Comments 14

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.

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

Page 1 of 1 (14 items)
Comments Information

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.

Leave a Comment
  • Please add 4 and 6 and type the answer here:
  • Post