This is the portal page for GP Power Tools for Microsoft Dynamics GP (based on the product previously known as the Support Debugging Tool for Microsoft Dynamics GP).
Find this page using the URL: http://winthropdc.com/GPPT
Important: Please update all Winthrop Products to resolve an Installer Security Vulnerability discovered (details here).
Below are the current release details:
- For Microsoft Dynamics GP (v18.5) Modern Lifecycle:
Build 29.4 (Last Modified: 10-Jan-2023), Installer: 18.05.0029.4
- For Microsoft Dynamics GP (v18.4) Modern Lifecycle:
Build 29.4 (Last Modified: 10-Jan-2023), Installer: 18.04.0029.4
- For Microsoft Dynamics GP (v18.3) Modern Lifecycle:
Build 29.4 (Last Modified: 10-Jan-2023), Installer: 18.03.0029.4
- For Microsoft Dynamics GP (v18.2) Modern Lifecycle:
Build 29.4 (Last Modified: 10-Jan-2023), Installer: 18.02.0029.4
- For Microsoft Dynamics GP 2018 & GP 2018 R2 (v18.0):
Build 29.4 (Last Modified: 10-Jan-2023), Installer: 18.00.0029.4
Below are the no longer developed release details:
- For Microsoft Dynamics GP 2016 & GP 2016 R2 (v16.0):
Build 29.4 (Last Modified: 10-Jan-2023), Installer: 16.00.0029.4
- For Microsoft Dynamics GP 2015 & GP 2015 R2 (v14.0):
Build 29.4 (Last Modified: 10-Jan-2023), Installer: 14.00.0029.4
- For Microsoft Dynamics GP 2013 & GP 2013 R2 (v12.0):
Build 28.9 (Last Modified: 17-Aug-2021), Installer: 12.00.0028.9
- For Microsoft Dynamics GP 2010 (v11.0):
Build 27.5 (Last Modified: 24-Oct-2019), Installer: 11.00.0027.5
GP Power Tools for Microsoft Dynamics GP is a Dexterity, Visual C# and Visual Basic .Net based integrated product for Microsoft Dynamics GP which contains a collection of utilities and tools to make the tasks of administering, supporting and developing Microsoft Dynamics GP easier and faster.
GP Power Tools Introduction (direct link)
Watch the Benefits Presentation below to see why every GP customer globally should have GPPT:
GP Power Tools is sold as three modules which can be bought separately, with some standard features available when any module is registered. The three modules and their features are:
- Avoid data entry errors! Company based colour schemes provide an immediate visual cue to which company is being used.
- Gain full administrative and audit control of your security system, including Deny-Based Security and Dynamic Product Selection.
- Roll out Dex.ini setting and Launch File changes to all workstations.
- Simplify troubleshooting by disabling third party products and customizations (including Visual Studio Addins and VBA).
- Users can customize window positions and sizes based on the how they use the system.
- Manage user licenses with user activity tracking, automatic logout and login limits.
- Create, execute and publish scripts from inside Dynamics GP, using Dexterity, Transact-SQL, Visual C# and Visual Basic .Net.
- Create triggers to schedule events, customize Dynamics GP, and debug issues by automatically capturing logs. Works for original or modified windows.
- Build custom Report Writer functions, custom Service Based Architecture (SBA) service procedures or custom URL Drill Backs.
- Request parameters from users for scripts without needing any additional programming and perform actions on SQL results returned.
- Group triggers, scripts and parameter lists together into development projects for easy maintenance and exporting & importing.
- Synchronize and repair Dynamics GP Companies and Users with SQL Server Databases, Logins and Database Users.
- Update Logins and passwords after moving to a new SQL Server or when creating test environments.
- Clean up system tables and validate database integrity and table structures before upgrading to minimize upgrade issues.
- Export and import selected data from multiple tables using XML for quick transfer of small amounts of data between systems or for backups.
- Easily reset user passwords and change password policy settings.
Essential system features that come with the first module you register:
- Capture and email 5 system logs in “One-Click”.
- Capture and email a full system status report and screenshots of all open windows in “One-Click”.
- Send emails from inside Dynamics GP even with no email client installed.
- Change Dex.ini and registry settings from inside GP, including making GP work well on high res monitors.
The tools contain two types of features; Standard Mode and Advanced Mode. Standard Mode features can be used safely by all users. Advanced Mode features require system administrator or database owner (dbo) privileges and require expertise in Dexterity, Visual C#, Visual Basic .Net and/or SQL Server administration.
FREE 30 DAY TRIAL AVAILABLE – Just download, install and add your contact details into the registration system, then just click on the individual key icons for each module to request trial keys.
Below are the links for the various release announcement blog posts:
- 10-Jan-2023: #GPPT GP Power Tools Build 29.4 hotfix released
- 10-Aug-2022: #GPPT GP Power Tools Build 29.1 released
- 12-Aug-2021: #GPPT GP Power Tools Build 28.9 hotfix released
- 17-Jun-2021: #GPPT GP Power Tools Build 28.8 hotfix released
- 03-May-2021: #GPPT GP Power Tools Build 28.7 hotfix released
- 19-Feb-2021: #GPPT GP Power Tools Build 28.6 hotfix released
- 06-Jan-2021: #GPPT GP Power Tools Build 28.5 hotfix released
- 23-Nov-2020: #GPPT GP Power Tools Build 28.4 hotfix released
- 13-Oct-2020: #GPPT GP Power Tools Build 28.3 hotfix released
- 25-Sep-2020: #GPPT GP Power Tools Build 28.2 hotfix released
- 11-Aug-2020: #GPPT GP Power Tools build 28.1 released
- 24-May-2019: #GPPT GP Power Tools build 27 released
- 12-Feb-2019: #GPPT GP Power Tools build 26 released
- 10-Jul-2018: #GPPT GP Power Tools build 25 released
- 09-May-2018: #GPPT GP Power Tools build 24 released
- 16-Nov-2017: #GPPT GP Power Tools build 23 released
- 22-Jun-2017: #GPPT GP Power Tools Build 22 hotfix released
- 24-Feb-2017: #GPPT GP Power Tools build 22 released
- 01-Jul-2016: #GPPT GP Power Tools build 21 released
- 04-Sep-2015: #GPPT GP Power Tools Build 20 hotfix 2 released
- 21-Aug-2015: #GPPT GP Power Tools Build 20 hotfix released
- 04-Aug-2015: #GPPT GP Power Tools Build 20 released
- 07-Jul-2015: #GPPT Welcome to the GP Power Tools Public Beta
Frequently Asked Questions
These links provide additional information about GP Power Tools:
- #GPPT Installing/Updating GP Power Tools
- #GPPT Setting up GP Power Tools
- Important: Please update all Winthrop Products to resolve an Installer Security Vulnerability
- How Do I Get Keys For A New Version?
- Subscription Keys Not Renewing Automatically
- Changing Registration Contact Details for Winthrop Products
- #GPPT Setting up GP Power Tools in a Development Environment
- #GPPT Where can I find GP Power Tools Documentation
- #GPPT Where can I find the Registration window?
- #GPPT Automatic Logout for Microsoft Dynamics GP
- #GPPT Managing User Licenses with GP Power Tools
- #GPPT Why does Automatic Logout fail to work?
- #GPPT Why Does The Report Writer Screen Close Automatically?
- #GPPT Automatic Logout Not Identifying Activity and Logging Out
- #GPPT GP Power Tools Build 28 Sneak Peek
- #GPPT Replacing VBA with GP Power Tools – Developer Tools
- Solution to Registration issues on Winthrop Development Consultants products
- #GPPT Why every GP site needs GP Power Tools – Series Introduction
- #GPPT GP Power Tools: What’s in each module series?
- #GPPT FAQ: What features belong to each GP Power Tools Module?
- #GPPT Top Benefits of GP Power Tools
- 21 Reasons why you should upgrade to GP Power Tools
- #GPPT GP Power Tools Build 27 is coming soon
- #GPPT GP Power Tools Build 26 is coming soon
- #GPPT GP Power Tools Build 22 is [almost] here
- #GPPT Stopping the subscription expiry warning message
- #GPPT Stopping the subscription expiry warning message revisited
- #GPPT What’s New: Series summary for GP Power Tools build 20
- #GPPT Installing GP Power Tools (Upgrading from SDT, Silent Installs and more)
- #GPPT Why wait till you upgrade to install GP Power Tools?
- #GPPT An open operation on the table ‘MBS_ScreenShot_Forms’ failed because the path does not exist.
- Also please see the Support Debugging Tool Portal.
To sample customisation code for GP Power Tools, please go to the page below:
To view videos on the various GP Power Tools features or a full product demonstration, please go to the page below:
IMPORTANT NOTICE: To ensure continued registration and the best experience, always install the latest build. Install over the top of the existing build, no need to uninstall first. You can also copy the updated files from one install to other installs. See article: Updating GP Power Tools.
GP Power Tools MUST be installed on all workstations and servers where Microsoft Dynamics GP is installed to be fully functional. If this recommended configuration is not followed, do not expect all the features of the product to function correctly.
The download links and User Guide Manual Documentation are available from the following page:
Note: The manual is included with the installer, but is also available as a separate download.
GP Power Tools for Microsoft Dynamics GP – Brochure handout
GP Power Tools for Microsoft Dynamics GP – Benefits Presentation
Support for GP Power Tools is provided by Winthrop Development Consultants.
Support cases can be logged using the Contact Support page:
For customers, the price of an annual subscription for the first module (including system features) is US$550 (shown as US$450 for the module and US$100 for system features), Each of the additional modules can be added for US$450. So, the price for one module is US$550, two modules is US$1000 and all three modules is US$1450.
As an annual subscription, each subsequent year renewal is for the same amount. There is no additional maintenance or annual enhancement fee, just the annual subscription. The price is per system and not affected by the number of users or companies.
Any ordering questions can be sent via the Contact Sales page:
Partners can request permanent Not for Resale (NFR) registration keys.
Please sign up as a partner with Winthrop Development Consultants on the Partners page and you are automatically entitled to NFR registration keys for your in-house or demonstration systems.
Note: Partners must be using registration keys with their registered site name and not demo keys with Two, Inc. for NFR registration to work.
For more information and links for obtaining quotes or placing orders, please see the GP Power Tools pages on the Winthrop Development Consultants site:
Other Articles and Posts
For other related articles and posts have a look at the GP Power Tools category page.
Comments and Feedback
Please provide comments, feedback and suggestions for GP Power Tools to help us understand how we can improve it.
Last updated: 16-Mar-2023.
52 thoughts on “GP Power Tools Portal”
Hi Dave – is there any capability to add events to the SQL Profiler traces created by the Support Debugging tool? I was interested in adding Exceptions as an event to be captured.
You can edit the MBS_SQL_Tracing_API_X stored procedures in the System Database. I would edit the Other one which is MBS_SQL_Tracing_API_5.
Have you checked the different modes and checked if they contain what you want?
Please can you provide details of what you want to add, so I can review and possibly add them to GP Power Tools.
I am attempting to build a vb.net application to log into a company, build a check batch and print checks. Can I use GPPT to help build that? I tried using a macro to log in and do this, but it stops processing when I get to the print Mekorma checks button, so I am looking for an alternate means of accomplishing this.
I think the Mekorma Print Button uses macros which is why the macro stops. You will probably still need a macro to login.
You can use Startup shortcuts to open the window and then you could use non-logging automatic debugger mode triggers to execute Dexterity code to perform the desired actions.
Mekorma demoed an upcoming product at GPUG Summit that you would be interested in as it sounds like it might solve your requirements.
Can the “Dictionary Control” be used to disable dictionaries for only selected GP companies?
At this time, Dictionary Control is system based, so it will disable the dictionary for all companies.
Disabling on a per company basis is a good idea and I have added it to the feature wish list.
I wonder if this functionality will be added in your product, if it is, do you have a date for it?
Meanwhile, do you think I could manage products for each companies using dexterity and the table WPT40200? Actually I have just one product that I would to disable for certain companies.
Is there a way to turn on logging for a particular user only each time they log on?
Have a look at The Understanding Logging Modes series:
If you create a trigger with no resource it will start manual mode on login. If you limit the user you can specify the user.
However, if you are looking for something specific, then I would use one of the other Automatic Debugger Modes that actually looks for a condition or Automatic control of Manual Logging to turn it on and off based a window opening or some other event.
Thanks David, that is exactly what I was looking.
LikeLiked by 1 person
Hi David – I’m looking for a way to set the Windows default printer right before printing the EFT remittance advice using Word Templates. Then, reset the default printer after the process completes.
It looks like I could use Automatic Debugger Mode triggers to fire a .Net Execute script that does the work in Windows. Is that a good way to approach this requirement?
That sounds like an awesome use for the scripting technology in GP Power Tools.
Would you be willing to share your code so I can post a blog about it and give you credit.
Sure – I’ll share the code. This is new for me so it will be a learning experience. I’m looking forward to figuring it out. Just wanted to make sure I was not missing another technique to accomplish the task.
Please let me know if you need any help.
Does the latest release fix the screen rendering issue when using the prevent windows outside of the active section setting?
Yes, All known issues with automatic window positioning are fixed.
I absolutely love GP Power Tools!!!! It makes GP support much easier. One question:
I will often get a customer’s GP “environment” sent to me to debug an issue. By GP environment, I mean: 1) DYNAMICS database backup, 2) company database backup, and 3) zipped copy of the folder and subfolders where GP is installed (e.g. C:\Program Files (x86)\Microsoft Dynamics\GP2016). Then I restore the databases to my SQL instance and unzip the GP folder to an arbitrary place on my hard drive. Note that the GP instance is not “installed” on my computer. As such, it will NOT have an entry in the Windows registry underneath this key: “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Business Solutions\Great Plains”.
If I try to install GP Power Tools in that GP instance, it does not appear in the list of GP Instances in the GP Power Tools installation wizard window. The only workaround I have found is to copy an existing GP instance registry key and rename it and change a few other settings in that registry key such as the various folder/path keys. Then the GP instance will appear in your installation wizard and I can install Power Tools into it.
Is there any easier solution other than hacking the registry? Ideally, I would like to have the option of manually browsing to a folder where I have GP installed rather than only loading GP instances from the registry.
Choose an existing instance as though you are going to install over the top. When path is displayed, change it to the path of the other instance.
Thank you David!
Does GP Power Tools have the ability to clean up converted Security Tasks/Roles from older versions of GP? I have a client that has hundreds of converted Tasks & Roles. It is making their auditing process very difficult.
This is not something that GP Power Tools specifically has. You can use the SQL Execute window to run SQL Scripts to clean up the data.
Have a look at my article below for information and the scripts:
how to get the Not for Resale keys?
Please look at the section called “Ordering Information” above.
Can you call a runtime execute script from visual studio?
You can call Runtime Execute (as well as SQL Execute and .Net Execute) from Visual Studio tools. Use the following methods to load a script and then execute it.
I am trying to troubleshoot an error that looks related to GP power tools, ‘FN_TRACE_GETINFO’ error when logging into a GP company, Not sure if anyone has seen that error before. If so I will take any advise anyone has 🙂
I wanted to remove GP Power tools from the set file to see if that resolves the error we are seeing, can you tell me what other files (dll’s, vba files ect..) that are tied to this product so I can take them out of the mix? Just removing it from the set file and renaming the .dic file did not do the trick so there must be something else I need to remove to get past it.
You can use the form at https://www.winthropdc.com/support.htm to log support requests.
The error is because you have SQL Profile Tracing enabled but not set up properly. Please redo the setup via the Logging Settings window. Step by step instructions are in chapter 2 of the user guide manual.
Is there a reason that the wonderful “Security Privilege Warning box” only works on windows and not dexterity reports?
For example – if you deny access to a window via Enhanced Security – you get the standard “You don’t have security privileges to open this window. Security access denied to window: etc etc etc.
but when you do it for a dexterity report you get the ugly “Not privileged to run this report”
I have checked what is happening and my code is doing everything it is meant to. It changes the returned string to add the details of the report. It will open the Security Profiler if it is configured to open automatically. It will display the information in the Security Profiler if the window is open. It will record the statistic in the Security Logging feature (if enabled). It will write the details of the security error to the user’s GP Power Tools log (unless this option is disabled).
The problem is the Runtime Engine code that displays the dialog for the reports is hardcoded when the code for the windows isn’t. So regardless of what I do for reports, it won’t display more information. You still have the logs, security logging and the security profiler.
Sorry I can’t fix this one.
You can call Runtime Execute (as well as SQL Execute and .Net Execute) from Visual Studio tools. Use the following methods to load a script and then execute it.Thank you for providing such information.
Yes you probably could as there are helper functions which allow you to load and execute scripts.
My question is why? Why not just do everything in GP Power Tools?
Install the free 30 day trial period and try it out.
Does GP Power Tools add audit capability to track changes to static/setup tables?
Hi Carlo. GP Power Tools is not specifically an audit tool but can be setup to track changes to tables. See this example:
I am in the process of evaluating GPPT for our typical use. One area of particular interest is the trigger tools to replace VBA.
We use VBA to set the default “ship to” address field in the purchasing requisition entry window. When I follow your example at https://winthropdc.wordpress.com/2017/12/22/gppt-using-gp-power-tools-to-set-default-values-on-windows/ I get a “Type incompatibility ‘(L) ShipToEditedButton’ error. Strange thing is if I test a different field there is no issue. Could the VBA solution be the root cause? I tried removing the code and the window from VBA but the error persists.
Hi Randy. Blog comments are not the best way of getting support. You can use the contact us page on the website or email the support email alias.
I can make a guess that you are trying to click the button by setting it to 1 (VBA hack method) rather than using the run script command (Dexterity method).
You might find my article on moving away from VBA mindset useful: