This page contains links to articles related the Microsoft Dynamics GP development tools.
Dexterity Knowlege Base (KB) Articles
Note: We have updated links to new articles on Microsoft Learn where available and also added links to PDF Downloads from our archives. Many of these articles were written by David Musgrave during his time with Microsoft.
Getting Started Knowledge Base (KB) Articles
- How to set up the development environment when you use Dexterity in Microsoft Dynamics GP (KB 949622) Link Updated – (PDF Download)
- Description of product IDs for Dexterity in Microsoft Dynamics GP (KB 914899) Link Updated – (PDF Download)
- How to create a chunk file in Dexterity in Microsoft Dynamics GP (KB 894700) Link Updated – (PDF Download)
- 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) Link Updated – (PDF Download)
- 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) Link Updated – (PDF Download)
- Description of the different ranges in Dexterity for Microsoft Dynamics GP (KB 922057) Link Updated – (PDF Download)
Working with Dexterity Knowledge Base (KB) Articles
- Tips and references for upgrading your Great Plains Dexterity-based application to Great Plains 8.0 Dexterity (KB 894701) (Not available) – (PDF Download)
- 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) Link Updated – (PDF Download)
- Information about version numbers and build numbers of Dexterity in Microsoft Dynamics GP (KB 920831) Link Updated – (PDF Download)
- How To Create a Company and Copy in my Existing Data for Great Plains on Pervasive.SQL 2000 or C-tree (KB 850489) – (PDF Download)
- 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) Link Updated – (PDF Download)
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) Link Updated – (PDF Download)
- How to create SQL tables for an integrating Dexterity program (KB 874554) – (PDF Download)
- How to write “Passthrough” SQL statements and “Range Where” clauses in Microsoft Great Plains Dexterity (KB 910129) Link Updated – (PDF Download)
- How to pass dates and times to SQL Server from Dexterity in Microsoft Dynamics GP (KB 929786) Link Updated – (PDF Download)
- How to use a “Range Where” clause that is based on more than one table in Dexterity in Microsoft Dynamics GP (KB 922056) Link Updated – (PDF Download)
Best Practices Knowledge Base (KB) Articles
- Rules to maintain alternate windows when you make customizations in Dexterity in Microsoft Dynamics GP (KB 929211) Link Updated – (PDF Download)
- 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) Link Updated – (PDF Download)
- Information about how to handle literal string warnings by using messages in Dexterity in Microsoft Dynamics GP (KB 943178) Link Updated – (PDF Download)
- 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) – (PDF Download)
- Description of the Language ID global system variable in Microsoft Dynamics GP (KB 942751) Link Updated – (PDF Download)
- Description of “permanent” temporary tables in Dexterity in Microsoft Dynamics GP (KB 921638) Link Updated – (PDF Download)
- A third-party customization is still triggered even if a user cannot log on to the company in Microsoft Dynamics GP (KB 943959) Link Updated – (PDF Download)
- Information about table hierarchy inconsistency errors in Dexterity in Microsoft Dynamics GP (KB 921637) Link Updated – (PDF Download)
Advanced Techniques Knowledge Base (KB) Articles
- How to add Named Printers support to a report by using triggers in Microsoft Dynamics GP (KB 921636) Link Updated – (PDF Download)
- How to combine the Dynamics.dic core dictionary and an extracted dictionary by using Dexterity Utilities in Microsoft Dynamics GP (KB 930350) Link Updated – (PDF Download)
- How to improve the performance of user-defined Report Writer functions in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains (KB 920830) (Not available) – (PDF Download)
- How to use multiple string formats in a scrolling window by using Dexterity in Microsoft Dynamics GP (KB 949623) Link Updated – (PDF Download)
- How to use the Dexterity Script Debugger to trace bugs and performance issues in Microsoft Dynamics GP (KB 910982) Link Updated – (PDF Download)
- Useful functions for developers to use instead of creating alternate reports in Microsoft Dynamics GP (KB 888884) Link Updated – (PDF Download)
Report Writer Knowledge Base (KB) Articles
Troubleshooting Knowledge Base (KB) Articles
- How to use and troubleshoot Report Writer in Microsoft Dynamics GP (KB 861803) Link Updated – (PDF Download)
- How to re-create the Reports.dic file in Microsoft Dynamics GP (KB 850465) Link Updated – (PDF Download)
Report Writer Functions Knowledge Base (KB) Articles
- How to access information about Report Writer functions in the Microsoft Dynamics GP SDK (KB 928172) Link Updated – (PDF Download)
- How to use Customization Maintenance packages to enable Great Plains Report Writer functions from a 3rd party report dictionary (KB 862665) – (PDF Download)
- How to display a date in any format in a report in Microsoft Dynamics GP (KB 925970) Link Updated – (PDF Download)
- How to round a calculated field in Report Writer in Microsoft Dynamics GP (KB 872275) Link Updated – (PDF Download)
- How to display a string label instead of an integer representation of a radio group in Microsoft Dynamics GP (KB 926393) Link Updated – (PDF Download)
- How to create a Line Number field for the line items on the SOP Blank Quote Form, on the SOP Blank Order Form, on the SOP Blank Invoice Form, on the SOP Blank Return Form, and on the SOP Blank Back Order Form reports in Microsoft Dynamics GP (KB 857285) – (PDF Download)
- Useful functions for developers to use instead of creating alternate reports in Microsoft Dynamics GP (KB 888884) Link Updated – (PDF Download)
Graphics Knowledge Base (KB) Articles
- How to prevent the image quality of a graphic from being reduced when you print a graphic from Report Writer in Microsoft Dynamics GP (KB 854470) Link Updated – (PDF Download)
Fonts Knowledge Base (KB) Articles
- Font used when Best Text Fit is marked (KB 849370) – (PDF Download)
- How to control the printer font size in Great Plains (KB 869078) (Not available) – (PDF Download)
- Printer Fonts Selected by Dynamics (KB 870341) – (PDF Download)
Other Knowledge Base (KB) Articles
- Copying The Layout From a Modified Invoice to an Unmodified Invoice in version 6.0 (KB 856003) (Not available) – (PDF Download)
- Formats Not Exported to .Package Files (KB 851092) – (PDF Download)
Extender Knowledge Base (KB) Articles
- How to create a calculated field in Report Writer to print Extender fields in Microsoft Dynamics GP reports (KB 935385) (Not available) – (PDF Download)
Modifier & VBA Knowledge Base (KB) Articles
- How to add a hidden field by using Modifier with Visual Basic for Applications in Microsoft Dynamics GP (KB 951230) – (PDF Download)
- Error message when you expand a scrolling window by using VBA in Microsoft Dynamics GP: “Run-time error ‘1008’: Unsafe Operation” (KB 951231) Link Updated – (PDF Download)
- How to use ActiveX Data Object (ADO) with VBA on a window with Microsoft Dynamics GP and with Microsoft Business Solutions – Great Plains 8.0 (KB 942327) (Not available) – (PDF Download)
- How to use an ActiveX Data Object (ADO) with VBA on a report in Microsoft Dynamics GP (KB 954619) (Not available) – (PDF Download)
- Information about the new connection objects in VBA that replace the RetrieveGlobals.dll and RetrieveGlobals9.dll files in Microsoft Dynamics GP 10.0 (KB 936115) Link Updated – (PDF Download)
- Error message when you run the UserInfoGet.CreateADOConnection VBA function in Microsoft Dynamics GP 10.0: “Login failed for user ‘[User Name]'” (KB 941457) (Not available) – (PDF Download)
- Formats Not Exported to .Package Files (KB 851092) – (PDF Download)
- A user who is not an administrator experiences VBA permission problems in Microsoft Dynamics GP (KB 929612) Link Updated – (PDF Download)
- Type mismatch error comparing currency fields in VBA (KB 843656) – (PDF Download)
Developer Toolkit Knowledge Base (KB) Articles
- How to upgrade applications to use the GPConn.dll file or the GPConnNet.dll file in Microsoft Dynamics GP 9.0 (KB 912960) Link Updated – (PDF Download)
- How to use the new RetrieveGlobals9.dll file in Integration Manager and in Microsoft Dynamics GP 9.0 (KB 913341) (Not available) – (PDF Download)
- Information about the new connection object in Integration Manager for Microsoft Dynamics GP 10.0 (KB 939371) Link Updated – (PDF Download)
- Error message when you try to install Dexterity or the Visual Studio Tools for Microsoft Dynamics GP 10.0 SDK: “.NET Framework 2.0 is not detected. Fatal error during installation” (KB 952376) (Not available) – (PDF Download)
- You cannot insert a menu item that is always visible by using Visual Studio Tools for Microsoft Dynamics GP (KB 922871) Link Updated – (PDF Download)
Last updated: 25-Sep-2025.