GP Power Tools Portal

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: https://winthropdc.com/GPPT

Important: Please update all Winthrop Products to resolve an Installer Security Vulnerability discovered (details here). Build 29 or later is fixed. Build 28 or before (for v14.0 onwards) is discontinued and cannot re-register.

Below are the current release details:

  • For Microsoft Dynamics GP (v18.6) Modern Lifecycle:
    Build 30.3 (Last Modified: 10-Apr-2024), Installer: 18.06.0030.3
  • For Microsoft Dynamics GP (v18.5) Modern Lifecycle:
    Build 30.3 (Last Modified: 10-Apr-2024), Installer: 18.05.0030.3
  • For Microsoft Dynamics GP (v18.4) Modern Lifecycle:
    Build 30.3 (Last Modified: 10-Apr-2024), Installer: 18.04.0030.3
  • For Microsoft Dynamics GP (v18.3) Modern Lifecycle:
    Build 30.3 (Last Modified: 10-Apr-2024), Installer: 18.03.0030.3
  • For Microsoft Dynamics GP (v18.2) Modern Lifecycle:
    Build 30.3 (Last Modified: 10-Apr-2024), Installer: 18.02.0030.3

Below are the versions no longer being developed (only the final build for each version is supported):

  • For Microsoft Dynamics GP 2018 & GP 2018 R2 (v18.0):
    Build 30.3 (Last Modified: 10-Apr-2024), Installer: 18.00.0030.3
  • For Microsoft Dynamics GP 2016 & GP 2016 R2 (v16.0):
    Build 29.5 (Last Modified: 16-Jun-2023), Installer: 16.00.0029.5
  • For Microsoft Dynamics GP 2015 & GP 2015 R2 (v14.0):
    Build 29.5 (Last Modified: 16-Jun-2023), Installer: 14.00.0029.5
  • 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

Overview

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:

Administrator Tools

  • 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.

Developer Tools

  • 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.

Database Tools

  • 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.
  • Identify and fix issues with company record notes and note index values.

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 resolution 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.

Release Announcements

Below are the links for the various release announcement blog posts:

Frequently Asked Questions

These links provide additional information about GP Power Tools:

Installation, Setup and Registration

Automatic Logout and License Management

GP Power Tools Features

Developing with GP Power Tools

What’s in GP Power Tools

Troubleshooting

Samples

To sample customization code for GP Power Tools, please go to the page below:

Videos

To view videos on the various GP Power Tools features or a full product demonstration, please go to the page below:

Downloads

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 Information

Support for GP Power Tools is provided by Winthrop Development Consultants.

Support cases can be logged using the Contact Support page:

Ordering Information

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.

More Information

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: 10-Apr-2024.

52 thoughts on “GP Power Tools Portal”

  1. 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.

    Like

    • Hi Curtis

      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.

      Thanks

      David

      Like

  2. Pingback: GP Power Tools - Public Beta is Available (Previously Support Debugging Tool) - Microsoft Dynamics GP Community

  3. 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.

    Like

    • Hi Dale

      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.

      David

      Like

  4. Pingback: GP Upgrade – “Please Select a Company” Message | Dynamics GP - Learn & Discuss
  5. Pingback: GP Upgrade – “Please Select a Company” Message - Microsoft Dynamics GP Community
  6. Pingback: Interesting Findings & Knowledge Sharing » GP Upgrade – “Please Select a Company” Message

    • Hi Jorge

      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.

      Thanks

      David

      Like

      • Hi David,

        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.

        Thanks,
        Jorge

        Like

  9. Hi Arthur

    Have a look at The Understanding Logging Modes series:

    http://blogs.msdn.com/b/developingfordynamicsgp/archive/2012/06/26/understanding-the-support-debugging-tool-series.aspx

    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.

    David

    Like

  11. Pingback: Tech Talk : GP Upgrade – “Please Select a Company” Message - Scope Systems

  12. 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?

    Like

    • Hi Jeff

      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.

      David

      Like

  13. 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.

    Like

  14. Pingback: Top 5 Insights for Microsoft Dynamics GP | Uncategorized
  15. Pingback: Top 5 Insights for Microsoft Dynamics GP | Blog, Dynamics GP, ERP

  16. Hi Dave,

    Does the latest release fix the screen rendering issue when using the prevent windows outside of the active section setting?

    thanks

    Like

  17. Pingback: DynamicAccounting.net | Microsoft Dynamics GP KB 857086 – You don’t have security privileges to this window. Contact your system administrator for assistance – Simplified – Microsoft Dynamics GP CommunityMicrosoft Dynamics GP KB 85
  18. Pingback: Microsoft Dynamics GP KB 857086 – You don’t have security privileges to this window. Contact your system administrator for assistance – Simplified – Microsoft Dynamics GP Community - DynamicAccounting.net - Dynamics GP Users - DUG
  19. Pingback: Microsoft Dynamics GP KB 857086 – You don’t have security privileges to this window. Contact your system administrator for assistance – Simplified – Microsoft Dynamics GP Community - Microsoft Dynamics GP Community

  20. Hi David,

    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.

    Like

  21. Hi 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.

    Thanks!

    Like

    • Hi Arthur

      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.

      GpPowerTools.Procedures.MbsScriptLoadDex.Invoke();
      GpPowerTools.Procedures.MbsRuntimeExecute.Invoke();

      David

      Like

  24. Hi David,

    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.

    Thank you,
    Scott

    Like

  25. Pingback: Unassigned Security Report & Superuser roles – JenKuntz.ca
  26. Pingback: Unassigned Security Report & Superuser roles - Microsoft Dynamics GP Community

  27. David,

    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”

    Thanks!
    Steven Vallarian

    Like

    • Hi Steven

      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.

      David

      Like

  28. Pingback: GP Tech 2018 – Day 1+ – JenKuntz.ca
  29. Pingback: GP Tech 2018 – Day 1+ - Microsoft Dynamics GP Community

  30. 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.

    Like

    • Hi Tracy

      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.

      David

      Like

  32. Pingback: Slow Login Performance After Installation | David Musgrave's Winthrop Development Consultants Blog
  33. Pingback: Slow Login Performance After Installation - Microsoft Dynamics GP Community

  34. Hello David,

    I am in the process of evaluating GPPT for our typical use. One area of particular interest is the trigger tools to replace VBA.

    For example:

    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.

    Any thoughts?

    Randy

    Like

Please post feedback or comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.