Welcome to GP Power Tools for Microsoft Dynamics GP for versions GP 2010 (v11.0), GP 2013 (v12.0 including R2) and GP 2015 (v14.00 including R2).
This first release of GP Power Tools will be build 20 and includes many new features, enhancements to existing features as well as rebranding as a Winthrop Development Consultants product.
GP Power Tools is proudly distributed and supported by Mekorma. For more details on some of the new features please see the What’s New Series on this blog.
Below is a summary of the changes made for releases 11.00.0020, 12.00.0020 and 14.00.0020, I have divided them into logical sections
Conversion to GP Power Tools
- Rebranded as Winthrop Development Consultants GP Power Tools for Microsoft Dynamics GP.
- Converted setting storage from using Debugger.xml file to SQL Tables providing simpler setup and faster performance.
- Added Menu Navigation and Area Page Navigation.
- Updated Menu Navigation from GP Power Tools Logging Control window.
- Removed Advanced Mode Setting which hid Advanced mode features, Security and SQL permissions control access.
- Added Administrator Controlled Shared Folder for logs and export files into Administrator Settings window.
- Removed Administrator Controlled Dex.ini Settings from Dex.ini Configuration window.
- Added Windows Installer to install and uninstall files.
- Added Setup Backup and Restore window to allow for the export and importing of the Debugger.xml file.
- Added Database Validation Feature.
- Added .Net Execute window to allow C# and VB.Net scripts to written and executed with Microsoft Dynamics GP.
- Added Helper Functions for loading and executing .Net scripts from Runtime Execute and Automatic Debugger Mode Triggers.
- Updated .Net Execute window to automatically add Imports or using statements and add references for new dictionaries.
- Added Read-only .Net Executer window for running published scripts.
- Added Read-only Runtime Executer window for running published scripts.
- Added Read-only SQL Executer window for running published scripts.
- Added option to expand the Company Name drop down list on the Company Login window to Administrator Settings window.
- Added Exit After Processes menu option to Microsoft Dynamics GP application menu.
- Added User Defined Custom Service Procedures to Service Based Architecture and Visual Studio Tools.
- Added Security Activity Tracking setting to Administrator Settings window.
- Added Security Log window to review data captured by Security Activity Tracking.
- Added option to use separate Administrator Password instead of System Password.
- Added Table Type column into the Table Explorer window of the Resource Explorer.
- Added Field Context Menu Trigger Type to Automatic Debugger Mode Setup window to allow custom context menus with up to 10 items.
- Added Published checkbox to Runtime Execute and SQL Execute windows.
- Added Custom Script Purpose drop down list to Runtime Execute window to select specific script templates.
- Added rw_ReportStart, rw_ReportEnd, rw_TableHeaderString, rw_TableHeaderCurrency, rw_TableLineString, rw_TableLineCurrency to Custom Script Purpose drop down list on Runtime Execute window.
- Added Custom Service Procedures ServiceCreateCustom, ServiceDeleteCustom, ServiceGetCustom, ServiceUpdateCustom, ServicePostCustomto Custom Script Purpose drop down list on Runtime Execute window.
- Added SmartList Builder GoTo procedures FillRunProcedureList, GetRunProcedureParameterCount, GetRunProcedureParameterName to Custom Script Purpose drop down list on Runtime Execute window.
- Updated Names and Table Buttons on Runtime Execute window to use a single Names Button Drop List.
- Added Reports and Scripts (Procedures & Functions) to Names Button Drop List on Runtime Execute window.
- Added Scrollbar Width Override options to Dex.ini Settings window using MaxSWScrollbarSize Dex.ini Setting.
- Added support for Service Enabled Procedures to Resource Information window.
- Added Script Explorer with Service Enabled Procedure Support to Resource Explorer.
- Added Service Enabled Procedure support to automatic creation of records in syCurrentResources (SY09400) table.
- Added Service Enabled Procedure support to Security Information, Security Profiler and Security Log windows.
- Added support for modified forms dictionaries to Runtime Execute window.
- Added option for modified forms dictionaries to Helper Functions window.
- Added MBS_Runtime_Execute_Modified helper function global procedure.
- Updated Administrator Settings window to allow setting of color themes for any company without having to switch company.
- Updated Administrator Settings window to allow optional selection of users for company based color themes.
- Updated Administrator Settings window to increase the number of company based color themes from 16 to 52.
- Updated Company based color themes to use third color on List Header 1 when Toolbar is unused by Ribbons.
- Updated Resource Explorer window to identify parent window for scrolling windows for .Net Execute window.
- Fixed SQL Error when running SQL Profile Trace functionality on a SQL Server with Binary sort order.
- Fixed issue when Resource Information form view automatic display would identify a window incorrectly.
- Fixed Security Task creation from Security Profiler and Security Log windows to not created records for excluded resources.
- Fixed Error on GP 2015 Dexterity Runtime Options window by replacing it with a custom Script Options window.
- Fixed issue where Un-install and Dictionary Control window where unable to obtain write access to the Dynamics.set launch file.
- Added Fix for bug in Script_GetSystemProperty() function to Resource Explorer window (for v14 only).
- Added Fix for bug in Script_GetSystemProperty() function to Resource Information window (for v14 only).
- Added Fix for bug in Script_GetSystemProperty() function to Microsoft Dynamics GP Security Task Entry window (for v14 only).
For more information, 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 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 four months.
This article was originally posted on http://www.winthropdc.com/blog.