#GPPT GP Power Tools Build 28.7 hotfix released

David Meego - Click for blog homepageOver the last few months I have been really busy with some non work issues (such as preparing to sell my house), but have also been making some really awesome enhancements and fixes to the Administrator Tools, Developer Tools and Database Tools modules of GP Power Tools and this hotfix makes them all available to the community.

It is highly recommended that all sites running GP Power Tools install the latest code on all workstation and servers where Microsoft Dynamics GP is installed.

Build 28.7 (Hotfix 6) of GP Power Tools is available for the following Microsoft Dynamics GP versions:

  • Microsoft Dynamics GP 2013 and GP 2013 R2 (v12.0)
  • Microsoft Dynamics GP 2015 and GP 2015 R2 (v14.0)
  • Microsoft Dynamics GP 2016 and GP 2016 R2 (v16.0)
  • Microsoft Dynamics GP 2018 and GP 2018 R2 (v18.0)
  • Microsoft Dynamics GP Modern Lifecycle (v18.2)
  • Microsoft Dynamics GP Modern Lifecycle (v18.3)

The build 28.7 hotfix includes the following changes:

Library Updates

  • Updated WinthropDC.GpPowerToolsVC.dll to add support for array parameters in the parameter identification code.
  • Installer built with updated QLMLicenseLib.dll without any dependencies on Log4Net.dll and so avoids crashing issue caused by old DLL files.

Dex.ini Settings

  • Added Dex.ini Setting SuppressChangeDateForce to Dex.ini Settings window to force the User Date to change when the Change Date Dialog is suppressed.
  • Added Dex.ini Setting DefaultLastUserWindows to Dex.ini Settings window to default the User ID field on Login window to Windows User ID.

Automatic Logout

  • Fixed Automatic Logout still being active when using Report Writer or Modifier to customize Microsoft Dynamics GP.
  • Updated Administrator Settings window to add control of the User Date Change Dialog. This will prevent the dialog interfering with the Automatic Logout functionality.

Administrator Tools

  • Added additional Automatic Cleanup code execution on exit from Microsoft Dynamics GP to clean up stranded sessions on exit as well as login.
  • Updated Report Writer Screen Output memory feature so that it is not active on web client and when Integration Manager is running.
  • Updated Report Writer Screen Output memory feature to use the Window Position Memory SQL table to store the settings as well as Dex.ini setting.

Helper Functions

  • Updated Helper Functions window to place Script ID for MBS_Load_Script_Dex, MBS_Load_Script_SQL & MBS_Load_Script_Net on the first line of inserted code.
  • Updated Helper Functions window to hide SQL Goto functions when calling from Trigger Setup window.
  • Updated Helper Functions window to hide Procedure and Function arguments functions when calling from Runtime Execute Setup window.
  • Added MBS_Trigger_DisableSingle Helper Function to temporarily disable an already started trigger without having to stop and start it again.
  • Added MBS_Trigger_EnableSingle Helper Function to re-enable a trigger temporarily disabled with the MBS_Trigger_DisableSingle Helper Function.
  • Added MBS_Trigger_DisableSingle and MBS_Trigger_EnableSingle to the Helper Functions window.
  • Added MBS_Is_Trigger_Started Helper Function to check if an Automatic Mode Trigger is currently started.
  • Added MBS_Is_Trigger_Enabled Helper Function to check if an Automatic Mode Trigger is currently enabled.
  • Added MBS_Is_Trigger_Started and MBS_Is_Trigger_Enabled to the Helper Functions window.

Project Setup

  • Updated Project Setup window usage check to include where references to the project are made in scripts.
  • Updated Project Setup window to rename references in other tables including scripts when renaming.
  • Updated Project Setup window to display the Last Modified Date, User ID and Window’s User Name for project components on the listview.
  • Updated Project Setup window to offer to restart all Automatic Start triggers when completing development by closing both window when Trigger Setup window not open.
  • Updated Project Setup window to prevent deletion of the entire project if any resources in the project are being referenced from outside the current project.
  • Updated Project Setup window to rename references for new project when duplicating entire project so that it no longer references the original project’s resources.
  • Updated Project Setup window to allow deleting, duplicating and renaming of individual resources without requiring the separate resource window to be opened.

Trigger Setup

  • Updated Trigger Setup window to add usage check before deleting to display where a Trigger ID is used in window fields and/or scripts.
  • Added Rename option to Duplicate Button of the Trigger Setup window to allow renaming without duplicating and deleting original.
  • Updated Trigger Setup window to rename references in other tables including scripts when renaming.
  • Updated Trigger Setup window to offer to restart all Automatic Start triggers when completing development by closing window when Project Setup window not open.
  • Updated Trigger Setup window usage checks to show when a resources is referenced from a different project to the current project.
  • Added After Starting Triggers Event to Login and Logout Trigger Type on Trigger Setup window to allow initial setup or disabling of triggers after registering.
  • Updated Trigger Status window to display when a trigger has been disabled using the MBS_Trigger_DisableSingle Helper Function.

Runtime Execute Setup

  • Updated Runtime Execute Setup window to add usage check before deleting to display where a Script ID is used in window fields and/or scripts.
  • Added Rename option to Duplicate Button of the Runtime Execute Setup window to allow renaming without duplicating and deleting original.
  • Updated Runtime Execute Setup window to rename references in other tables including scripts when renaming.
  • Updated Runtime Execute Setup window usage checks to show when a resources is referenced from a different project to the current project.

SQL Execute Setup, SQL Execute and SQL Results

  • Updated SQL Execute Setup window to add usage check before deleting to display where a Script ID is used in window fields and/or scripts.
  • Added Rename option to Duplicate Button of the SQL Execute Setup window to allow renaming without duplicating and deleting original.
  • Updated SQL Execute Setup window to rename references in other tables including scripts when renaming.
  • Updated SQL Execute Setup window usage checks to show when a resources is referenced from a different project to the current project.
  • Updated SQL Execute Setup window to stop overriding of SQL order caused by sorting the listview (grid) display to the first column ascending.
  • Updated SQL Executer window to stop overriding of SQL order caused by sorting the listview (grid) display to the first column ascending.
  • Updated SQL Results window to stop overriding of SQL order caused by sorting the listview (grid) display to the first column ascending.

.Net Execute Setup

  • Updated .Net Execute Setup window to add usage check before deleting to display where a Script ID is used in window fields and/or scripts.
  • Added Rename option to Duplicate Button of the .Net Execute Setup window to allow renaming without duplicating and deleting original.
  • Updated .Net Execute Setup window to rename references in other tables including scripts when renaming.
  • Updated .Net Execute Setup window usage checks to show when a resources is referenced from a different project to the current project.

Parameter List Maintenance

  • Updated Parameter List Maintenance window to add usage check before deleting to display where a Parameter ID is used in window fields and/or scripts.
  • Added Rename option to Duplicate Button of the Parameter List Maintenance window to allow renaming without duplicating and deleting original.
  • Updated Parameter List Maintenance window to rename references in other tables including scripts when renaming.
  • Updated Parameter List Maintenance window usage checks to show when a resources is referenced from a different project to the current project.

Messages Setup

  • Updated Messages Setup window to add usage check before deleting to display where a Message ID is used in window fields and/or scripts.
  • Added Rename option to Duplicate Button of the Messages Setup window to allow renaming without duplicating and deleting original.
  • Updated Messages Setup window to rename references in other tables including scripts when renaming.
  • Updated Messages Setup window usage checks to show when a resources is referenced from a different project to the current project.

Database Validation and SQL Maintenance

  • Updated trigger to add number of records for tables to the Microsoft Dynamics GP SQL Maintenance window using background process.
  • Updated enhancement to SQL Maintenance to avoid duplicate key errors when attempting to restore data to a table which failed to be dropped.
  • Fixed Database Validation to remove the Database User for DYNSA (if it exists) before assigning DYNSA as the owner of the Database.
  • Updated Database Validation to handle optional removing of empty Views along with empty Tables when missing Dexterity table definitions.
  • Updated Database Validation to expand the size of the Fix Framework window so make it easier to see more companies and more account segments.

Please download and update your systems. You can just install over the top of the existing installation, but must update all workstations and servers which have Dynamics GP installed at the same time.

Check out these articles and links:

Enjoy

David

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

One thought on “#GPPT GP Power Tools Build 28.7 hotfix released

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.