#GPPT Why every GP site needs GP Power Tools – Administrator Tools Pt. 1

GP Power Tools is the premier tool for administrators, consultants and developers of Microsoft Dynamics GP systems to enhance the usability, support and customize their ERP system.

This series will cover each of the modules of GP Power Tools and explain to potential users and existing users why every Dynamics GP site needs GP Power Tools.

If you already have GP Power Tools, but don’t have all the modules registered, this series will help you understand why you should register the other modules.

For other the other articles in the series, click here:

• #GPPT Why every GP site needs GP Power Tools – Series Introduction

For an understanding of what is in this module, click here:

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

Administrator Tools

Here are some of the benefits for the Administrator Tools module (part 1 of 2):

Where is that field stored? What does this SQL table do?

• Answer these and many more questions with the Resource Information window.
• Use lookups or type in what you know to search.
• Works for Windows, Tables, Reports, Security objects or Scripts.
• Displays all matching resources.

Want to use SQL for Security reports?

• Want to use the Resource Descriptions table (SY09400) in your SQL reports, but it does not contain all security resources?
• GP Power Tools automatically adds the resources missed by core Dynamics GP.

Want an alternative to POWERUSER?

• The Dynamics GP Security Role POWERUSER bypasses security to give access to all resources.
• Security reporting does not show resources granted to a POWERUSER.
• GP Power Tools creates and maintains a SUPERUSER Security Role to use instead of POWERUSER.

What caused that Security Error?

• GP Power Tools adds resource details to the Security dialog.

• Security Profiler tracks details of all security events.

How was Security access granted?

• Security Information shows current status and what changes can be made to grant or remove access.
• Security Information can show who will be affected by changes to Security Tasks or Roles.

Satisfy auditors with access reports

• Show the Security Operations that Users, Roles and Tasks have access to.
• Export the data to load into Excel.

Remove access without duplication

• Removing access from one window without affecting other users normally requires duplication of Security Tasks and Roles.
• Deny Based Security allows Operations to be denied on a User and Company basis.

Need to know what users access?

• Security Logging captures statistics of exactly what users access in Dynamics GP.
• The data can be printed or exported for review in Excel.

• To view all access to the selected resource click Details

Create Security Tasks by example

• Create or update Security Tasks based on data recorded from the Security Profiler or Security Log.

Analyze Security Data for issues

• Security Analyzer has 40 queries which look for known issues with security settings.
• Use Security Log data to compare security access against what is actually used.

Entered data into the wrong company?

• Company Color Themes reduce data entry errors by providing a visual cue.
• Company ID and User ID on the title bar simplifies switching between multiple instances of GP.

Do you have long company names?

• GP Power Tools can expand the Company Name selection drop down list.
• GP Power Tools also remembers the last company used.

Re-order Company drop down list

• Re-order the list of companies by Company Name, Company ID, Company Database or use a custom defined order.
• Put the most used companies at the top of the list.
• Add the Company Database Name as a prefix or suffix to the Company.

Ever had a SQL Password expire while logged in?

• GP Power Tools can provide warnings of impending SQL password expiry.

• Avoids losing access to SQL mid session.

More Information

For more information check out the following links:

• GP Power Tools product webpage
• GP Portal Tools Portal
• GP Power Tools Benefits Presentation
• #GPPT GP Power Tools: What’s in each module series?
• #GPPT FAQ: What features belong to each GP Power Tools Module?

Don’t forget you can install anytime and activate the free 30 day trial period for any of the modules. If you have some modules registered, you already have preview access to the other modules, but activating the free trial period will give you full access.

Enjoy

David

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