#GPPT GP Power Tools: What’s in the Administrator Tools module?

David Meego - Click for blog homepageThis is the third article in the #GPPT GP Power Tools: What’s in each module series? of articles.

It covers what is included in the Administrator Tools module. This module is a must for all Microsoft Dynamics GP sites as it makes working with and administering Dynamics GP simpler, easier and just better.


The Administrator Tools module contains features to improve the usability of Microsoft Dynamics GP for all users as well as making the tasks of administering Dynamics GP much simpler and easier. It includes tools to help with: finding resource information and data; manipulating, reporting and enhancing Application Security; and troubleshooting issues.


Here is a quick summary of the benefits:

  • 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.
  • Roll out Dex.ini setting 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.


Below is a list of the features for this module.

The following key is used to denote whether the feature is a Standard Mode (User level) feature (unmarked) or an Advanced Mode (Administrator level) feature and to what build of GP Power Tools the feature was added in parenthesis.

  • (A) Advanced Mode Feature

Resource Information

This is the built-in Resource Description windows on steroids. You can find information on any resource or security object in the system from forms, windows, tables, fields, reports, procedures and functions to posting permissions and document access. Just type in or use the lookups to enter what you know and all the rest of the data will be located for you. Use the interactive mode to click on a field on a window and have the information displayed. It can even display parameter lists for most functions and procedures when in script mode.

Resource Information 2

Resource Finder (28)

The Resource Finder window takes all the capabilities of the Resource Information window and focuses on the ability to locate exactly where in the database tables specific data is stored. It offers searching by Window Field, Table Field or Table Data.

Resource Finder 1.png

Security Profiler

Track every application level security system request made while the window is open and see the results. You have the option to open the Security Profiler automatically when an access denied error occurs to capture the error as it happens. Export and import logs and use this window to look up Security Information. Create or update Security Tasks and Roles by performing actions and capturing the security needed.

Security Profiler

Security Information

Look up the Security access for any user and company for any resource or security object in the application level security system. See how to grant access using the System nodes. See exactly what resources a Security Task, Security Role or User/Company has access to. See all the relationships between Tasks, Roles and Users and even check the SQL roles for users.

Security Information

Security Log (20)

Capture statistics about all application level security system access for all users and companies in the system. Understand exactly what resources users are using and how often they are using them. Create or update Security Tasks and Roles by reviewing the logged security and selecting the desired resources.

Build 28 adds detailed logging of every security event.

Security Log.png

Security Analyzer (21)

Look for application level security system issues with over 40 queries designed to find flaws in your security setup. Check for Tasks and Roles not used, users not setup, companies without security enabled. Using the data from the Security Log feature compare what users have access to versus what they are actually using and see if too much access has been granted to them. All queries have Summary, Filtered Detail and All Detail views.

Security Analyzer

Enhanced Security (22)

Easily deny access to individual resources and security objects on a per user per company basis without having to duplicate Security Tasks and Roles. Deny Based Security sits on top of the Security Tasks and Roles which grant access and provides a layer to deny access. Once applied Deny Based Security cannot be hacked by removing GP Power Tools. Also includes the ability to hide menu options that cannot be hidden by security settings or any other means.

Security Enhanced

Security Denied (22)

Shows a list of denied resources and security objects on a per user and/or per company or system wide basis without needing to look through the tree navigation of the Enhanced Security window.

Security Denied

Security Hidden (22)

Shows a list of hidden resources on a per user and/or per company or system wide basis without needing to look through the tree navigation of the Enhanced Security window.

Security Hidden

Administrator Settings (A)

Enable usability features such as company color themes (choose from over 100 built-in themes or make your own from 16.7 million colors), Company and User in window titles, extra width on the company login, preventing windows from opening outside of the visible desktop, password expiry warnings and system password memory. Also controls a number of GP Power Tools feature settings.

Build 28 adds support for Binary Stream’s Multi-Entity Management and per user color selection for color blind and vision impaired users.

Administrator Settings 1

Build 28 adds automatic closing of the login windows when left idle, preventing access until login has completed, and low drive space warnings.

Administrator Settings 2.png

Build 28 adds detailed Security Log tracking of every security event.

Administrator Settings 3

New for build 26 is User Setup Additional Information, User Activity Tracking including Maximum User logging and Automatic Logout.

Build 28 adds detailed User Activity tracking of every login/logout event, more options for User Setup Additional Information, and two additional options for Automatic Logout.

Administrator Settings 4.png

Dex.ini Configuration (A)

Roll out Dex.ini Settings to all workstations and servers in your system for both System level and User Level Dex.ini files without having to visit any of the machines. Can be used to clean up automatically created winspool entries, change OLEPath or remove last user details.

Dex_ini Configuration

Dictionary Control (A)

When troubleshooting issues, quickly and simply disable Dexterity based add on products and customizations without having to exit Dynamics GP or edit the Dynamics.set launch file. Disables triggers and custom windows without actually changing security data. Reorder or delete products in the Dynamics.set launch file simply and without risk of corrupting the file. Also can disable Visual Basic for Applications (VBA) and Visual Studio Tools Addins after restarting the application.

Dictionary Control

Company Login Filter (22) (A)

For systems which have different customizations or products loaded for different companies such as multi-nationals or different report layouts, you can now control which companies can be accessed when launching Microsoft Dynamics GP from a particular folder or using a particular Dynamics.set launch file.

Build 28 adds the option to hide the “Remember this company” checkbox.

Company Login Filter Setup

Window Position Memory (22) (A)

Now any window in the entire Microsoft Dynamics GP application can remember the size, position and state of the window on a per user basis. Each user can decide how they want the windows positioned and GP Power Tools remembers. Comes with the main transaction and maintenance windows already added, but you can add any other windows to the list.

Build 28 adds the option to flag windows as resizable when the system identifies the window as not resizable. This will allow the size to also be remembered.

Window Position Memory.png

User Activity Log (26) (A)

You can enable User Activity Tracking from Administrator Settings to track users login and logout activity as well as Automatic Logout statistics. Understand your users time logged into the application, which companies they use and how often they log in.

Build 28 adds detailed logging of every login/logout event, better filtering options as well as tracking by Machine ID.

User Activity Log

Once enabled, User Activity Tracking also captures the daily maximum sessions counts on a system, per user and per company basis and provides a graph of the data. For each maximum tracked you can see exactly what sessions were active when the maximum was reached.

User Activity Log Max Users

Login Limits (26) (A)

Using the Login Limits window you can control exactly how many sessions a user can log into and which companies they can be logged into at any one time. You can also control how many sessions can log into each company to ensure that there are always licenses available when needed.

Build 28 adds the ability to reserve a license for a specific user to ensure they can always login.

Login Limits.png

Launch File Configuration (27) (A)

Roll out Dynamic.set launch file changes to all workstations in your system without having to visit any of the machines. Uses rules to make specific changes when needed.

Launch File Configuration

Dynamic Product Selection (27) (A)

Allow users to dynamically select which version of a window or report they wish to use without needing to change security or login as a different user. Users can select from original, modified, alternate or modified alternate resources.

Dynamic Product Selection

Website Settings (28) (A)

This window allows the websites used for the Homepage Connect object and the Intelligent Cloud Insights object to be changed for all workstations on a system without needing Dex.ini settings or changes with Modifier.

Website Settings

Product Version Validation (28) (A)

This window tracks the latest product dictionary build numbers for a system along with the details of the product dictionaries installed on each workstation.

Product Version Validation.png

I hope this helps your understanding of GP Power Tools and what it can do for you. If you want more details than provided in this series, please download the GP Power Tools User Guide manual, which contains 592 pages of detailed description of every feature in the product.

You can also download and install the product, NFR (Not for Resale) Keys are available for partners and a free 30 day trial is available for customers (just install and follow the on screen instructions). GP Power Tools can also work with no registration keys if only the sample company is installed.

I firmly believe that all Microsoft Dynamics GP sites globally should have GP Power Tools installed, and the articles in this series will explain why.


12-Feb-2019: Updated after the release of build 26 of GP Power Tools.
24-May-2019: Updated after the release of build 27 of GP Power Tools.
11-Aug-2020: Updated after the release of build 28 of GP Power Tools.

This article was originally posted on http://www.winthropdc.com/blog.

6 thoughts on “#GPPT GP Power Tools: What’s in the Administrator Tools module?

  1. Hi David,
    Suggesion: Please allow automatic login to the company if the Company Login filter has only one company. Or allow Remember company to work per folder/ini.


  2. Good Morning David,

    I’m trying to export new Task that I created in PROD to TEST company. I dont see any straight forward method.so I assigned it to an user and exported the user security, but I dont see any import option. I think you replied it is possible, on GP Ideas portal. I looked at GPPT doc but I couldnt find anything. Is this still possible?

    Thank you!


Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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