Click here to
Subscribe to
our Newsletter
At the end of last year, Microsoft Dynamics GP 2016 R2 was released.
If you have not already installed/updated to this build, Microsoft has released lots of information about the new features in blogs, documentation and video forms.
If you follow this blog, I am sure you already know that GP Power Tools has been released through my distribution and support partner, Mekorma, for Microsoft Dynamics GP 2010, GP 2013 and GP 2015.
The question I am hearing now from existing Support Debugging Tool sites is:
“Now that GP Power Tools is available, what happens to my Support Debugging Tool installation?“.
Over the past few weeks I have been posting a number of “What’s New” articles for GP Power Tools build 20.
If you have missed any of them, this article has all the links to the articles, so you can read them at your leisure.
GP Power Tools is the first product that I have released over the years to have a proper installation program. As the complexity of the products increases and there are more files involved than a single Dexterity chunk (.cnk) file, it became necessary to use an installer rather than just a zipped archive file.
GP Power Tools has a number of DLL files as well as a text file with version history, a license document and the user guide PDF.
Microsoft Dynamics GP 2015 added Service Based Architecture (SBA) and .Net Interop functionality to the application. Service Based Architecture allows the Dexterity developer to write global procedures and use meta data to expose these service enabled procedures to the outside world as REST Web Services.
GP Power Tools provides five Service Enabled Procedures which can be used to execute custom business logic created in the Runtime Execute window. These services can be called as Web Services, from Visual Studio Tools using Visual C# or Visual Basic.Net, or from any Dexterity product dictionary using sanScript.
The Database Validation feature was previously demonstrated but never released. GP Power Tools now releases Database Validation for general availability.
Database Validation is a tool designed to ensure that the user, company and table settings at the SQL Server level match what the Microsoft Dynamics GP application says they should be.
One of the most popular features of the now discontinued Support Debugging Tool was the Company based Color Schemes. This feature allowed administrators to specify a different color scheme for each Microsoft Dynamics GP company.
GP Power Tools takes this functionality and enhances it to make it more powerful and easier to use.
GP Power Tools is now released and available via my distribution and support partner, Mekorma.
Continuing on with the What’s New series, today’s article will have a quick look at some of the usability enhancements to the Microsoft Dynamics GP application.
One request that I have heard a number of times is for a method to expose scripts written using Runtime Execute or SQL Execute to normal users.
Because these windows are Advanced Mode features designed for administrators to use, they require SQL Server sysadmin or dbo privileges as well as application level security and the System password (if used) to access.
The Administrator level (Advanced Mode) features of GP Power Tools require application level security, SQL Server sysadmin or dbo status and the System Password (if one is configured) to access them.
So what happens if you want a user to be able access a feature and can provide the security required at the application level and SQL Server level, but you don’t really want to provide them with the Microsoft Dynamics GP System password?