Page 1 of 7812345678910...2025303540...Last »

#GPPT FAQ: What features belong to each GP Power Tools Module?

David Meego - Click for blog homepageWith the release of Build 21 of GP Power Tools for Microsoft Dynamics GP last week, the product has now been broken up into three modules which can be registered separately. This allows users to only purchase the parts of the product that they want to use.

Below are a number of Frequently Asked Questions (FAQ) with their answers:

Why was GP Power Tools separated into modules?

When GP Power Tools build 20 was first released in August 2015, the annual subscription was priced with a special introductory offer. It was always known that this offer undervalued the product, but it was offered to help the transition from the previously free (read as subsidized by Microsoft) Support Debugging Tool.

With the release of GP Power Tools build 21 in July 2016, the special introductory offer finished and the pricing model for the product was changed. GP Power Tools has many features and our research showed that some features were not being used by some users. To allow users to only pay for the features they wanted to use, the product was broken into three modules:

  • Administrator Tools
  • Developer Tools
  • Database Tools

What is the function of each module?

Below is the summary descriptions of what each module does:

Administrator Tools

  • Resource Information, Security Information, logging and Analysis, Company Color schemes, and Usability enhancements, Automated Dex.ini configuration, Dictionary Control troubleshooting tool.

Developer Tools

  • Scripting for Dexterity, SQL Server, Visual C# and Visual Basic.Net. Triggers for both debugging and customisation. User interaction with scripts via Parameter Lists. Custom RW functions and custom Service Based Architecture web services.

Database Tools

  • Database Validation to check User and Company settings as well as Table structures. Export and Import of data via XML files.

What features are available to all modules?

The following System Module features are available when any module is registered:

  • Manual Logging, capturing screenshots, email and workstation Dex.ini settings

Are there still Standard mode and Advanced mode features?

Yes, the features are still divided into standard mode and advanced mode features.

Standard Mode features are “user level” features that are safe for any user to use. They only require standard application level security to access.

Advanced Mode features are “administrator level” features that should only be used by administrators, developers or partner consultants. They require application level security as well as sysadmin or dbo privileges on system and company databases at the SQL level. They will also need to know the GP System Password (or GP Power Tools Administrator Password) if one is in use.

What windows are contained within each module?

To be more specific, below is a list of the windows that are contained in each module:

Administrator Tools

  • Resource Information
  • Security Profiler
  • Security Information
  • Security Log*
  • Security Analyzer**
  • Administrator Settings (A)
  • Dex.ini Configuration (A)
  • Dictionary Control (A)

Developer Tools

  • Automatic Debugger Mode Status
  • Runtime Executer*
  • SQL Executer*
  • .Net Executer*
  • Automatic Debugger Mode Setup (A)
  • Runtime Execute Setup (A)
  • SQL Execute Setup (A)
  • .Net Execute Setup* (A)
  • Parameter Lists** (A)

Database Tools

  • XML Export (A)
  • XML Import (A)
  • Database Validation* (A)

System Module (available once any of the three modules are registered)

  • GP Power Tools Logging Control
  • Capture Screenshots
  • Send Email
  • Dex.ini Settings
  • Administrator Password Setup* (A)
  • Logging Settings** (A)
  • Email Settings** (A)
  • Configuration Export/Import

Additional windows (available at all times)

  • About GP Power Tools
  • GP Power Tools Feedback Survey
  • Configuration Maintenance (A)
  • Setup Backup and Restore* (A)

(A) Advanced Mode Feature
* New for Build 20 of GP Power Tools
** New for Build 21 of GP Power Tools

How does the menu navigation relate to the modules?

Below is a screenshot of the GP Power Tools Area Page showing the windows on the menus and the modules they belong to:

GP Power Tools Area Page Navigation 3
Click for full size image

Note that windows under the Transactions, Reports and Inquiry sections are all standard mode features.

Can I trial features I am not registered for?

Yes, you can. Once GP Power Tools is registered (the System Module is registered when any of the three modules is purchased), you can open a window for a module you do not have registered. A dialog will open and tell you that the window is not registered and offer to open the window in Preview mode.

Once the window is open in Preview mode (“Preview:” will be shown in the window title), you will be able to use the window with limitations. Some functionality will be disabled while the window is in preview mode. For example: You can create and edit scripts but you cannot execute them.

If you want to trial the feature with full functionality, please contact Mekorma (sales@mekorma.com) to organise a 30 day trial period of the relevant module.

Can I use GP Power Tools without registration in the sample company?

Yes and No.

GP Power Tools is a system based module which means that most of its functions are available regardless of which company you are logged into at the time. Because of this, it is not possible to just allow it to be registered when in the sample Fabrikam company.

If you use GP Power Tools on a system where the ONLY company installed is the sample company, then you will be able to use its features in Trial Mode. As soon as another company exists, you will need to be registered.

I purchased GP Power Tools with the special introductory price, what modules do I get now?

All sites that took advantage of the introductory offer for build 20, will be registered for all three modules on build 21. The first subscription renewal will also be at the same special price.

For the second subscription renewal, the site can decide if they wish to keep all three modules registered or if they would like to change which modules they have registered. They would then pay the current subscription price for the modules they decide to keep.

 

Hope this explains everything.

David

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

Filed under: Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP Power Tools, GPPT

More:
#GPPT FAQ: What features belong to each GP Power Tools Module?

July 5, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 49

#GPPT GP Power Tools build 21 released

David Meego - Click for blog homepageI am pleased to announce that the next build of GP Power Tools for Microsoft Dynamics GP (GPPT) is now available for download.

GP Power Tools was previously known as Support Debugging Tool (SDT), which was discontinued in October 2014. If you are still using the previous product, please upgrade to the supported and much better GP Power Tools product.

This build adds support for Microsoft Dynamics GP 2016 as well as separating the product into three modules and adding a host of new features and enhancements to the tools. Details on the changes will be posted on this blog in an upcoming “What’s New” series.

Build 21 of GP Power Tools is available for the following Microsoft Dynamics GP versions:

  • Microsoft Dynamics GP 2010 (v11.0),
  • Microsoft Dynamics GP 2013 and GP 2013 R2 (v12.0),
  • Microsoft Dynamics GP 2015 and GP 2015 R2 (v14.0)
  • Microsoft Dynamics GP 2016 (v16.0).

GP Power Tools will now be 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

  • Resource Information, Security Information, logging and Analysis, Company Color schemes, and Usability enhancements, Automated Dex.ini configuration, Dictionary Control troubleshooting tool.

Developer Tools

  • Scripting for Dexterity, SQL Server, Visual C# and Visual Basic.Net. Triggers for both debugging and customisation. User interaction with scripts via Parameter Lists. Custom RW functions and custom Service Based Architecture web services.

Database Tools

  • Database Validation to check User and Company settings as well as Table structures. Export and Import of data via XML files.

The following System Module features are available when any module is registered:

  • Manual Logging, capturing screenshots, email and workstation Dex.ini settings

The primary new features for build 21 are improved Company Color scheme functionality, Parameter Lists for requesting information to be used in scripts from the users and the Security Analyzer tool. More details on these and other enhancements will be posted soon. The User Guide manual has grown from 257 to 275 pages.

Note: With the release of build 21 of GP Power Tools, the special introductory price offered since the release of build 20 has now finished.

Version History

Below is a summary of the changes made for releases 11.00.0021, 12.00.0021, 14.00.0021 and 16.00.0021, I have divided them into logical sections:

System Wide

  • Update Registration System to separate the product into modules.
  • Allow Preview Mode for windows when GP Power Tools system module is registered and additional modules are not.
  • Fixed issue where Menu and Area Page Navigation was not active immediately after install and required a restart of Dynamics GP.

Settings (Logging Settings, Email Settings and Administrator Settings)

  • Moved Email settings from Email 1 and Email 2 tabs of Administrator Settings window to new Email Settings window.
  • Moved Logging settings from Administrator Settings window to new Logging Settings window.
  • Re-organized settings on Administrator Settings windows to more logical tabs and improve visual layout.
  • Added “Disable logging of Security Errors and Warnings to the user/company log files” option to Administrator Settings window.
  • Added option to control how Settings Applied Message is displayed to Administrator Settings window.
  • Added “After Login warn user when password is due to expire (SQL Server 2008 or later)” option to Administrator Settings window. Based (with permission) on idea from Michael Johnson who used to work with Straight Arrow Consulting.
  • Added Field Background and Scrolling Window Background to Company Color Schemes in Administrator Settings window.
  • Added Automatic changing to Text color when backgrounds are dark to Company Color Schemes in Administrator Settings window.
  • Added additional Grey Themes and new Mid, Dark and Inverted Themes to Company Color Schemes in Administrator Settings window.
  • Added Red, Green, Blue and All color spinner controls with Selected checkboxes for easy color manipulation in Adminstrator Settings window.
  • Total built in themes for Company Color Schemes is now 92 themes.
  • Updated Administrator Settings window to support Custom Color Themes.
  • Added Custom Color Themes Setup window to allow creation and editing of custom color themes.

Dex.ini Settings

  • Improved Dex.ini Settings window to improve visual layout.
  • Updated Dex.ini Settings window to add fields for WindowMax, WindowPosX, WindowPosY, WindowWidth, WindowHeight Dex.ini settings.
  • Updated Dex.ini Settings window to add control of OLEClose Dex.ini setting, which can improve performance when exiting Dynamics GP.

Database Validation

  • Added Activity Log Report to Database Validation when the window is closed instead of writing to User/Company Log files.
  • Added Mark All and Unmark All buttons to lists on User & Company Fix and Tables Fix windows of Database Validation.
  • Added Option to remove SQL Logins from Database Validation window, so SQL Logins and Database Users can be recreated.
  • Added Initializing Database Validation Progress window to Database Validation.

SQL Execute

  • Added All Company feature to SQL Execute window to allow a single query to be executed against multiple companies in the system.
  • Added Export to File and Email option to the SQL Executer window to allow export of query results.
  • Added Resizing of SQL Execute and SQL Executer Column Widths to ensure Column Label is readable when data for the column is narrow.

Security

  • Added option to Display only Selected Users for the User and Company views in the Security Information window.
  • Added support for OData Security Objects to Resource Explorer and Resource Information windows for version 16.00 onwards.
  • Added support for OData Security Objects to Security Information, Security Profiler and Security Log windows for version 16.00 onwards.
  • Added Security Analyzer window to analyze application level security and provide data to administrators.
  • Added background processing to Security Analyzer window along with query filtering when double clicking.
  • Added a confirmation dialog to Security Analyzer window when the query will return more than 5000 rows.

Parameter Lists

  • Added Parameter Lists and Color Themes to Configuration Maintenance window.
  • Added Parameter Lists and Color Themes to Configuration Export/Import window.
  • Added Parameter Lists and Color Themes to Setup Backup and Restore window.
  • Added Parameter List Maintenance window to allow creation and editing of Parameter Lists.
  • Added Parameter List Placeholder Lookup window to allow select of placeholders to insert into scripts.
  • Added Parameter List functionality to Runtime Execute and Runtime Executer windows.
  • Added Parameter List functionality to SQL Execute and SQL Executer windows.
  • Added Parameter List functionality to .Net Execute and .Net Executer windows.
  • Added Parameter List functionality to Automatic Debugger Mode Setup window for non-logging Triggers.
  • Added Parameter List functionality to called sub scripts for Dexterity, SQL Server, Visual C# and Visual Basic.Net.

Miscellaneous

  • Allow Form Menu and Context Menu triggers to pull focus to ensure all change scripts are executed prior to the trigger script executing.
  • Improved information provided to dialogs and logs when compile time errors occur.
  • Added Menu Detail Expansion pane to Menu Explorer window to show Dexterity command details and custom menu names.
  • Added Security Filter for User and Company to Menu Explorer window when opened from Security Information window.
  • Added Additional Error message details to Send Email and the Email engine.

More Information

For more information and download links, please see the GP Power Tools Portal page:

You can also look at the GP Power Tools pages on the Winthrop Development Consultants and Mekorma sites:

Please post your feedback as comments on this article or using the GP Power Tools Feedback Survey on what you think of this build and what you would like to see in the future.

Thanks to everyone involved with this release, especially the team at Mekorma, the beta testers (including special thanks to Robert Cavill for putting the code through its paces) and the Microsoft Dynamics GP MVPs.

A final massive thank-you to my family who have put up with me being in “programming mode” for the last few months.

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, 2016, Dynamics, GP, GP Power Tools, Microsoft, News, Products, Support Debugging Tool Tagged: GP 2010, GP 2013, GP 2015, GP 2016, GP Power Tools, GPPT, News, SDT, Support Debugging Tool

Excerpt from:
#GPPT GP Power Tools build 21 released

July 1, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 39

What?! Referential Integrity Checked on a Clear Data Table.

I learned something today from Lawrence Reid at ConexusSG that impacted the Clear Data file maintenance utility. They set up some National Accounts and then wanted to clear the Customer Master table. Once you create National Accounts, none of the customers with children will be cleared. After you run the utility you will get an error on your report that states:

You can’t clear data in the parent table RM Customer MSTR until you have cleared data in the child table RM National Accounts Master.

Wow! I’d never seen that before. It does delete all of the customers with no ‘child’ companies, but any customers with children are left intact.

Until next time,

Leslie Vail

See original article:
What?! Referential Integrity Checked on a Clear Data Table.

February 26, 2016 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 106

Happy New Year 2016

To the GP Community:

Happy New Year 2016!

This year is slated with lot of interesting releases for GP impending. I am absolutely as excited as all of you.

Let’s wish this year be an excellent year for Dynamics GP and its success.

VAIDY

Filed under: #MSDYNGP, New Year, Off-Topic, Uncategorized

See the original post:
Happy New Year 2016

January 1, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 167

Changing SQL Server Collation After Installation

I had a necessity to change the collation of newly created SQL server instance from CI_AS to CP1_CI_AS.

To brief you about why this was needed, I wanted to test upgrade GP from version 2010 RTM to 2010 SP3. In order to that, I created a new SQL server instance with collation SQL_Latin1_General_CI_AS. I restored GP 2010 RTM backups on to this newly created server. But later realised that GP databases that I got for 2010 RTM was of collation SQL_Latin1_General_CP1_CI_AS.

There were two options. Either I must change the collation of databases to CI_AS or I must change the server collation itself to CP1_CI_AS. Later seemed to be a better option (for some reason, I wanted to retain the collation on the databases). I was left with changing the collation of server instance.

That’s when I got this link: Changing SQL Server Collation After Installation

I was worried about the whole process but this post saved me loads of time and sweat. Changing the collation was a breeze.

Anybody out there who is looking for the best possible method to change server collation, above is the post you would want to read.

VAIDY

Filed under: #MSDYNGP, Dynamics GP, SQL Server

Original post:
Changing SQL Server Collation After Installation

October 6, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 198

OFF-TOPIC: Windows 10 and Microsoft File Transfer Manager (FTM) Issues (UPDATE)

Originally posted on Dynamics GP – Learn & Discuss:

This is my first post from Perth, WA. It’s been an excellent journey and so far so good. More about my Perth life later.

This is something that I never experienced before. When you download any file from PartnerSource or CustomerSource, Microsoft would let you do that only through it’s File Transfer Manager program. If you have that installed already, any download initiation would first invoke this program and then let you set the path/folder to take in that download and etc.

However, when I tried to do that from my new Windows 10 machine, the FTM did not open. I tried to figure that out, but later remembered this same issue happening on my Windows 8.1 machine.

Basically, from Windows 8.1, for some reason, calling the FTM from Internet Explorer worked only on a 32 bit Internet Explorer.

Looks like Microsoft has not fixed that yet. If you are wondering why your FTM…

View original 55 more words

Filed under: Uncategorized

See the original article here:
OFF-TOPIC: Windows 10 and Microsoft File Transfer Manager (FTM) Issues (UPDATE)

October 5, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 238

OFF-TOPIC: Windows 10 and Microsoft File Transfer Manager (FTM) Issues

This is my first post from Perth, WA. It’s been an excellent journey and so far so good. More about my Perth life later.

This is something that I never experienced before. When you download any file from PartnerSource or CustomerSource, Microsoft would let you do that only through it’s File Transfer Manager program. If you have that installed already, any download initiation would first invoke this program and then let you set the path/folder to take in that download and etc.

However, when I tried to do that from my new Windows 10 machine, the FTM did not open. I tried to figure that out, but later remembered this same issue happening on my Windows 8.1 machine.

Basically, from Windows 8.1, for some reason, calling the FTM from Internet Explorer worked only on a 32 bit Internet Explorer.

Looks like Microsoft has not fixed that yet. If you are wondering why your FTM didn’t work, this is the reason. Open your IE 32 bit mode and then try to download the file that you wanted to.

VAIDY

Filed under: File Transfer Manager, FTM, Off-Topic, OS, Troubleshooting, Windows, Windows 10

Read the original:
OFF-TOPIC: Windows 10 and Microsoft File Transfer Manager (FTM) Issues

September 14, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 235