Developing for Dynamics GP

by David Musgrave (Perth, Australia) and Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Support Debugging Tool Build 12 released

Support Debugging Tool Build 12 released

  • Comments 21

David Meego - Click for blog homepageSome of you might have had a sneak peak at a few of the new features in build 12 of the Support Debugging Tool for Microsoft Dynamics GP when an early beta version was demonstrated at the Microsoft Dynamics GP Technical Conference 2009. Since then there have been many other changes and improvements.

Well now the new build is completed and available for download.  I am really proud of this build as it "finishes off" a number of features and also fixes some of the issues found with the previous builds.

Below is a summary of the 50 or so changes made for releases 8.00.0012, 9.00.0012, 10.00.0012 and 11.00.0012, I have divided them into logical sections:


  • Fixed Company Based color schemes not changing when switching companies.
  • Fixed Company Based Color schemes being reset even when disabled in Administrator Settings.
  • Fixed Error message when using SQL Execute window against the System Database.
  • Fixed Login dialog appearing when using "Start Logging on next startup only" option.
  • Fixed incorrect colouring of static text in window toolbar for Resource Explorer and SQL Execute Windows.
  • Fixed handling of v10.0 table security for Resource Information, Security Profiler and Security Information (v10.0 only).
  • Fixed looping caused by Security Profiler attempting to open when access to the Security Profiler window is denied.
  • Fixed security access error when Support Debugging Tool menu window attempts to open automatically when access is denied.
  • Fixed Resource Information window Open Button to allow it to work when resource name contains spaces.
  • Fixed Default Path for three logging facilities to use dex.ini path if specified.
  • Fixed issue where file dialogs were causing application to crash.


  • Allow ScreenShot to email System Status and optional files without windows being selected.
  • Added Network User Name to Screenshot's System Summary Report.
  • Added "Show Debug Messages on next login" option to Dex.ini Settings window.
  • Added new ScriptLogEnhanced Dex.ini setting to Dex.ini Settings window.
  • Added control of Windows Toolbar color to Company Based color schemes (v10.0 only).
  • Added Report Explorer to Resource Explorer for use with the Resource Information window.
  • Added Series All to the Report Explorer window to show all reports regardless of series.
  • Added Series All to the Table Explorer window to show all tables regardless of series.
  • Added Table Groups to the Table Explorer window to show tables in their logical table groups.
  • Added Table Group All to the Table Explorer window to show tables regardless of the table group they belong to.
  • Added support for custom reports to Report Explorer and Resource Information windows.
  • Added User and Company tree to Security Information window.
  • Added Security Role, Security Task and Alternate Modified Forms and Report Views to Security Information window (v10.0 only).
  • Added Security Role (System Level), Security Task (System Level) Views to Security Information window (v10.0 only).
  • Allow Security Information window to be opened without a resource selected so that new views can be used.
    Security Information Window
  • Added ability to disable Modified forms and reports from the Dictionary Control Window.
    Dictionary Control Window


  • Speed up Debugger Settings window Tab 1 (Debug) display code.
  • Removed pause caused when Resource Explorer is opened by initializing each explorer window when it is first used.
  • Performance improvements to XML Table Export and XML Table Import features. Approximately 25% faster.
  • Speed up loading of Lookup windows by only loading required table from setup file.


  • Added warning message to Security Information window when Security is not enabled for a company.
  • Remember Last Company Logged into using SQLLastCompany Dex.ini setting.
  • Added Apply Button to Dictionary Control window.
  • On SQL Execute window, moved Syntax information to an additional window to increase screen real estate.
  • Added better handling of notification messages when no data sets returned on SQL Execute window.
  • Added Seeding of Resource Explorer windows from Resource Information Window and XML Table Export window.
  • Improved Usability of Resource Explorer window to allow tree selection to be used when no items selected in list.
  • Added Tooltips to display file paths, useful when the path is longer than the visible areas of the field.
  • Added Zoom to Resource Information window from Security Profiler window using double click or context menu.


  • Added Table handling for Dex.ini Configuration window.
  • Added Dex.ini Configuration window and processor on login.
  • Added Administrator Default Dex.ini Settings to Dex.ini Configuration window.
  • Added Workstation Configuration Override setting to Dex.ini Configuration window.
  • Added additional handling to Dex.ini Settings window when changing settings controlled by Administrator.
    Dex.ini Configuration Window
  • Added audit information (Created Date, Modified Date, User ID, Windows User) to setup tables and add additional table for XML Table Export Profiles.
  • Added Profiles to XML Table Export window to allow multiple sets of tables to be setup and exported.
  • Added Report to XML Table Export window.
    XML Table Export Window
  • Updated Configuration Export/Import to support XML Table Export Profiles.

Please see Support Debugging Tool for Microsoft Dynamics GP 2010 Beta for what is new in the v11.0 build and in the updated builds for v9.0 and v10.0.



A big thank you to the beta testers. A special thanks to Mariano Gomez and Leslie Vail who helped with deciding what fixes and features we needed to include with this build while we were preparing for the troubleshooting session at the Microsoft Dynamics GP Technical Conference 2009.



For downloads, please see the Support Debugging Tool Portal Page:

Support Debugging Tool Portal


Support Information 

The Support Debugging Tool is a custom built tool to provide additional capabilities to troubleshoot issues and is not part of the standard Microsoft Dynamics GP released application. Technical support for this tool is not handled via the standard support systems and instead is provided via the public Microsoft Dynamics GP Community Forum. You can use the link below to access the forum:

To assist the partners and Microsoft employees who monitor the forum for these questions, please prefix any subject lines with the initials "SDT: ".


More Information

For more information, please see the Support Debugging Tool Portal Page:

Support Debugging Tool Portal


Please post your comments on what you think about the new features. Also tell us what other features to assist in supporting and debugging Microsoft Dynamics GP you would like to see in the Support Debugging Tool.


27-Feb-2010: Added details and link for Support Debugging Tool v11.0 for Microsoft Dynamics GP 2010.

10-Mar-2010: Added link for Support Debugging Tool Portal page.

16-May-2013: Updated More Information and Downloads to link to Support Debugging Tool Portal page.

  • Thanks Patrick  for quick reply,

    I mean some thing else,

    Say i import SOP Orders to GP by Using either eConnect/Web Services.

    Now i want to do some more by Connecting to SQL Server, now i need GP User Credentials.

    Is there a way that i can use same User name and Password as used in Gp?

    (Gp encripts the password)

  • Yes but you'd need to use gpconnnet.dll.  for that you'd have to log a dexterity or vstools support case to get the documentation and the reg keys in order to use it.

  • Hi Dave,

    Do you know how (or it is possible) to have access to auto generated number in Integration Manager? I need to do some work in the After Document script.


  • Hi Philip

    This is not the correct location or a relevant post to ask this question. Please use the newsgroups or forums. Links on the right hand pane.


  • Debugging tool may be dangerous, so i suggest you to go for VBA Password Recovery Software. Get more details via this link

  • Hi Sant Marry

    There is no danger from the Support Debugging Tool as all features that can update or view data are protected as Advanced Mode Features and can only be accessed by a user with sysadmin sql permissions.

    Anyhow the SDT does not interface with VBA in any way and does not provide any password related functionality.


Page 2 of 2 (21 items) 12
Comments Information


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 5 and 7 and type the answer here:
  • Post