Hands On With the GP Power Tools: Available Tools

Winthrop DCBefore I move onto the features of the GP Power Tools, there will be a small number of posts, starting with this one, introducing the GP Power Tools and on the installation process.

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:

  1. Administrator Tools
  2. Developer Tools
  3. Database Tools

Essential system features that come with the first module you register:

  1. Capture and email 5 system logs in “One-Click”.
  2. Capture and email a full system status report and screenshots of all open windows in “One-Click”.
  3. Send emails from inside Dynamics GP even with no email client installed.
  4. Change Dex.ini and registry settings from inside GP, including making GP work well on high res monitors.

The key features of the Administrator Tools are:

  1. Avoid data entry errors! Company based colour schemes provide an immediate visual cue to which company is being used.
  2. Gain full administrative and audit control of your security system, including Deny-Based Security.
  3. Roll out Dex.ini setting changes to all workstations.
  4. Simplify troubleshooting by disabling third party products and customisation (including Visual Studio Addins and VBA).
  5. Users can customise window positions and sizes based on the how they use the system.

The key features of the Developer Tools are:

  1. Create, execute and publish scripts from inside Dynamics GP, using  Dexterity, Transact-SQL, Visual C# and Visual Basic.Net.
  2. Create triggers to schedule events, customise Dynamics GP, and debug issues by automatically capturing logs.
  3. Build custom Report Writer functions or custom Service Based Architecture (SBA) service procedures.
  4. Request parameters from users for scripts without needing any additional programming.
  5. Group triggers, scripts and parameter lists together into development projects for easy maintenance and exporting.

The key features of the Database Tools are:

  • Synchronise 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 minimise 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.
  • The tools contain two types of features; Standard Mode and Advanced Mode:

    1. Standard Mode features can be used safely by all users.
    2. 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.

    Hands On With the GP Power Tools: Series Index

    Winthrop DCAll of my Hands On With posts so far have been with Microsoft Dynamics GP itself, but I am now branching out and going hands on with the GP Power Tools by Winthrop Development Consultants.

    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 and is based on the product previously known as the Support Debugging Tool for Microsoft Dynamics GP.

    GP Power Tools is distributed by Mekorma.

    This series will open with the installation and basic configuration of the GP Power Tools and I will then move on to posts covering the features of the three sections into which the GP Power Tools is separated into:

    1. Administrator Tools
    2. Developer Tools
    3. Database Tools

    Each of these sections will have its own series index, with this post being the series index for these sub-series.

    Continue reading “Hands On With the GP Power Tools: Series Index”

    A Diary of reIMAGINE 2016: Part 19 – Conference Day 3/Leveraging GP Power Tools

    reIMAGINE2016The final session I attended was Leveraging GP Power Tools which was a joint session between David Musgrave and Mariano Gomez; Mariano did the introductions to each section, with David then doing the demonstration.

    I’m not as familiar with the GP Power Tools as I should be; I wasn’t that familiar with it’s predecessor, the Support Debugging Tool.

    This session was aimed mainly at the deveoper tools, but the guys did have time to cover tools in other parts of the program.

    GP Power Tools is sold by David via Mekorma, which is where Mariano works, with three modules being available for purchase separately but any one module and you get a System module included.

    Unfortunately, I was unable to say goodbye to the guys as their session ended at 1230 and I was scheduled to take some Association of Dynamics Professionals examinations at 1300 back at the Hilton Garden Inn.

    When I am back from vacation, I am going to have to get the latest verson of the GP Power Tools and spend some time going through them as, from what I saw, there are features from which not only Perfect Image, but also our customers, would benefit.

    While I was at the conference, I did have an email exchange with one of PI’s Development Consultants where I advised that they would probably find the GP Power Tools useful.

    Click to show/hide the A Diary of reIMAGINE 2016 Series Index

    GP Power Tools Now Available

    Winthrop DCWinthrop DC has now officially launched the GP Power Tools and which are available to purchase from Winthrop DC’s partner Mekorma.

    The GP Power Tools includes all of the functionality of the old Support Debugging Tool that they replace, but have new functionality, enhancements and bug fixes.

    There is a special introductory annual subscription price of US$365 (one free day every four years!).

    More information can be found on the GP Power Tools here.

    I am/was a Support Debugging Tool user; what now?

    If you were a Support Debugging Tool user on Microsoft Dynamics GP 2010 or 2013 then absolutely nothing needs to change. SUpport Debugging Tool will not expire.

    That said, you should consider upgrading to GP Power Tools for one major benefit: GP Power Tools is fully supported by Winthrop DC.

    While this may not sound like much, the old Support Debugging Tool, which was offered by Microsoft, was not supported at all (not even by Microsoft).

    The Future Of The Support Debugging Tool

    Winthrop DCI am slightly behind the times with this post as this news is a few weeks old, but I have been busy and am now trying to catch up. When David Musgrave was working for Microsoft he wrote the Support Debugging Tool which contained some very useful functions. I did wonder what the future held for it when he left Microsoft last year, but he posted a while ago that he had negotiated an exclusive agreement with Microsoft which allows him to continue work on and release the tool.

    There will be some changed to the Support Debugging Tool under this agreement. Most noticeable is the fact that it will now be called GP Power Tools.

    GP Power Tools will be initially released for the following Microsoft Dynamics GP versions:

    • v11.0: Microsoft Dynamics GP 2010
    • v12.0: Microsoft Dynamics GP 2013 and GP 2013 R2
    • v14.0: Microsoft Dynamics GP 2015

    There is going to be some changes to the functionality when GP Power Tools is launched:

    • New simpler Navigation with menus and area page
    • Database Validation, to ensure that your upgrades work
    • Numerous enhancements and the odd bug fix
    • And lots more….

    Another change is that GP Power Tools will now be available via an annual subscription for each customer site at the special introductory price of US$365.00. That’s a dollar a day, and every four years you will get a day for free.

    For now continue to use the free Support Debugging Tool for Microsoft Dynamics GP 2010 and GP 2013 (inc. GP 2013 R2) which is available from http://winthropdc.com/SDT.

    Stay tuned here or to the WInthrop DC blog for more information on when to upgrade to GP Power Tools for continued support and improved functionality.

    Those of you on Microsoft Dynamics GP 2015 will need to be patient for a while longer and wait for the release of GP Power Tools.