GP Power Tools for Microsoft Dynamics GP (Product ID: 5261) =========================================================== Written by David Musgrave of Winthrop Development Consultants Created on : 30-Aug-2006 Last Modified: 01-Oct-2024 Version History =============== Version 18.07 build 31.3 (Released 01-Oct-2024) Installer: 18.07.0031.3 ----------------------------------------------------------------------- Initial RTM Build. Fixed Field Explorer Resource Explorer window not remembering Window Position and Size. Fixed Restoring of original value for Local String values for Field Change Triggers before Original. Fixed Restoring of original value for Local String values for Form Control rules using a field change trigger before original. Version 18.07 build 31.0 (Released 20-Sep-2024) Installer: 18.07.0031.0 ----------------------------------------------------------------------- Fixed Resource Information window so that it did not produce Focus Type errors for Modified Fields when attempting to register context menu triggers. Fixed Helper Function window to use correct datatype for placeholder variable for calls to the MBS_Set_Window_Value_Modified* series of Helper Functions. Fixed Resource Information to only check if a field is Modified when running against a modified window. Fixed Form Control processor to only check if a field is Modified when running against a modified window. Version 18.07 build 31.0 (Released 17-Sep-2024) Installer: 18.07.0031.0 ----------------------------------------------------------------------- Updated Form Control Setup window to show when OR Mode is active on a Resource Filter. Fixed Form Control Setup Resources window to ensure OR Mode is disabled when resources are excluded. Added User Name to "This checkbook is being reconciled by another user." dialog for Bank Reconcilation window. Version 18.07 build 31.0 (Released 12-Sep-2024) Installer: 18.07.0031.0 ----------------------------------------------------------------------- Fixed Password ID Rename not following through to Form Control Rules using Password ID. Fixed Form Control Window Level Rules not being applied correctly. Version 18.07 build 31.0 (Released 10-Sep-2024) Installer: 18.07.0031.0 ----------------------------------------------------------------------- Updated Form Control to honor Project level User Settings. Updated MBS_Control_Start Helper Function to honor Project level User Settings and Disable checkbox. Updated MBS_Control_Start Helper Function to honor Form Control User Settings and Disable checkbox. Added Focus Field Form Control Rule to set the focus to a particular field. Added Focus Field Next Form Control Rule to set the focus to the next editable field after a particular field. Added Focus Window First Field Form Control Rule to set the focus to the first editable field on a window. Version 18.07 build 31.0 (Released 25-Aug-2024) Installer: 18.07.0031.0 ----------------------------------------------------------------------- Initial Beta Build. Fix for illegal address error on MBS_Debug script. Version 18.06 build 31.1 (Released 16-Aug-2024) Installer: 18.06.0031.1 ----------------------------------------------------------------------- System Features Module ---------------------- Fixed Test and Historical company dialog on log in not showing unless or were the last characters in the Company Name. Added more info button to the Test Company and Historical Company warning dialogs on login to show the range of GL Transaction Dates and Restored Database Data. Added Find A Window window to the Standard Toolbar when it is defaulted. Updated Dex.ini Settings window to limit maximum Scrollbar Width to 17 as Dexterity itself will not allow a scrollbar wider than 17 pixels anymore. Added Note Fix Utility tables to Configuration Export Import window. Fixed possible Duplicate Error on Sequence number when importing Triggers from Configuration Export Import window. Updated install and uninstall code to better handle removing and creating views to avoid issues with table format conversions. Updated ScreenShot window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Administrator Tools Module -------------------------- Fixed Activity Cleanup code to exclude Web Client users from the active SQL SPID check before removing orphaned users from ACTIVIY table. Added option to suppress the Note Index Check warning message for Test and Historical companies to Administrator Settings window. Added User Settings Visual Cues to the Administrator Settings window to show when per user and/or company settings are active without needing to open window. Added User Settings Visual Cues to the Dictionary Control window to show when per user and/or company settings are active without needing to open window. Added User Settings Visual Cues to the Company Login Filter window to show when per user and/or company settings are active without needing to open window. Added User Settings Visual Cues to the Dynamic Product Selection window to show when per user and/or company settings are active without needing to open window. Updated Resource Information window to streamline trigger registration used for following the current field, so it only registers a single trigger on alternate windows. Added Redisplay Button to Resource Information window to refresh field values when data might have changed on a window field or global variable. Updated Dynamic Product Selection window with option to only show selected resources when expanding tree nodes. Disabled Dynamic Product Selection when Integration Manager Integrations are running. Updated all Administrator Tools Maintenance and lookup windows to fix an issue where a table already locked error can occur if the user seeded a lookup with an ID value that already exists. Updated Resource Finder window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated Security Profiler window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated Security Log window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated Security Denied window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated Security Hidden window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated Company Login Filter window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated Window Position Memory window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Developer Tools Module ---------------------- Updated all Developer Tools module Maintenance windows so that adding a Timestamp to release notes updated the icons to show that release notes are present. Updated all Developer Tools Maintenance and lookup windows to fix an issue where a table already locked error can occur if the user seeded a lookup with an ID value that already exists. Added Multi Select Functionality to the Forms Explorer window of the Resource Explorer when in Names Lookup mode to allow multiple resource to be returned at a time. Added Multi Select Functionality to the Table Explorer window of the Resource Explorer when in Names Lookup mode to allow multiple resource to be returned at a time. Added Field Explorer window to Resource Explorer to search for global fields in a dictionary independently of whether they are included in a table or on a window. Added Field Explorer window to Names Button on Trigger Setup window to allow returning of a Dictionary Field for use with Virtual Fields. Added Field Explorer window to Names Button on Runtime Execute Setup window to allow returning of a Dictionary Field for use with Virtual Fields. Added Field Explorer window to Names Button on Snippets Setup window to allow returning of a Dictionary Field for use with Virtual Fields. Fixed issue with renaming Developer Tool resources which could generate SQL Errors. Added User Settings Visual Cues to the Project Setup window to show when per user and/or company settings are active without needing to open window. Updated Project Setup right click context menus to include functionality for the Form Control Setup and Password Setup windows. Fixed possible Duplicate Error on Sequence number when importing Triggers from Project Setup window. Updated Find in Scripts feature in Project Setup window to search within target scripts after target window is opened. Fixed Starting Trigger with Per user settings when Automatic Start is not selected. Per User Settings are now ignored. Added User Settings Visual Cues to the Trigger Setup window to show when per user and/or company settings are active without needing to open window. Updated Trigger Setup window to use Multi Select Functionality on the Forms Explorer and Table Explorer windows of the Resource Explorer when used in Names Lookup mode. Fixed issue with special characters in resource names preventing resources being used in the Trigger Setup window. Fixed Do you want to restart triggers dialog showing when closing Project Setup or Trigger Setup windows when logging out of GP using Exit After Processes. Updated Trigger Setup window to suggest turning off the Script Modified checkbox when it is not required for the script to compile. Updated Developer Tools Triggers Restore previous value code to remove the invalid entry from AutoComplete if AutoComplete is enabled for that field. Fixed Trigger Setup window Rename feature which left orphaned child records. Updated Trigger Setup window to add Enable on Web Client mode checkbox. Added Script Purpose Filter to the Runtime Execute Lookup so only scripts with correct script purpose are shown from SQL Execute Setup and Form Control Setup windows. Added User Settings Visual Cues to the Runtime Execute Setup window to show when per user and/or company settings are active without needing to open window. Updated Runtime Execute Setup window to use Multi Select Functionality on the Forms Explorer and Table Explorer windows of the Resource Explorer when used in Names Lookup mode. Updated Runtime Execute Setup window to suggest turning off the Script Modified checkbox when it is not required for the script to compile. Fixed Variable declared twice error when running a selection on the Runtime Execute Setup window and the selection includes variable definitions. Fixed Runtime Execute Setup window Rename feature which left orphaned child records. Added User Settings Visual Cues to the SQL Execute Setup window to show when per user and/or company settings are active without needing to open window. Updated SQL Execute Setup window to use Multi Select Functionality on the Forms Explorer and Table Explorer windows of the Resource Explorer when used in Names Lookup mode. Updated SQL Execute Setup window with Script menu option to use shortened SQL field and table naming with the Names Button or fully qualified naming. Updated SQL Execute Setup window with Script menu option to automatically add the show keyword for field names to show column display names. Updated SQL Execute Setup Companies window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated SQL Execute Setup, SQL Executer, SQL_Results and SQL_Results2 windows to improve handling when attempting to execute an empty SQL Script. Updated MBS_SQL_Execute, MBS_SQL_Check_Exists, MBS_SQL_Get_Data and MBS_Export_SQL_Query_To_File Helper Functions to improve handling when attempting to execute an empty SQL Script. Fixed SQL Execute Setup window Rename feature which left orphaned child records. Added User Settings Visual Cues to the .Net Execute Setup window to show when per user and/or company settings are active without needing to open window. Updated .Net Execute Setup window to use Multi Select Functionality on the Forms Explorer and Table Explorer windows of the Resource Explorer when used in Names Lookup mode. Fixed .Net Execute Setup window Rename feature which left orphaned child records. Updated Snippets Setup window to use Multi Select Functionality on the Forms Explorer and Table Explorer windows of the Resource Explorer when used in Names Lookup mode. Updated Snippets Setup window with Script menu option to use shortened SQL field and table naming with the Names Button or fully qualified naming. Updated Snippets Setup window with Script menu option to automatically add the show keyword for field names to show column display names. Added Test button to Messages Setup window. Fixed Messages Setup window Rename feature which left orphaned child records. Virtual Fields for Developer Tools module ----------------------------------------- Added Virtual Fields functionality to Developer Tools module to allow custom fields to be added to windows using code without needing Modifier. Updated Virtual Fields functionality to allow fields from any dictionary to be used when adding Virtual Fields. Updated Virtual Fields with warning that Virtual Fields field level triggers on 3rd party forms are not supported by Dexterity. Added VF_ Fields to GP Power Tools dictionary for use with Virtual fields, while any field from any dictionary can be used, these fields are designed for this purpose. Added Virtual Field Prompt support for Checkbox and Radio Button datatypes. Updated Runtime Execute window to add VirtualFieldHandler Script Purpose for handling trigger events from Virtual Fields. Added MBS_Add_Virtual_Field Helper Function to allow for creation of a Virtual Field. Added MBS_Add_Virtual_FieldPrompt Helper Function to allow for creation of a Virtual Field with a Prompt. Added MBS_Add_Virtual_FieldFormat Helper Function to allow for creation of a Virtual Field with a Format Field. Added MBS_Add_Virtual_FieldPromptLookup Helper Function to allow for creation of a Virtual Field with a Prompt and Lookup Button. Added MBS_Add_Virtual_FieldPromptFormat Helper Function to allow for creation of a Virtual Field with a Prompt and Format Field. Added MBS_Add_Virtual_FieldAll Helper Function to allow for creation of a Virtual Field with a Prompt, Lookup Button and Format Field. Added MBS_Get_Field_Reference Helper Function to retrieve the reference to a Virtual Field so it can be addressed using the field(ReferenceVariable) Dexterity function. Added MBS_Add_Virtual_FieldLine Helper Function to allow for creation of a Virtual Field as a horizontal line on the window. Added MBS_Get_Virtual_Field, MBS_Set_Virtual_Field and MBS_Map_Virtual_Field Helper Functions to allow addressing of Virtual Fields from different dictionary context. Added MBS_Expand_Virtual_Field_Window Helper Function to simplify making space on windows to add Virtual Fields into. Added MBS_Get_Virtual_Field_Caption and MBS_Set_Virtual_Field_Caption Helper Functions to allow addressing of Virtual Fields from different dictionary context. Added MBS_Get_Virtual_Field_Tooltip and MBS_Set_Virtual_Field_Tooltip Helper Functions to allow addressing of Virtual Fields from different dictionary context. Updated Helper Functions window to support MBS_Add_Virtual_Field series of Helper Functions and MBS_Get_Field_Reference Helper Function. Updated Helper Functions window to support MBS_Add_Virtual_FieldLine Helper Function. Updated Helper Functions window to support MBS_Get_Virtual_Field, MBS_Set_Virtual_Field and MBS_Map_Virtual_Field Helper Functions. Updated Helper Functions window to support MBS_Expand_Virtual_Field_Window Helper Function. Updated Helper Functions window to support MBS_Get_Virtual_Field_Caption and MBS_Set_Virtual_Field_Caption Helper Functions. Updated Helper Functions window to support MBS_Get_Virtual_Field_Tooltip and MBS_Set_Virtual_Field_Tooltip Helper Functions. Disabled Virtual Fields for Web Client and Service Mode as they are not supported by Dexterity. Added Window Note fields and Window Help Fields as defaults for the MBS_Expand_Virtual_Field_Window Helper Function. Form Control Module ------------------- Initial release of Form Control module including templates for making Maintenance and Address Maintenance windows read only. Added Form Control module to Registration system. Added Password Setup window for Form Control module. Added Password Lookup window for Form Control module. Added tables for Password Messages linked to Language ID to Password Setup window. Added tables for User Settings to Password Setup window. Added Password Messages linked to Language ID to Password Setup window. Added User button for User Settings to Password Setup window. Added Test button to Password Setup window. Added Password Report for Form Control Module. Fixed Password Setup window Rename feature which left orphaned child records. Added Form Control Setup window for Form Control Module. Added Form Control Lookup window for Form Control Module. Added Form Control Report for Form Control Module. Added User Settings Visual Cues to the Form Control Setup window to show when per user and/or company settings are active without needing to open window. Fixed Form Control Setup window Rename feature which left orphaned child records. Added Scrolling Window Save, Delete and Insert rules to Forms Control Setup window to block saving, deleting and inserting of scroll window lines. Added Clear Changes Before Window Close and Clear Changes Before Field rules to Forms Control Setup window to prevent Handle Changes Save, Discard/Delete, Cancel Dialogs. Added Block Window from Saving and Block Window from Deleting rules to Forms Control Setup window. Added Default Field Value rule to Form Control Module to allow defaulting of field values on a window. Added Strip Invalid Field Characters rule to Form Control Module to allow key fields to automatically be limited to only contain specific characters. Added Validate Field Value rule to apply formatting and value rules to fields includes options to check using SQL Like or Regular Expressions (RegEx). Added Mask Field Value rule to hide a field value until the field gains focus and to mask it again when the field loses focus. Added Add Required Field rule to mark additional fields as required, subject to underlying code calling the required() Dexterity function. Added Format String Field Value rule to allow fields to be formatted to specific templates without using Modifier. Added Lock Scrolling Window rule to set Scrolling Windows to read only mode and prevent editing and saving of lines, use with Reject Scroll Delete and Reject Scroll Insert. Added Form Menu Shortcut rule to run field or button scripts when menu selected or keyboard shortcut pressed. Key fields can be restored afterwards to reload record. Added Round Decimal Field Value mode to allow rounding of fields based on a fixed decimal place value or value relative to IV_Item_Master for selected Item. Added Form Control rules for use with scripting: Reject Form Pre Script, After Form Pre Script, Reject Form Post Script, After Form Post Script. Added Form Control rules for use with scripting: Reject Window Pre Script, After Window Pre Script, Reject Window Post Script, After Window Post Script, Reject Window Activate Script, After Window Activate Script. Added Form Control rules for use with scripting: Reject Scroll Window Save, After Scroll Window Save, Reject Scroll Window Delete, After Scroll Window Delete, Reject Scroll Window Insert, After Scroll Window Insert. Added Form Control rules for use with scripting: Reject Scroll Window Fill, After Scroll Window Fill, Reject Scroll Window Pre, After Scroll Window Pre, Reject Scroll Window Post, After Scroll Window Post. Added Form Control rules for use with scripting: Reject Field Pre Script, After Field Pre Script, , Reject Field Change Script, After Field Change Script, Reject Field Post Script, After Field Post Script, After Field Value Changed Script. Added Form Control rule for changing Background color of fields with reversing option based on Conditional Script results. Added Form Control rule for changing Font color of fields with reversing option based on Conditional Script results. Added Form Control rule for AutoComplete setting of fields with reversing option based on Conditional Script results and expression to add to AutoComplete items. Added Form Control rule for clearing a field, can be used with Conditional Script to clear field depending on specified business logic. Added Form Control Uppercase Field rule to force a field to uppercase after data entry. Added Form Control Label rule which can be used to visually break up rules on the Form Control window into functional groups. Added Set Field Caption rule to Form Control to change the linked prompt caption on the window for the field. Added Set Field Value rule to Form Control to change the value of a field, it be used with a conditional script for dynamic values based on other fields. Added Form Control Change Window Title rule to allow window titles to be changed. Added Allow Multiple Resources (Or Mode) checkbox to resource selection in Forms Control Setup window. Added dialog options Form Control Rule to display dialogs in string or text mode and to select the icon used (Information, Warning, Error or Debug). Added Form Control Option to reverse Lock Field to allow unlocking fields based on the Conditional Script results. Added Form Control Option to reverse Disable Field to allow enabling fields based on the Conditional Script results. Added Form Control Option to reverse Hide Field to allow showing fields based on the Conditional Script Results. Added Form Control Option to reverse Required Field to allow marking unrequired fields based on the Conditional Script results. Updated Form Control AutoComplete Field rule to allow for case insensitivity during data entry, but then update the field to match case specified in the Expression field. Updated Form Control Restore previous value code to remove the invalid entry from AutoComplete if AutoComplete is enabled for that field. Fixed issue with Form Control where form level triggers were being registered repeatedly each time an alternate form was opened. Now only registers once for original form. Updated Form Control to prevent saving if the Resources or Rules windows are still open. Updated Form Control Resources Window to add Alternate Mode and Modified Mode to allow control of which versions of windows to apply rules to. Updated Form Control with an option to override the script dictionary context to run the script in the context of the current form. Fixed issue with renaming Runtime Execute scripts not detecting if the script is used by Form Control. Added Form Control Status window for Form Control Module. Added Enabled Checkbox to the Form Control Status window and refreshed its status when windows are opened and closed. Added Form Control Resource window which displays the Form, Window and Field data for forms already opened and allows filtering to show resources matching settings. Updated Form Control Resource Caching to be semi permanent to improve performance. Only refreshes data if the dictionary version number has changed or for Modified windows. Added Options menu to Form Control Resources window with choice to reset the Form Control Resources cache. This is for when a 3rd party product updates a dictionary without changing their version number. Updated Form Control window to add Enable on Web Client mode and Enable in Service Mode checkboxes. Disabled Form Control when Integration Manager Integrations are running. Performance enhancements to Form Control Module. Further Performance Enhancements to Form Control module using Views. Stability and Performance improvements to Form Control module for handling of Modified and Alternate windows. Opened Form Control Processing form with tables opened on form open to enhance performance. Closed Form Control Processing form when Form Control triggers are unregistered. Added FormControlConditional custom script purpose to Runtime Execute Setup window. Added Field Value being passed into conditional Form Control Scripts when they are used, works for both original and modified fields. Updated Helper Functions window to add From Control Mode for Window Helper Functions so they can work easily with the Form Control Conditional script. Added MBS_Ask_Password Helper Function to allow Password IDs to be called from scripts. Added MBS_Control_Start, MBS_Control_Stop and MBS_Control_Stop_All Helper Functions for manually starting and stopping a Form Control ID. Added MBS_Contol_Update_Dialog Helper function to allow the dialog warning or Message to be changed via code in the Form Control Conditional Script. Added MBS_Contol_Update_Expression Helper function to allow the Expression used for Default, Strip, Validate and Format modes to be changed via code in the Form Control Conditional Script. Added MBS_Get_First_Window Helper Function to get the technical name of the first (main) window on a form. Added MBS_Check_Resource_Exists Helper Function to check whether a form, window, window field or global field exists in a dictionary. Updated Helper Functions window to support MBS_Ask_Password Helper Function. Updated Helper Functions window to support MBS_Control_Start, MBS_Control_Stop and MBS_Control_Stop_All Helper Functions. Updated Helper Functions window to support MBS_Contol_Update_Dialog Helper Function. Updated Helper Functions window to support MBS_Contol_Update_Expression Helper Function. Updated Helper Functions window to support MBS_Get_First_Window Helper Function. Updated Helper Functions window to support MBS_Check_Resource_Exists Helper Function. Database Tools Module --------------------- Updated Database Validation window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Fixed Database Validation to use Dexterity table commands when removing users, companies and user/company access to ensure any triggers watching for deleting of those records fire. Updated Password Reset Email Settings window to allow email template to be saved without the %2 placeholder if you want to send the email with only the password and not the User ID. Fixed SQL Login Maintenance when sending Password Reset Emails only sending one email depending on the email mode set up. Added Sending Emails progress window to show the status when sending Password Reset Emails from SQL Login Maintenance to many users. Updated SQL Login Maintenance window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated SQL Login Maintenance window to add User Class ID column to the list view, so you can select users by User class when resetting passwords. Updated Copy User Settings window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Updated Note Fix Utility with a Grouped & Linked table exclusion mode to handle recurring transactions for GL, PM, RM and IV modules. Added Database Space Recovery Tool to recover space taken by deleted records in heap tables. Updated Database Space Recovery window to allow multi-selection in listviews to be used with Mark All and Mark None buttons. Added support for compression of Clustered tables to Database Space Recovery window. Version 18.04 build 30.3 (Released 10-Apr-2024) Installer: 18.04.0030.3 ----------------------------------------------------------------------- In Service Mode, set User Date of globals to current date if not already set. Make sure Tables are closed when exiting Dynamics Process Server (DPS) to avoid logout errors. Version 18.06 build 30.3 (Released 10-Apr-2024) Installer: 18.06.0030.3 ----------------------------------------------------------------------- Fixed Dexterity Login dialog showing when logging on startup has been enabled with the MBS_Debug_LogOnStartup Dex.ini setting. Fixed Resource Information when using the Copy Button > To Trigger Setup in Procedure and Function mode to not change when the Trigger Event includes parameters. Fixed Secondary trigger for Field Change Events on Modifier Added fields firing the trigger script delayed when the field gains focus. Fixed SQL Lookup where it could execute the returned field's change script twice under certain circumstances. Fixed Form Lookup where it could execute the returned field's change script twice under certain circumstances. Fixed MBS_Return where it could execute the returned field's change script twice under certain circumstances. Added MBS_SQL_Lookup2, MBS_SQL_Lookup_Parameter2 Helper Functions which use Set Field and Run Script instead of Return Data mode, for when Return mode fails. Added MBS_Form_Lookup2, MBS_Form_Lookup_Parameter2 Helper Functions which use Set Field and Run Script instead of Return Data mode, for when Return mode fails. Added MBS_Return_By_Field2, MBS_Return_By_Reference2 Helper Functions which use Set Field and Run Script instead of Return Data mode, for when Return mode fails. Updated Messages Setup window to allow three warning prompts to be associated with each message for using with the ask() dialog or MBS_Ask and MBS_Ask_Text Helper Functions. Added MBS_Get_Message_Prompts Helper Function to return the warning and warning prompts stored against a Message ID. Added MBS_Show_Dialog and MBS_Show_Dialog_Text Helper Functions to provide easy access to Dexterity system dialogs for .Net Execute scripts. Added MBS_Ask_Dialog and MBS_Ask_Dialog_Text Helper Functions to provide easy access to the Dexterity ask() dialog for .Net Execute scripts. Updated Helper Functions window to allow Return Mode selection for SQL Lookup, Form Lookup and MBS_Return when Return Data mode fails across dictionaries. Updated Helper Functions window to allow inclusion of prompts when using Helper Functions to get the warning from a Message ID. Updated Helper Functions window to support MBS_Show_Dialog, MBS_Show_Dialog_Text, MBS_Ask_Dialog and MBS_Ask_Dialog_Text Helper Functions. Updated Database Validation to flag the DEX_ROW_ID column in a table from a Dexterity product dictionary if it is not marked as an identity column. Updated Database Validation to add Mark All and Unmark All buttons to the Database selection pane on the main window. Added warning to Database Validation when selecting more than 3 company Databases that processing and validation can take a long time. Updated Note Fix Utility to exclude database tables that are not from a Dexterity product dictionary, this will avoid it processing backup tables. Updated Note Fix Utility to exclude tables where the DEX_ROW_ID column exists in the table but is not marked as an identity column, fixes duplicate errors. Updated Note Fix Utility to warn if a table from a Dexterity product dictionary has a DEX_ROW_ID column that is not marked as an identity column. Version 18.06 build 30.2 (Released 19-Feb-2024) Installer: 18.06.0030.2 ----------------------------------------------------------------------- Fixed timing issue with Visual Studio Integration Toolkit menus failing to register on startup. No need to move GPPT above VSIT in Dynamics.set launch file. Fixed Database Validation SQL Error when opening the Fix Users window. Updated startup code to avoid additional ** End of Log ** being logged when Visual Studio Integration Toolkit menus are being used. Version 18.06 build 30.2 (Released 16-Feb-2024) Installer: 18.06.0030.2 ----------------------------------------------------------------------- Fixed timing issue with Visual Studio Integration Toolkit menus failing to register on startup. No need to move VSIT above GPPT in Dynamics.set launch file. Fixed Note Fix Utility to only use Data Compression on Enterprise or Azure SQL Server versions. Fixed Note Fix Utility case sensitivity issues on Binary SQL Server Instances. Updated Note Fix Utility with additional case sensitivity fixes and fixed a duplicate error when changing checkbox while background processing is running. Added Background Processing not available message to Note Fix Utility when Processing or Fixing Notes. Version 18.06 build 30.2 (Released 14-Feb-2024) Installer: 18.06.0030.2 ----------------------------------------------------------------------- Updated copyright notices for the year 2024. Fixed installer complaining about DPM.EXE when Dell Peripheral Manager is installed and running. Added MBS_Debug_HideGames Dex.ini seting to allow free games to be hidden from Microsoft Dynamics GP >> Tools >> Customize menu. Updated the fix for Activity_GetBackgroundStatus() so that it can automatically restart the Update_Date Timed process from Professional Services Tools Library (if installed). Updated Administrator Settings window to ask if you wish to clear the Security Activity Tracking Log files if the options are disabled and the logs contain data. Updated Administrator Settings window to ask if you wish to clear the User Activity Tracking Log files if the options are disabled and the logs contain data. Added SQL Server Version Check on Login looking for old SQL Server Versions below the system requirements. Updated SQL Server Version Check minimum supported versions based on information from support team and system requirements. Added option to disable SQL Server Version Check to the Administrator Settings window. Added User Message Replacement system to replace User Message System Dialogs with Modal Dialogs so that a User Message does not stop Automatic Logout. Added MBS_Debug_UserMessageReplace Dex.ini setting to allow disabling of the replacement of User Message System Dialogs with Modal Dialogs. Updated Automatic Logout to avoid Timed Triggers or Scheduled Triggers reseting the last activity date and time and preventing Automatic Logout. Updated Automatic Logout to take reserved users into account when checking if the available user count timeout setting should be used. Fixed Login Limits not allowing a user to log back in after an abnormal exit which left an activity record, when the maximum users is reduced by reserved users. Updated Login Limits to correctly handle maximum allowed users when reserved users are specified and the reserved user is already logged in. Fixed Launch File Configuration to stop it writing log entries about launch file changes unless the changes are actually being applied. Fixed Project Setup Status line to show Total first and include Snippets in the counts. Updated Project Setup window to force refresh the cache of Runtime Execute Scripts for the project when Project Disabled checkbox changed. Updated Project Setup window to stop any triggers running for the project when the Project Disabled checkbox is selected. Updated Project Setup window to not ask about starting project triggers when the Project Disabled checkbox is selected. Updated Trigger Setup window so that default trigger Script for FORM POST events do not include a check that the form is open as it is closing. Updated Trigger Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning. Updated Trigger Setup window with warnings about using Focus Event with Table Trigger Type as it can be less reliable than using Focus Event and Helper Functions. Updated Trigger Setup window to recommend against using Focus Event with Table Trigger Type with Scroll Fill Trigger Events as newer method with Focus Event Trigger Type is better. Updated Automatic Trigger Mode to speed up starting Triggers on login by excluding triggers in disabled projects earlier in the trigger starting process. Fixed Focus Change Trigger on Modifier added Button fields reporting a trigger error for the PRE trigger when Minimize Logs is checked. Fixed Timed Trigger Handling to remove trigger from Trigger Status list if background timed process removed via the Process Monitor. Fixed Scheduled Trigger Handling to remove trigger from Trigger Status list if background timed process removed via the Process Monitor. Updated Trigger Handling for Focus Event Trigger Type with Scroll Fill Trigger Event to also copy field from the specified table to the original window when Modified script being executed. Updated Runtime Execute Setup window to add Script Purpose into the available sort orders for the browse buttons. Updated Runtime Execute Lookup window to add Script Purpose into the available sort orders and display Script Purpose on the window. Updated Runtime Execute Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning. Updated Runtime Execute Setup Custom Script Purpose Handlers to be disabled if the script is disabled or the script's project is disabled. Updated Runtime Execute Setup window to not ask about starting project triggers when the Project Disabled checkbox is selected. Updated SQL Execute Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning. Updated .Net Execute Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning. Updated .Net Execute Setup window to not ask about starting project triggers when the Project Disabled checkbox is selected. Fixed Snippet Setup window so that Sort By drop down list was set correctly when opening the window from the Project Setup window. Updated Snippet Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning. Updated Parameter List Maintenance Window to add a soft limit when using the browse buttons to avoid changing projects without warning. Updated Messages Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning. Fixed Visual Studio Integration Toolkit Unregister Menu error being logged when the error code was zero meaning no error. Fixed Note Fix Utility so it can work with older SQL Server Versions that don't understand "drop table if exists" syntax. Updated Note Fix Utility to exclude Collections Management Tables from scanning as they used their own Notes System. Updated Note Fix Utility to exclude Enhanced Notes Tables from scanning as they intentionally have duplicated Note Index values. Fixed Note Fix Utility Exclude Tables window to allow manual entry of table exclusions to be entered successfully. Updated Note Fix Utility Exclude Tables window to allow entry of SQL only Tables and Fields to be excluded from the Note Fix Utility. Added Delete Row button to Scrolling window on the Note Fix Utility Fields window. Added Delete Row button to Scrolling window on the Note Fix Utility Exclude Tables window. Added Mass Delete button and window to remove old Used Duplicate or Orphaned Note Records by date rather than manually identify where they belong. Version 18.06 build 30.1 (Released 15-Oct-2023) Installer: 18.06.0030.1 ----------------------------------------------------------------------- Fixed Company Login Filter Custom Order mode not working until saved and redisplayed. Version 18.06 build 30.1 (Released 02-Oct-2023) Installer: 18.06.0030.1 ----------------------------------------------------------------------- Initial RTM Build Version 18.06 build 30.0 (Released 31-Aug-2023) Installer: 18.06.0030.0 ----------------------------------------------------------------------- Initial Beta Build Version 18.05 build 30.1 (Released 21-Aug-2023) Installer: 18.05.0030.1 ----------------------------------------------------------------------- Updated to Registration System to add Email Distribution List for additional emails to be included in renewal notes, invoices, update notices, etc. Added feature to open Update Check Window if new install older than published version. Added better support for Service Based Architecture Service Mode, with Product Version Validation and User Activity Tracking. Added better support for Service Based Architecture Service Mode, with Dictionary Control and Security Activity Tracking. Added better support for Dynamics Process Server mode, with Product Version Validation and Dictionary Control. Added Legacy Print Dialog registry setting for Windows 11 22H2 or later to installer. Added check for Next Note Index having a lower value than the maximum used Note Index to Administrator Settings. Added support for Visual Studio Integration Toolkit Custom Forms module to Runtime Execute Setup window. Added Snippet Setup window to store Snippets of scripts for Dexterity, SQL Server, Visual C Sharp and Visual Basic.Net. Updated Snippet Setup window to add Snippets to Insert Button to allow Snippets to be inserted. Updated Snippet Setup automatic reference renaming system to add support for four modes of Snippet scripts. Fixed Inserting of Snippet to update window changed flag and script character counts on all windows. Updated Project Setup automatic reference renaming system to add support for four modes of Snippet scripts. Updated Project Setup window to add Find in Scripts window to the Options menu which can search all scripts in a project or the entire system. Updated Trigger Setup window to add Snippets to Insert Button to allow Snippets to be inserted. Updated Trigger Setup automatic reference renaming system to add support for four modes of Snippet scripts. Improved Error Handling for Triggers registered using .Net methods for Field Value Changed or Modified windows or for Functions and Procedures with arguments. Added Enabled in Service Mode checkbox to Options Tab on Trigger Setup window and Trigger report. Added support to start Triggers Enabled in Service Mode when starting up Service Mode sessions. Added support to start Triggers Enabled in Service Mode when starting up Dynamics Process Server sessions. Fixed Renaming of Runtime Execute Scripts to unload cached script with the old Script ID to force reloading when needed. Updated Runtime Execute Setup window to add Snippets to Insert Button to allow Snippets to be inserted. Updated Runtime Execute Setup automatic reference renaming system to add support for four modes of Snippet scripts. Added EventRegisterForm and EventHandlerForm Custom Script Purposes to support Visual Studio Integration Toolkit Custom Forms. Fixed VSIT EventHandlerForm and EventRegisterForm not using Minimize Logs setting correctly. Fixed Renaming of SQL Execute Scripts to unload cached script with the old Script ID to force reloading when needed. Fixed SQL Execute Window check for references not picking up references when used with MBS_Script_Load_SQL_DB Helper Function. Added Names for Constants (value) to the SQL Execute Setup window. Updated SQL Execute Setup window to add Snippets to Insert Button to allow Snippets to be inserted. Updated SQL Execute Setup automatic reference renaming system to add support for four modes of Snippet scripts. Fixed Renaming of .Net Execute Scripts to unload cached script with the old Script ID to force reloading when needed. Updated .Net Execute Setup window to add Snippets to Insert Button to allow Snippets to be inserted. Updated .Net Execute Setup automatic reference renaming system to add support for four modes of Snippet scripts. Fixed Renaming of Parameter Lists to unload cached parameter list with the old Parameter ID to force reloading when needed. Updated Parameter List Maintenance automatic reference renaming system to add support for four modes of Snippet scripts. Updated Messages Setup automatic reference renaming system to add support for four modes of Snippet scripts. Fixed Helper Functions window to correctly handle overwriting of selected text when inserting new code. Fixed MBS_Form_Lookup Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries. Fixed MBS_Form_Lookup_Parameter Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries. Fixed Database Validation error for use of TRIM() function on SQL Server 2016 or earlier. Added Tables, Menus and Security for new Note Fix Utility window. Created Note Fix Utility window to search for and locate issues with Note Indexes and provide options to fix. Updated Note Fix Utility to handle Note Indexes copied into secondary tables. Differentiating between copied Note Indexes and Duplicated Note Indexes. Updated Note Fix Utility to fix notes a table at a time with progress bar and updating of notes copied into secondary tables as required. Updated Note Fix Utility to use Background processing when available for processing, fixing notes and displaying duplicates. Updated Note Fix Utility to add Table Exclusions and additional Table level rules. Updated Note Fix Utility to add Table Groupings for when a single note index is intentional copied to multiple records, such as GL20000 and GL30000 tables. Updated Note Fix Utility with further performance enhancements to the fixing Note Index scripts. Updated Note Fix Utility with faster display of items in Listviews by storing addition record counts needed, rather than reading on demand. Version 18.05 build 29.5 (Released 21-Jun-2023) Installer: 18.05.0029.5 ----------------------------------------------------------------------- Updated Activity Cleanup script to identify mismatched spid processes where the SQL spid has been reassigned. Fixed Project Setup window where .Net Execute scripts were display last modified data in the incorrect columns. Updated Error Handling for Trigger modes using .Net technology to correctly detect when they fail to register. Updated Error Handling for Trigger modes using .Net technology to show errors detected in the log files. Updated Trigger Setup window to change the naming of the Field Changed Focus Trigger Event to Field Value Changed. Version 18.05 build 29.5 (Released 16-Jun-2023) Installer: 18.05.0029.5 ----------------------------------------------------------------------- Updated Resource Explorer Form Explorer window to show control types of local fields if the form containing the local fields is open. Updated Resource Explorer Menu Explorer window to show control types of local fields if the form containing the local fields is open. Added Redisplay function to the Options menu of all windows of the Resource Explorer. Added Find and Find Next functions with settings to control behaviour to the Options menu of all windows of the Resource Explorer. Added Table Usage Lookup window to Resource Explorer to show the dictionary forms and reports a table has been used on. Added Table Usage Button to Resource Information window to open new Table Usage Lookup window and jump to selected form or report. Updated Dex.ini Settings window to add Integration Manager debugging Dex.ini settings: ShowDynamics and DoUIRedraw to Other tab. Updated Dex.ini Settings window to add Legacy Print Dialog registry setting for Windows 11 22H2 or later to Reports tab. Updated Product Version Validation window to make the left hand pane smaller by default. Updated ScreenShot System Status report to include the ODBC Data Source Server Name. Updated Administrator Settings window to set default timeout for Report Writer Screen Output window to 15 minutes rather than 5 minutes. Updated automatic activity cleanup script to remove empty transaction level realtime posting batch headers when the user is not logged in. Added new Company Login Filter Check window which displays what Per User Settings could cause a user to be unable to log into a specific company. Added button to open Company Login Filter Check window from the Company Login Filter window. Added automatic opening of the Company Login Filter Check window when saving from Company Login Filter window, if settings are likely to lock current user out. Added Additional menu to open the Company Login Filter Check window to the User Company Access window. Added automatic opening of the Company Login Filter Check window when adding company access for a user, if there are settings likely to deny access to that user. Fixed Resource Explorer Form Explorer window to show fields not visible in Visual Studio Tools such as Radio Buttons, ListViews and TreeViews. Fixed Resource Explorer Menu Explorer window to show fields not visible in Visual Studio Tools such as Radio Buttons, ListViews and TreeViews. Fixed Additional User Information window so that it recorded the created and last modified audit trail data. Fixed previously applied fix for the Apply button on the User Display Preferences window as Microsoft have fixed the issue with clicking Apply twice in v18.4. Fixed Administrator Settings window where changes to Additional User Information Settings were not getting saved. Fixed Company Login Filter not working correctly when using per User Settings on first login when it works for switching companies. Needed to use User ID from window. Updated Project Setup window to allow ID fields to expand with the window to make it easier to see long ID values. Updated Trigger Setup window to allow ID fields to expand with the window to make it easier to see long ID values. Updated Runtime Execute Setup window to allow ID fields to expand with the window to make it easier to see long ID values. Updated Runtime Executer window to allow ID fields to expand with the window to make it easier to see long ID values. Updated SQL Execute Setup window to allow ID fields to expand with the window to make it easier to see long ID values. Updated SQL Executer window to allow ID fields to expand with the window to make it easier to see long ID values. Updated .Net Execute Setup window to allow ID fields to expand with the window to make it easier to see long ID values. Updated .Net Executer window to allow ID fields to expand with the window to make it easier to see long ID values. Updated Parameter List Maintenance window to allow ID fields to expand with the window to make it easier to see long ID values. Updated Message Setup window to allow ID fields to expand with the window to make it easier to see long ID values. Updated Trigger Setup window to handle when a trigger is loaded for product dictionary that is not currently loaded. Updated Runtime Execute Setup window to handle when a script is loaded for product dictionary that is not currently loaded. Updated Runtime Executer window to handle when a script is loaded for product dictionary that is not currently loaded. Updated Trigger Setup window to automatically enable showing of the runtime engine when a trigger using the runtime is loaded. Updated Runtime Execute Setup window to automatically enable showing of the runtime engine when a script using the runtime is loaded. Added Goto Mode to SQL Execute Setup Window to add ability to run Goto scripts After Query displayed and Before Closing the window instead of from the Goto menu. Updated SQL Execute Setup window to support new After Query and Before Close Goto Script Modes. Updated SQL Executer window to support new After Query and Before Close Goto Script Modes. Updated SQL Results window to support new After Query and Before Close Goto Script Modes. Updated SQL Results 2 window to support new After Query and Before Close Goto Script Modes. Updated Developer Tools maintenance windows to allow for SQL code longer than 32767 characters when checking if object is used by other objects in the system. Added Copy To Trigger Setup option to the Copy Button on the Resource Information window to speed up creation of triggers based on selected resources. Updated Trigger Setup window for Focus Triggers on global fields to not include the if empty() check if the field does not have a value (Push Buttons, ListViews, TreeViews). Updated Trigger Setup window for Focus Triggers on local fields to not include the if empty() check for fields without a value if the form containing the local field is open. Added check for Radio Button fields when selecting fields for Focus Triggers on the Trigger Setup window as triggers cannot be registered against Radio Button, use the Radio Group instead. Updated Project Setup window so that it automatically saves when changing default project, if required fields have are entered. Added Helper Function MBS_subtext to expose custom subtext() function to Developer Tools scripts, a version of substring() that works for text variables and fields. Added RW_GetUserMasterAdditionalPrompts() Report Writer Function to retrieve User Defined Prompts for use with RW_GetUserMasterAdditionalData() Report Writer function. Added MBS_UserAddInfo_Get Helper Function to retrieve data from the Additional User Information window's table. Added MBS_UserAddInfo_GetPrompt Helper Function to retrieve the prompts for the six user defined fields on the Additional User Information window. Added MBS_UserAddInfo_Set Helper Function to write data to the Additional User Information window's table. Added MBS_SQL_Sort_Get Helper Function to get the current sort column and mode from a SQL Results data set. Added MBS_SQL_Sort_Set Helper Function to set the current sort column and mode for a SQL Results data set. Added MBS_SQL_Export_Data Helper Function to Export all rows or selected rows from a SQL Results data set to Tab Delimited, Comma Delimited or HTML table text field. Updated Helper Functions window to add support for new MBS_subtext Helper Function. Updated Helper Functions window to add support for existing MBS_Email_API Helper Function to make it easy to find and use from Dexterity, C# and VB.Net scripts. Updated Helper Functions window to add support for new MBS_UserAddInfo_Get Helper Function. Updated Helper Functions window to add support for new MBS_UserAddInfo_GetPrompt Helper Function. Updated Helper Functions window to add support for new MBS_UserAddInfo_Set Helper Function. Updated Helper Functions window to add support for new MBS_SQL_Sort_Get Helper Function. Updated Helper Functions window to add support for new MBS_SQL_Sort_Set Helper Function. Updated Helper Functions window to add support for new MBS_SQL_Export_Data Helper Function. Fixed Reject Script not working for Focus Triggers before original when Modified was marked. This situation is not actually required as Modified should not be marked for an original resource. Fixed Helper Function window so that when it automatically inserts parameter lists, it only includes active parameters. Fixed MBS_Arguments_Set_Value Helper Function where setting a text field which caused it to increase in length from less than 255 characters (string) to more than 255 characters (text). Fixed Project Setup window so that Open Form and Reports button correctly opened the form or report of the selected trigger or resources and not the form specified on the project header. Fixed error when exporting objects with large scripts. Now scripts of maximum length of 32,000 characters can still export to XML successfully. Fixed MBS_SQL_Lookup Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries. Fixed MBS_SQL_Lookup_Parameter Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries. Fixed MBS_Return_By_Field Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries. Fixed MBS_Return_By_Reference Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries. Updated Database Validation to show Account Number Length information on the Fix Account Framework window. Updated Database Validation to show actual used characters for each segment in the account framework of each company on the Fix Account Framework window. Updated Database Validation to add an Edit Account Framework window to the Fix Account Framework window, this can be used to change the system Account Framework settings. Fixed Database Validation to recreate the Dexterity Auto Stored Procedures, re-grant access and re-bind defaults when a table has failed to convert. Fixed Database Validation to handle updating the structure of the GL_Account_MSTR (GL00100) table which needs special handling as it is a filtered table. Fixed Database Validation to drop and recreate additional Auto Stored Procedures relating to filtered tables such as the GL_Account_MSTR (GL00100) table. Added dialog to recommend running the Database Maintenance Utility (DBMaintenance.exe) after the GL_Account_MSTR table has been updated. Fixed Database Validation to ensure that Minimum Segment size is at least 1 character when editing the Account Framework. Added feature to Database Validation Options Menu to create a Password Hash File containing the password hashes from the old server so they can be restored on a new server. Added new option to the Database Validation Fix Users window to load a previously created Password Hash File to so that passwords from the old server can be restored to a new server. Version 18.05 build 29.4 (Released 09-Feb-2023) Installer: 18.05.0029.4 ----------------------------------------------------------------------- Updated Fix to Activity_GetBackgroundStatus() Dexterity command to restart timed processes for Login and Switch Company windows if they are open. Version 18.05 build 29.4 (Released 10-Jan-2023) Installer: 18.05.0029.4 ----------------------------------------------------------------------- Updated copyright notice for the year 2023. Updated Registration System to restore previous registration keys if no new keys are available for all situations and not just when Grace Period is active. Updated Automatic Logout Activity checking to include scripts called from main Inquiry windows to prevent logouts when only using inquiry windows. Updated Product Version Validation to only check dictionary versions once during first login to Microsoft Dynamics GP. Updated Product Version Validation to not report record changed by another user errors as this could be caused by two users logging into a terminal server at the same time. Added Right Click Menus to Enhanced Security Window to allow rolling down changes across multiple users and/or companies. Fixed Display Only Selected Users option on Enhanced Security window to show menu items which can be hidden as well as windows with access granted. Added Copy >> Field Value to the Resource Information window, useful if you need to get a non-editable field's value onto the clipboard. Version 18.05 build 29.3 (Released 16-Dec-2022) Installer: 18.05.0029.3 ----------------------------------------------------------------------- Installer Updated to Automatically start and stop the DynGPWebService windows service during installation. Fixed Database Validation Duplicate Error when User is a Database User in more than one non-GP Database. Version 18.05 build 29.3 (Released 05-Dec-2022) Installer: 18.05.0029.3 ----------------------------------------------------------------------- Added code to handle issue where Activity_GetBackgroundStatus() Dexterity function clears all Timed Background Processes. Restores GP, Report Scheduler and GPPT processes. Added code for additional handling to prevent Timed Background Processes duplicating when switching companies. Added Dex.ini Setting MBS_Debug_DisableTimedProccessRestore to allow Restoring of Timed Background Processes to be disabled. Version 18.05 build 29.3 (Released 26-Nov-2022) Installer: 18.05.0029.3 ----------------------------------------------------------------------- Fixed Screen Output Timeout to check Administrator Tools Registration at Login. Fixed Screen Output Resize to check Dex.ini Setting override. Version 18.05 build 29.3 (Released 26-Nov-2022) Installer: 18.05.0029.3 ----------------------------------------------------------------------- Fixed Launch File Validation issue with UNC Paths starting with double slash. Fixed typo on Email Settings window. Screen Output Auto Close Timer starts when the report has finished printing. Except if exiting, then a 1 second timer is started immediately to close the window as quickly as possible. Size, Position and State of Screen Output window can now be controlled for all reports when multiple reports are printed at the same time and not just the last report. Added Script Purpose Disabled checkbox to Runtime Execute Setup window so that custom script purpose scripts can be disabled, if required. Updated Runtime Execute Script Report to add Script Purpose Disabled checkbox. Updated handling for rw_ReportEnd, rw_ReportStart, rw_TableHeaderCurrency, rw_TableHeaderString, rw_TableLineCurrency, rw_TableLineString to support Disabled Checkbox. Updated handling for ServiceCreateCustom, ServiceDeleteCustom, ServiceGetCustom, ServicePostCustom, ServiceUpdateCustom to support Disabled Checkbox. Updated handling for SQLExecuteGotoHandler to support Disabled Checkbox. Updated handling for DrillBackHandlerCustom to support Disabled Checkbox. Updated handling for SLB_FillRunProcedureList, SLB_GetRunProcedureParameterCount, SLB_GetRunProcedureParameterName to support Disabled Checkbox. Updated Project Setup window to display status of Script Purpose Disabled checkbox from Runtime Execute Setup window. Updated Project Setup window to allow changing of Script Purpose Disabled checkbox via Update button or right click menus. Updated Project Setup Report to include list of resources attached to the project. Updated Project Setup Report to show Project Disabled checkbox. Version 18.05 build 29.2 (Released 08-Oct-2022) Installer: 18.05.0029.2 ----------------------------------------------------------------------- Updated Trigger handling for Scrolling Window Fill event to copy table buffer to window fields for both Before and After original script. Updated Trigger Setup window to remove After Original Delayed option for Scrolling Window Fill Events as it should not be used. Updated Dex.ini Settings window to adjust how the Manifest files were created for Bitmap Scaling to avoid issues with incorrect space character being used. Version 18.05 build 29.2 (Released 03-Oct-2022) Installer: 18.05.0029.2 ----------------------------------------------------------------------- Added fix for illegal address error on MBS_Switch_Company_FORM_PRE caused by Postmaster preventing switching companies. Enabled Parameter List Substitution when using SQL Lookup via Helper Function. Enabled Parameter List Substitution when Validating SQL Lookup via Helper Function. Added fix to remove duplicated Area Page Navigation Buttons. Fixed Parameter List Preview or Entry not working when Parameter ID was longer than 15 characters. Added Instance Path to Product Version Validation dialogs when showing mismatched products or missing products. Added Check to Parameter List Maintenance for SQL Lists and SQL Lookups to ensure Execute Script for all Companies is not enabled. Added Checks to Administrator Settings Additional User Defined for SQL Lookups to ensure Execute Script for all Companies is not enabled. Added message to Trigger Setup to explain that checking for form security is not necessary for non-modified, original forms. Updated Launch File Check to display the ID and Name of the first Product which uses an invalid path. Updated SQL Login Maintenance to suppress error messages for each login when updating multiple logins at a time. Updated Installer to allow Microsoft Dynamics GP to launched upon completion. Updated Installer to copy additional System DLLs needed to allow sending SMTP emails via .Net Addin to work. Updated Email Settings window to add option to include current session details in emails sent from the system. Updated Email Settings window to add placeholder substitution for current session details into the signature text. Updated Email Engine to handle new options to include current session details into signature. Added Project Disabled checkbox to Project Setup to stop any triggers within the project starting automatically on startup. Version 18.05 build 29.0 (Released 01-Sep-2022) Installer: 18.05.0029.0 ----------------------------------------------------------------------- Initial 18.5 Pre-release Build. Version 18.04 build 29.1 (Released 15-Aug-2022) Installer: 18.04.0029.1 ----------------------------------------------------------------------- Fixed issue MBS_Convert_Date and MBS_Convert_Datetime Helper Functions, also fixes MBS_SQL_Parse_Data_Date and MBS_SQL_Parse_Data_Datetime Helper Functions. Fixed issue with Runtime Execute Setup Report, not showing Script Purpose for the new methods for RW Functions. Fixed issue with Script Renaming which prevented MBS_Trigger_DisableSingle and MBS_Trigger_EnableSingle from renaming properly. Version 18.04 build 29.1 (Released 10-Aug-2022) Installer: 18.04.0029.1 ----------------------------------------------------------------------- System Features Module ---------------------- Screenshot Updated Screenshot's System Status Report to add check for the path to the folder where custom forms and reports dictionaries are located. Non-existent paths can cause unexpected issues. Added Background and Timed Processes to ScreenShot System Status report. Registration & Installation Change http:// hyperlinks to https:// for void need for redirection. Updated copyright notice for the year 2022. Added Please Wait Dialogs when opening the Registration window when it is communicating with the registration server. Fixed possible Illegal Address error if Registration window is closed immediately after clicking OK on Proxy Settings window. Fixed installation issue where Rockton Toolbox caused an Illegal Address Error while GP Power Tools was updating security records. Updated Table Upgrade system to confirm before upgrading version and table structures for a new build as this will force all workstations to be upgraded to match. Updated Navigation Bar installation code to be smarter to avoid duplicate entries or creating records before GP has created its entries. Configuration Maintenance Updated Configuration Maintenance window to allow sorting of the table list by columns. General Added Validation of Dictionary Path Folders in the Launch File and Dex.ini on application startup to avoid issues caused by invalid folder paths for custom forms and reports dictionaries. Added Dex.ini Setting MBS_Debug_ValidateLaunchFile to allow for Validation of Dictionary Path Folders in the Launch File and Dex.ini to be disabled (not recommended). Added extra check of Launch File product count versus number of lines check to identify corruption issues on startup. Updated Exit After Processes to close windows when selected and requeue itself if there are other processes in the queue behind it. Updated Exit after Processes option to use Report Writer Screen Output timeout feature to close report writer windows so that exit can continue. Updated Exit after Processes option to ensure process monitor queues are not suspended, so processes will complete and the application exit. Fixed newly introduced issue where Exit After Processes could go into an infinite loop when Exit After Processes selected more than once. Updated Table Cleanup Triggers for new tables for Form Control User Selection and Company Login Filter User Selection. Fixed Report Writer Screen Output memory that did not check if off screen when reading position data from SQL Window Memory Position table Added validation of OLEPath folder as defined in the Dex.ini to ensure it exists and has write permissions. Added validation that Global Dex.ini file can be written to. Use Dex.ini setting MBS_Debug_DexIniCheck=FALSE to disable (Not Recommended). Fix Dynamics GP Bugs Fixed bug in GP where and companies do not work correctly in a multi-lingual installation. Added feature to automatically fix display issues caused by incorrect Bitmap Fonts and Bitmap Scaling settings on installing. Settings can be changed on Dex.ini settings window. Administrator Tools Module -------------------------- Resource Information & Resource Finder Fixed Resource Information to stop form name being restored to the script name field when a form level procedure or function is not found. Fixed Resource Finder window so that it uses the correct field for the where clause for the data preview regardless of which field is selected in the right hand pane. Fixed Resource Finder window so that it works correctly with array and composite fields and generates the where clause for the data preview accordingly. Updated Resource Information and Resource Finder Windows to stop GP Power Tools trigger and script editing windows from updating the current resource. Updated Resource Information window to exclude Developer Tools Lookup windows so they don't change what Resource Information is showing. Updated Resource Explorer window to stop Unknown Identifier errors from MBS_Get_Constant() showing in the logs when using the Contants Explorer. Fixed Error from MBS_Get_Constant() when constant name contained special characters. Updated Resource Information window to add Table Description to the Options menu to make the Table Descriptions window available on Web Client. Updated Resource Information window to add Field Description to the Options menu to make the Field Descriptions window available on Web Client. Updated Resource Information window to add Window Description to the Options menu to make the Window Descriptions window available on Web Client. Updated Resource Information window to add Debug >> Expressions to the Options menu to open the Dexterity Script Debugger Expressions window. Updated Resource Information window to add Debug >> Watch to the Options menu to open the Dexterity Script Debugger Watch window. Updated Resource Information window to add Debug >> Table Buffers to the Options menu to open the Dexterity Script Debugger Table Buffers window. Updated Resource Finder window to add Table Description to the Options menu to make the Table Descriptions window available on Web Client. Updated Resource Finder window to add Field Description to the Options menu to make the Field Descriptions window available on Web Client. Updated Resource Finder window to add Window Description to the Options menu to make the Window Descriptions window available on Web Client. Updated Resource Finder window to add Debug >> Expressions to the Options menu to open the Dexterity Script Debugger Expressions window. Updated Resource Finder window to add Debug >> Watch to the Options menu to open the Dexterity Script Debugger Watch window. Updated Resource Finder window to add Debug >> Table Buffers to the Options menu to open the Dexterity Script Debugger Table Buffers window. Administrator Settings Updated Administrator Settings to ensure that when Window Position Memory is enabled, the Prevent windows opening outside of the Desktop option is also enabled. Added MBS_CompanyColorGet and MBS_CompanyColorGetRGB functions which can be by VSTools applications to get the current company colours being used as numeric values or RGB values. Updated Administrator Settings window layout for new feature including moving some features to different tabs. Fixed issue with Administrator Settings window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Updated Administrator Settings window to use fixed and company functionality. Added Users Button to Additional License sensitive level of Automatic Logout on the Administrator Settings window to allow finer control of which users are affected. Added First optional custom override level of Automatic Logout to the Administrator Settings window to be used with Users Button to allow finer control of the time used for logging users out. Added Second optional custom override level of Automatic Logout to the Administrator Settings window to be used with Users Button to allow finer control of the time used for logging users out. Added Option for Timed Hours and Active Days to Automatic Logout to allow it to only function out of hours and on weekends for all or selected users. Updated Administrator Settings window to support Timed Hours and Active Days for Automatic Logout functionality. Fixed Automatic Logout to ensure that if an override Logout time is less than the User Count Logout time, the shorter time is used when the available licenses are low. Added Report Writer Screen Output timeout so that Report Writer window will close automatically if left open too long, thus allowing background queue to process. Added Report Writer Screen Output timeout to Usability tab of Administrator Settings window with default value of 5 minutes. Added Per user controls for Report Writer Screen Output timeout in Administrator Settings window. Email Settings Updated Email Settings with new SMTP via .Net Addin mode which supports the TLS protocol needed to to communicate with Office 365 mail servers (smtp.office365.com:587). Updated Email Engine to call the new function added to the Visual C# Addin DLL using the MimeKit and MailKit libraries to support sending of emails using SSL and TLS protocols. Dictionary Control Fixed issue with Dictionary Control window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Updated Dictionary Control window to add a Redisplay Button. Fixed Dictionary Control window bug where the move to end button actually moved the product to the second last position. Dex.ini Configuration Updated Dex.ini Configuration window to ensure there is no equals sign used when using exact match setting mode. Company Login Filter Fixed issue with Company Login Filter window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Updated Company Login Filter to add User Selection for each Company for each Launch File Path. Prevents users logging into a company even though access is granted. Updated Company Login Filter to add a Shared User Settings mode so that user company settings do not have to be selected for every Launch File Path in the profile. Updated Company Login Filter window to add option to roll out Profile ID to all workstations using Dex.ini Configuration. Adds or removes setting automatically. Dynamics Product Selection Fixed issue with Dynamic Product Selection window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Product Version Validation Updated Product Version Validation window to fix exporting of listview data to correct an incorrect column sequence issue. Updated Product Version Validation to record version mismatch information to the GP Power Tools User & Company Logs. Updated Product Version Validation to stop it opening the version mismatch dialog when running on a Process Server or when in Service Mode. Updated Product Version Validation window to support mutliple instances installed on a single workstation and track product dictionary versions for each. Updated Product Version Validation window to show the path for the dictionary file for each product dictionary tracked. Website Settings Updated Website Settings for version 18.4 and later to replace repurposing the removed Intelligent Cloud Insights with a GP Power Tools custom website tab. Developer Tools Module ---------------------- Project Setup Updated Project Setup so it will not ask to start triggers when closing the window if the Start >> All triggers option has been used. Updated Tables, Windows and Reports to extend Project Setup window Project ID field from 15 characters to 25 characters. Updated Tables, Windows and Reports to extend Project Setup window Project Description field from 60 characters to 100 characters. Updated Project Setup window to offer to start project triggers when opening resources with the Open Form zoom button or the Open Form or Report button. Updated Project Setup window to not ask about starting triggers when exiting to Report Writer or Modifier. Fixed issue with Project Setup window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Updated Project Setup window to check for project triggers running before zooming to related windows or reports. Before it just checked for any triggers. Fixed Project Setup window to ensure Trigger Setup window is closed when starting triggers. Updated Project Setup window and all child windows to keep current resources displayed when refreshing the Project Resources Lists. Updated Project Setup window to allow selection of multiple resources using shift and control key modifiers when selecting resources. Updated Project Setup window to allow Update Triggers/Scripts button to work for selected resources in the listview as well as the existing all resources mode. Updated Project Setup window to display when a trigger is Started using a checkbox and Status column. Updated Project Setup window to maintain selected items when refreshing the resource listview. Updated Project Setup window to add starting and stopping of selected triggers. Updated Project Setup window to allow triggers to be started and stopped by clicking on their state checkbox. Updated Project Setup window to enable right click menus on resources. Updated Project Setup window to include an Export Compatibility Warning to identify if a project is compatible with Build 28 or earlier due to field lengths being increased. Added User Level Dex.ini Setting MBS_Debug_ExportCompatibilityWarning to control Export Compatibility Warning, can be controlled via Project Setup window Options menu. Updated Project Setup window to handle multiple selections when using the right click menus on resources. Fixed issue on Project Setup window where Customization Maintenance resources for new projects were not being saved the first time. Updated Project Setup window to add a Status line showing the counts of all the objects in the window. Updated Project Setup window to ensure the Trigger Setup window is closed before being able to start individual triggers using the checkboxes. Updated Project Setup window to add Open Resource option to the right click menu. Updated Project Setup window to add Execute Script option to the right click menu with support for Parameter Lists. Updated Project Setup window to not ask to start triggers everytime when opening windows or executing scripts. Once No has been selected the dialog will not be shown until a resource is saved. Updated Project Setup window to add Trigger Status window to Start and Stop buttons as well as the Add button. Updated Project Setup window Duplicate Entire Project feature to allow selection of the method used to name the duplicated resources. Updated Project Setup window to add Debug >> Expressions to the Options menu to open the Dexterity Script Debugger Expressions window. Updated Project Setup window to add Debug >> Watch to the Options menu to open the Dexterity Script Debugger Watch window. Updated Project Setup window to add Debug >> Table Buffers to the Options menu to open the Dexterity Script Debugger Table Buffers window. Updated Project Setup window to offer to close and re-open window being zoomed to if triggers have just been started to ensure triggers are active. Trigger Setup Added Read Table syntax construct to the Insert Button on the Trigger Setup window. Added Save Table syntax construct to the Insert Button on the Trigger Setup window. Added Delete Table syntax construct to the Insert Button on the Trigger Setup window. Updated Trigger Setup to automatically enable the Check Security checkbox on the Script tab when the Modified checkbox is selected. Updated Trigger Setup window to stop it asking to enable triggers when triggers were not stopped as the user responded No to the prompt. Updated Focus Trigger Handling to add a force change command to a field when keeping the focus on the field to force the change script to execute; Updated Tables, Windows and Reports to extend Trigger Setup window Trigger ID field from 15 characters to 25 characters. Updated Tables, Windows and Reports to extend Trigger Setup window Trigger Description field from 60 characters to 100 characters. Updated Trigger Lookup to allow filtering of returned data to only include objects for the selected project of where the lookup was called from, or the current project, or no filter. Updated Trigger Lookup to show 5 additional fields for Trigger Type, Trigger Event, Trigger Attach, Product and Form. Updated Trigger Setup window to add new After Login trigger event attach modes for delayed, background and after background. Added Triggering on Window Print Focus Event to Trigger Setup window. Added Log Entry when Trigger is started as Disabled to help identify why a trigger might not be active. Also shows as disabled on the Trigger Status window. Fixed Trigger Handling scripts to prevent Disabled triggers being re-enabled by the recursion protection system which disables and re-enables triggers to prevent recursion. Added Trigger After Delayed attach mode to Focus Triggers (except modal dialogs). This helps will timing issues as it will run after the current call stack has completed. Updated Trigger Setup window to not ask about starting triggers when exiting to Report Writer or Modifier. Fixed issue with Trigger Setup window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Fixed Reject Script option not working on Focus Triggers after changes to support running the trigger after delayed was added. Fixed Reject Record option not working on Focus Triggers after changes to support running the trigger after delayed was added. Fixed issue where Triggers Registered for Procedures with Parameters or Functions with Parameters Before Original actually registered After Original. Changed Parameter Name for Arguments passed to trigger script for Procedures with Parameters or Functions with Parameters from IN_Args to INOUT_Args. Updated Trigger Status window to refresh Project Setup window when triggers are started and stopped or enabled and disabled. Fixed Record Created by Another User error on Trigger Setup window after using Rename Trigger or Duplicate Trigger functionality while window is open. Added Trigger Script Clipboard window which can store a copy of a script when it is cleared or changed when trigger settings or resource settings are changed. Fixed Script Clipboard dialog showing twice in certain situations on Trigger Setup window. Fixed Scheduled Trigger handler to not write log entry when Minimize Log Entries is enabled. Updated Trigger Setup window to add Debug >> Expressions to the Script menu to open the Dexterity Script Debugger Expressions window. Updated Trigger Setup window to add Debug >> Watch to the Script menu to open the Dexterity Script Debugger Watch window. Updated Trigger Setup window to add Debug >> Table Buffers to the Script menu to open the Dexterity Script Debugger Table Buffers window. Updated Trigger Setup window Insert Code Button to add Import .Net Assembly option to add fully qualified import statement to beginning of script. Trigger Status Added Options Menu to Trigger Status window with options to open Customization Maintenance, Customization Status, Process Monitor, About Dexterity and Dexterity's Hidden About window. Runtime Execute Setup Added Read Table syntax construct to the Insert Button on the Runtime Execute Setup window. Added Save Table syntax construct to the Insert Button on the Runtime Execute Setup window. Added Delete Table syntax construct to the Insert Button on the Runtime Execute Setup window. Fixed Runtime Execute Setup window to keep selected text when using the Script >> Save and Continue (Ctrl-S) menu option. Updated Tables, Windows and Reports to extend Runtime Execute Setup window Script ID field from 15 characters to 25 characters. Updated Tables, Windows and Reports to extend Runtime Execute Setup window Script Name field from 60 characters to 100 characters. Updated Runtime Execute Lookup to allow filtering of returned data to only include objects for the selected project of where the lookup was called from, or the current project, or no filter. Fixed issue with Runtime Execute Setup window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Updated Runtime Execute window to check for project triggers running before executing the script if the script belongs to a project with triggers. Updated Runtime Execute Setup window to fix conversion of carriage returns if they were missed during import. Fixed Runtime Execute Setup window to ensure Trigger Setup window is closed when starting triggers. Updated Runtime Execute Setup window to only ask if project triggers should be started once when a parameter list is in use. Added Runtime Execute Clipboard window which can store a copy of a script when it is changed when settings are changed. Updated Runtime Execute Setup window to not ask to start triggers everytime when opening windows or executing scripts. Once No has been selected the dialog will not be shown until the script is saved. Updated Runtime Execute Setup window to add Debug >> Expressions to the Script menu to open the Dexterity Script Debugger Expressions window. Updated Runtime Execute Setup window to add Debug >> Watch to the Script menu to open the Dexterity Script Debugger Watch window. Updated Runtime Execute Setup window to add Debug >> Table Buffers to the Script menu to open the Dexterity Script Debugger Table Buffers window. Updated Runtime Execute Setup window Insert Code Button to add Import .Net Assembly option to add fully qualified import statement to beginning of script. Updated Runtime Execute Setup window with faster Memory based Parameter version of the rw_ReportStart Custom RW Function. Updated Runtime Execute Setup window with faster Memory based Parameter version of the rw_ReportEnd Custom RW Function. Updated Runtime Execute Setup window with faster Memory based Parameter version of the rw_TableHeaderString Custom RW Function. Updated Runtime Execute Setup window with faster Memory based Parameter version of the rw_TableHeaderCurrency Custom RW Function. Updated Runtime Execute Setup window with faster Memory based Parameter version of the rw_TableLineString Custom RW Function. Updated Runtime Execute Setup window with faster Memory based Parameter version of the rw_TableLineCurrency Custom RW Function. SQL Execute Setup Added if else syntax construct to the Insert Button on SQL Execute Setup window. Added case when syntax construct to the Insert Button on SQL Execute Setup window. Added while loop syntax construct to the Insert Button on SQL Execute Setup window. Added Cursor Statements syntax construct to the Insert Button on SQL Execute Setup window. Updated Tables, Windows and Reports to extend SQL Execute Setup window Script ID field from 15 characters to 25 characters. Updated Tables, Windows and Reports to extend SQL Execute Setup window Script Name field from 60 characters to 100 characters. Updated SQL Execute Lookup to allow filtering of returned data to only include objects for the selected project of where the lookup was called from, or the current project, or no filter. Fixed issue with SQL Execute Setup window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Fixed Dexterity Field and Table reference conversion on SQL Execute Setup window to correctly handle when field name contains "table", eg Editable. Updated SQL Execute Setup window to fix conversion of carriage returns if they were missed during import. Added Find Button to search returned data with Find First, Find Next and Options to SQL Execute Setup window. Updated SQL Execute Setup window to set the focus to the first record of the returned result set after executing the SQL script. Fixed SQL Execute Setup window so that tab characters are inserted into the text data returned when empty columns are returned at the beginning of the row. Updated SQL Execute Setup window to automatically convert references to the DYNAMICS database to the actual system database if it is not DYNAMICS. Updated SQL Execute Setup window to add right click menus for SQL Gotos on the results list. Supports up to 40 Gotos on right click menus. Added SQL Execute Clipboard window which can store a copy of a script. SQL Executer Added Find Button to search returned data with Find First, Find Next and Options to SQL Executer window. Updated SQL Executer window to set the focus to the first record of the returned result set after executing the SQL script. Fixed SQL Executer window so that tab characters are inserted into the text data returned when empty columns are returned at the beginning of the row. Updated SQL Executer window to automatically convert references to the DYNAMICS database to the actual system database if it is not DYNAMICS. Updated SQL Executer window to add right click menus for SQL Gotos on the results list. Supports up to 40 Gotos on right click menus. SQL Results Added Find Button to search returned data with Find First, Find Next and Options to SQL Results window. Updated SQL Results window to set the focus to the first record of the returned result set after executing the SQL script. Updated SQL Results window to make pressing Enter run the first GoTo or close the window is no GoTos are in use. Fixed SQL Results window so that tab characters are inserted into the text data returned when empty columns are returned at the beginning of the row. Updated SQL Results window to automatically convert references to the DYNAMICS database to the actual system database if it is not DYNAMICS. Updated SQL Results window to add right click menus for SQL Gotos on the results list. Supports up to 40 Gotos on right click menus. Added second SQL Results window to allow developers to have two sets of SQL Data displayed at the same time. .Net Execute Setup Added Read Table syntax construct to the Insert Button on the .Net Execute Setup window. Added Save Table syntax construct to the Insert Button on the .Net Execute Setup window. Added Delete Table syntax construct to the Insert Button on the .Net Execute Setup window. Updated Tables, Windows and Reports to extend .Net Execute Setup window Script ID field from 15 characters to 25 characters. Updated Tables, Windows and Reports to extend .Net Execute Setup window Script Name field from 60 characters to 100 characters. Updated .Net Execute Lookup to allow filtering of returned data to only include objects for the selected project of where the lookup was called from, or the current project, or no filter. Fixed issue with .Net Execute Setup window where user and/or company selection was losing selections made on User Class, Security Role ID, Security Task ID, Security ModAlt ID. Updated .Net Execute window to check for project triggers running before executing the script if the script belongs to a project with triggers. Updated .Net Execute Setup window to fix conversion of carriage returns if they were missed during import. Fixed .Net Execute window to ensure Trigger Setup window is closed when starting triggers. Updated .Net Execute Setup window to only ask if project triggers should be started once when a parameter list is in use. Updated .Net Execute system to only compile and generate a Memory Assembly once per session if the code and references have not been changed. Fixed .Net Execute for VB.Net to show Compilation Status results when executing code. Updated .Net Execute system to allow code to be changed to RunOnce so that the script will only compile and execute once per session. Added Caching to .Net Execute system for improved performance and better memory usage by using already compiled code already stored in a memory assembly. Updated .Net Execute window to note that using Parameter List Placeholders will change the script forcing it to recompile affecting performance and using more memory. Added .Net Execute Clipboard window which can store a copy of a script when it is changed when settings are changed. Updated .Net Execute window to suggest using Parameter List Helper Functions rather than inserting Parameter List Placeholders for better performance and memory usage. Updated .Net Execute Setup window to not ask to start triggers everytime when opening windows or executing scripts. Once No has been selected the dialog will not be shown until the script is saved. Updated .Net Execute Setup window Add References Button to add Import .Net Assembly option and automatically add using or Imports statements as needed. Parameter List Maintennace Updated Parameter List Maintenance to check for Order By statements in the SQL Execute scripts used for SQL Lists and SQL Lookups and allow or block usage accordingly. Updated Tables, Windows and Reports to extend Parameter List Maintenance window Parameter ID field from 15 characters to 25 characters. Updated Tables, Windows and Reports to extend Parameter List Maintenance window Parameter Description field from 60 characters to 100 characters. Updated Parameter List Lookup to allow filtering of returned data to only include objects for the selected project of where the lookup was called from, or the current project, or no filter. Messages Setup Updated Tables, Windows and Reports to extend Messages Setup window Messages ID field from 15 characters to 25 characters. Updated Tables, Windows and Reports to extend Messages Setup window Messages Description field from 60 characters to 100 characters. Updated Message Lookup to allow filtering of returned data to only include objects for the selected project of where the lookup was called from, or the current project, or no filter. Helper Functions Added MBS_SQL_Set_Database Helper Function to change default from current Company Database for the next SQL Script Executed from code. Added MBS_SQL_Get_Data Helper Function to quickly return a tab delimited data set from SQL. It is about 10 times fast that MBS_SQL_Check_Exists for large data sets. Added MBS_Return_By_Field and MBS_Return_By_Reference Helper Functions to help with setting window fields when old() or diff() commands are used in the field change script. Added MBS_SQL_Parse_Data series of Helper Functions to retrieve data for the row and column specified from a tab delimited data set. Use with MBS_SQL_Get_Data or MBS_SQL_Check_Exists. Added MBS_Arguments_Set_Value Helper Function to allow updating of Arguments for Procedures and Functions from the trigger handling script. Added MBS_Set_Window_Value_Focus_Immediate Helper Function to allow focus to be changed immediately rather than after all code is completed. Added MBS_Set_Window_Value_Modified_Focus_Immediate Helper Function to allow focus to be changed immediately rather than after all code is completed. Added MBS_Script_Load_SQL_DB Helper Function, similar to MBS_Script_Load_SQL but also passes out database context to use. Added MBS_SQL_Execute Helper Function, similar to MBS_SQL_Check_Exists Helper Function but also passes in database context to use, but also support MBS_SQL_Set_Database. Added MBS_Parameter_Open Helper Function to open the previous Loaded Parameter Listed Dialog to user interaction, which runs a specified Script ID when OK clicked. Added MBS_Map Series of Helper Functions to help with driving the User Interface by setting window fields as though changed by the user. Added MBS_Map_By_Field and MBS_Map_By_Reference Helper Functions to help with driving the User Interface by setting window fields as though changed by the user. Added MBS_SQL_Results_Immediate and MBS_SQL_Results_Immediate_Goto Helper Functions which display the query results immediately rather than executing the script delayed. Added MBS_SQL_Results_Close Helper Function to close the SQL Results window. Can use with the MBS_SQL_Results_Immediate and MBS_SQL_Results_Immediate_Goto Helper Functions. Added MBS_CompanyColorGetRGB Helper Function to get RGB colors from current Company Color Themes. Added MBS_Copy_To_Clipboard Helper Function to copy text data to the Windows Clipboard. Added MBS_Copy_From_Clipboard Helper Function to copy text data from the Windows Clipboard. Added MBS_SQL_Parse_Data_Reset Helper Functions to manually reset parsing counters when not using MBS_SQL_Execute, MBS_SQL_Check_Exists or MBS_SQL_Get_Data. Added MBS_SQL_Results2, MBS_SQL_Results_Goto2, MBS_SQL_Results_Immediate2, MBS_SQL_Results_Immediate_Goto2, MBS_SQL_Results_Close2 Helper Functions. Added MBS_Convert series of Helper Functions to allow for converting data to correct datatypes and provide handling of alternative formats and extra characters. Added MBS_Show_Desktop_Alert Helper Function to allow for display a message using a Desktop Alert Added MBS_Trigger_Disable and MBS_Trigger_Enable Helper Functions to mark a trigger as disabled or enabled in the setup table. Updated Helper Functions window to add support for new MBS_SQL_Set_Database Helper Function for setting database context for next command. Updated Helper Functions window to add support for new MBS_SQL_Get_Data Helper Function. Updated Helper Functions window to add support for new MBS_Return_By_Field and MBS_Return_By_Reference Helper Functions. Updated Helper Functions window to add support for new MBS_SQL_Parse_Data series of Helper Functions to retrieve data for the row and column specified from a tab delimited data set. Updated Helper Functions window to add support for new MBS_Arguments_Set_Value Helper Function. Updated Helper Functions window to add support for new MBS_Set_Window_Value_Modified_Focus_Immediate Helper Function. Updated Helper Functions window to add support for new MBS_Set_Window_Value_Focus_Immediate Helper Function. Updated Helper Functions window to use support for new MBS_SQL_Execute Helper Function when executing a SQL Execute scriptID. Updated Helper Functions window to add support for new MBS_Parameter_Open Helper Function to be able to manually open the Parameter List Dialog. Updated Helper Functions window to add support for new MBS_Map Series of Helper Functions. Updated Helper Functions window to add support for new MBS_Map_By_Field and MBS_Map_By_Reference Helper Functions. Updated Helper Functions window to add support for new MBS_SQL_Results_Immediate and MBS_SQL_Results_Immediate_Goto Helper Functions. Updated Helper Functions window to add support for new MBS_SQL_Results_Close Helper Functions. Updated Helper Functions window to add support for new MBS_CompanyColorGetRGB Helper Function. Updated Helper Functions window to add support for new MBS_Copy_To_Clipboard Helper Function. Updated Helper Functions window to add support for new MBS_Copy_From_Clipboard Helper Function. Updated Helper Functions window to add support for new MBS_SQL_Parse_Data_Reset Helper Function. Updated Helper Functions window to add support for new MBS_SQL_Results2, MBS_SQL_Results_Goto2, MBS_SQL_Results_Immediate2, MBS_SQL_Results_Immediate_Goto2, MBS_SQL_Results_Close2 Helper Functions. Updated Helper Functions window to add support for new MBS_Convert series of Helper Functions. Updated Helper Functions window to add support for new MBS_Show_Desktop_Alert Helper Function. Updated Helper Functions window to add support for new MBS_Trigger_Disable and MBS_Trigger_Enable Helper Functions. Updated MBS_SQL_Check_Exists, MBS_SQL_Results, MBS_SQL_Results_Goto and MBS_Export_SQL_Query_To_File Helper Functions to work with MBS_SQL_Set_Database Helper Function. Updated MBS_SQL_Check_Exists, MBS_SQL_Results, MBS_SQL_Results_Goto and MBS_Export_SQL_Query_To_File Helper Functions to automatically convert references to the DYNAMICS database if needed. Updated MBS_SQL_Get_Data and MBS_SQL_Check_Exists Helper functions to return EOF (16) when there is an overflow of data returned and truncate the data to remove any partial data rows. Updated MBS_Arguments_Get_Type Helper Function to support marking Arguments as changed for use with MBS_Arguments_Set_Value Helper Function. Updated MBS_Arguments_Get_Value Helper Function to support marking Arguments as changed for use with MBS_Arguments_Set_Value Helper Function. Fixed MBS_SQL_Check_Exists Helper Function so that tab characters are inserted into the text data returned when empty columns are returned at the beginning of the row. Fixed Helper Functions window to improve scripts inserted for the MBS_Get_Window_Value_Modified and MBS_Set_Window_Value_Modified series of Helper Functions. Updated MBS_SQL_Get_Data Helper Function to pass in database context to use, but also support MBS_SQL_Set_Database. Updated Helper Functions window so that Lookups to allow filtering of returned data to only include objects for the selected project of where the Helper Functions window was opened. Fixed MBS_SQL_Results_Goto Helper Function not being used for .Net scripts when Gotos checkbox was selected on the Helper Functions window. Updated Helper Functions window to use MBS_Script_Load_SQL_DB Helper Function when loading and executing a SQL Execute Script ID. Updated Helper Functions window to add option to insert MBS_Parameter_Set_* commands for all Parameters when inserting MBS_Parameter_Load Helper Function. Updated Helper Functions window to add option to insert MBS_Parameter_Set_* commands for all Parameters when inserting Runtime Execute Scripts with Parameter Lists associated. Updated Helper Functions window to add option to insert MBS_Parameter_Set_* commands for all Parameters when inserting SQL Execute Scripts with Parameter Lists associated. Updated Helper Functions window to add option to insert MBS_Parameter_Set_* commands for all Parameters when inserting .Net Execute Scripts with Parameter Lists associated. Updated Helper Functions window to default in Parameter List ID from the calling window when using Parameter List related Helper Functions. Updated MBS_SQL_Parse_Data series of Helper Functions to improve handling of alternative formats and extra characters. Script Renaming Fixed Script Renaming feature to rename scripts referenced using the MBS_SQL_Results_Goto Helper Function. Fixed Script Renaming feature to rename multiple scripts referenced in the same code text field. It was sometimes missing renaming of scripts when they occurred more than once. Fixed Automatic Renaming of References for MBS_SQL_Lookup, MBS_SQL_Lookup_Validate, MBS_SQL_Lookup_Parameter, MBS_SQL_Lookup_Parameter_Validate and MBS_Form_Lookup_Parameter Helper Functions. Database Tools Module --------------------- Database Validation Updated Database Validation window to look for and fix database users for the current GP system in non-GP databases, such as external databases used by integrating products. Version 18.04 build 28.0 (Released 01-Sep-2021) Installer: 18.04.0028.0 ----------------------------------------------------------------------- Initial 18.4 Pre-release Build. Version 18.03 build 28.9 (Released 17-Aug-2021) Installer: 18.03.0028.9 ----------------------------------------------------------------------- Added MBS_Exit_After_Processes and MBS_Switch_Company Helper Functions to allow triggers and scripts to change companies or exit the application. Updated Helper Functions window to add support for new Exit Dynamics GP Application and Switch Dynamics GP Company functions. Added MBS_Runtime_Execute_After_Background and MBS_Runtime_Execute_Modified_After_Background Helper Functions to run scripts in the foreground after background processes have completed. Updated Helper Functions window to add support for executing Dexterity Scripts in the foreground after background processing has completed. Fixed issue in multiple GP Power Tools window where the window could be closed just before a record was displayed and it would generate a Dexterity exception. Fixed Helper Functions window with new After Background Option incorrectly showing at all times. Version 18.03 build 28.9 (Released 12-Aug-2021) Installer: 18.03.0028.9 ----------------------------------------------------------------------- Fixed Launch File Configuration to display correct message and restart application after changes have been made to the Launch File. Added DUOS SY_User_Object_Store (SY90000) Table to performance fix for Report Writer when used with custom with RW Functions. Fixed Runtime Execute window where Execute Button would be enabled for custom Script Purposes when returning to the window from other windows. Updated Runtime Execute Setup window to add additional information to compilation errors when executing against modified dictionaries. Updated Helper Functions window to automatically select Execute against Modified Dictionary when the script is marked as Modified. Updated Trigger Setup window template scripts to not use default form to and default window to commands as they can cause scripts to fail without warnings. Updated Trigger Setup window to add additional information to compilation errors when executing against modified dictionaries. Updated Project Setup window to allow starting and stopping of all Automatic Starting Triggers without having a Project loaded on the window. Updated Messages Setup window to ensure that the default language of 0 is always listed as a fall back on multilingual systems. Added functionality to store field references as Memory variables, thus allowing fields passed between Product Dictionaries or between modified and original dictionaries. Added MBS_Memory_Set_Field Helper Functions to capture field references, existing functions MBS_Memory_Get_Reference, MBS_Memory_Del_Reference already work for field references. Updated Helper Functions window to add support for new field Reference functionality. Note: Only works for Dexterity based scripts. Version 18.03 build 28.8 (Released 17-Jun-2021) Installer: 18.03.0028.8 ----------------------------------------------------------------------- Fixes to Report Writer Screen Output memory to prevent other windows being maximized incorrectly. Fixes to Report Writer Screen Output memory to prevent window size and position drifting by a few pixels each time it is opened. Fixes to Report Writer Screen Output memory to prevent window flashing after multiple reports are printed by a single process. Fixes to Report Writer Screen Output memory to prevent loss of memory settings after multiple report are printed by a single process. Due to limitations in the way the Microsoft maximized the Screen Output window in v18.3 onwards, only the last report in a single process can be controlled. Updated Automatic Logout processing code to write log entries when windows have been successfully saved or closed. Updated Additional User Information functionality to populate Default Site ID into Site ID for POP Requisitions, POP PO Entry and POP Receivings Entry windows. Updated User Activity Log window to change the heading for cancelling of the Automatic Logout Dialog from "Auto Dialog" to "Auto Cancel". Fixed Microsoft Dynamics GP Bug. Marking a user as inactive in the User Setup Window, now updates the Date Inactivated column in the SY_Users_MSTR (SY01400) table. Added functionality to store table references as Memory variables, thus allowing table buffers to be captured in one trigger and used in another. Added MBS_Memory_Set_Reference, MBS_Memory_Get_Reference, MBS_Memory_Del_Reference & MBS_Memory_Set_Table Helper Functions. Updated Helper Functions window to add support for new table Reference functionality. Note: Only works for Dexterity based scripts. Updated Helper Functions window to add option to load Parameter List before loading and executing Runtime Execute, SQL Execute or .Net Execute scripts. Updated Project Setup window to select the Export linked custom resources package on export and import package on import option when selecting custom resources. Added new table to store Project based User and Company selection settings and added to table creation and import export functionality. Added User and Company selection settings to Project Setup window. Triggers belonging to a project will only be enabled if the Project and the Trigger are enabled. Updated Project Setup window to add an expansion button to open a Long Description window where more information about the Project can be stored. Updated Project Setup window to enable importing of packages without selecting a creating a project first so new projects can be imported easily. Updated Trigger Setup window to make Non Logging Trigger and Minimize Log Entries checkboxes selected by default. Added option to Trigger Setup window to specify a trigger to start as temporarily disabled when it is registered. Added option to Trigger Setup window to automatically temporarily disable a trigger after it has been executed. Updated Trigger Setup window to add an expansion button to open a Long Description window where more information about the Trigger can be stored. Updated Trigger Setup window so that it also issues an abort close command when reject script is executed. This will prevent a window closing. Updated Runtime Execute Setup window to Minimize Log Entries checkbox selected by default. Updated Runtime Execute Setup window to add an expansion button to open a Long Description window where more information about the Script can be stored. Updated Runtime Executer window to display the Long Description field with more information about the script. Fixed SQL Execute Setup window to avoid record locked error showing sometimes when duplicating scripts. Updated SQL Execute Setup window to Minimize Log Entries checkbox selected by default. Updated SQL Execute Setup window to add an expansion button to open a Long Description window where more information about the Script can be stored. Updated SQL Executer window to display the Long Description field with more information about the script until script executed. Added Redisplay Button to the SQL Results window to allow query results to be manually refreshed. Updated .Net Execute Setup window to Minimize Log Entries checkbox selected by default. Updated .Net Execute Setup window to add an expansion button to open a Long Description window where more information about the Script can be stored. Updated .Net Executer window to display the Long Description field with more information about the script until script executed. Updated Resource Explorer code for reading dictionary resources to avoid possible duplicate records errors. Version 18.03 build 28.7 (Released 10-May-2021) Installer: 18.03.0028.7 ----------------------------------------------------------------------- Updated Project Setup window to fix possible infinite loop when duplicating entire project. Updated Helper Functions window to fix typo on helper function selection button drop down menus. Version 18.03 build 28.7 (Released 03-May-2021) Installer: 18.03.0028.7 ----------------------------------------------------------------------- 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. Fixed Automatic Logout still being active when using Report Writer or Modifier to customize Microsoft Dynamics GP. 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. Updated Administrator Settings window to add control of the User Date Change Dialog. This will prevent the dialog interfering with the Automatic Logout functionality. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. Version 18.03 build 28.6 (Released 19-Feb-2021) Installer: 18.03.0028.6 ----------------------------------------------------------------------- Fixed Website Settings not being applied when switching companies back to same user and company. Added support for Pulling Window Focus Action for Table Restricted to Form, Form Level Procedures/Functions and Focus Event Modal Dialogs. Updated Company Login Filter feature to ignore a remembered company if the Hide Remember Company option is enabled. Updated Company Login Filter feature to better handle when Remember Company option is used on the Company Login window. Updated Dex.ini Setting writing code to log if the Dex.ini setting fails to write correctly to the Dex.ini file. Fixed MBS_Activity_Cleanup: Invalid object name 'CO00201' by updating syVendorAnalysisDeleteTrigger to handle multiple companies and confirm databases are online. Added warning to Dex.ini Settings window when activating Dexterity Profile logging on startup of Microsoft Dynamics GP to avoid possible crashing. Added checks when Dexterity Profile logging on startup to temporarily disable the profiling for specific products to avoid possible crashing. Updated Product Version Validation window to show the Machine ID column before the date and time columns. Updated Product Version Validation window to show the User ID and Windows User Name columns for the user which last updated the records. Updated Product Version Validation window to allow deleting of a product from all workstations when deleting that product from the system level. Updated Product Version Validation window to allow deleting of all records for a workstation that is no longer in the system. Updated Trigger Setup to allow Desktop Alerts to be selected as Information, Warning, Error or Debug modes like System Dialogs. Updated the GP Power Tools Email Engine to support sending emails using Office 365 (Exchange Web Services) with Multi-Factor Authentication. Updated Capture Screenshots window to use Administrator Settings option for using desktop alerts rather than system dialogs for messages after saving or emailing. Updated Resource Explorer window to read all scripts even when only Service Procedures needed, to maintain data integrity when products are updated. Updated Database Validation window to improve performance when running the Process function to read all the Dexterity tables and views and check their status in SQL. Added trigger to display physical (SQL) and technical (Dexterity) table names to the Microsoft Dynamics GP SQL Maintenance window. Updated Database Validation window to disable triggers and logging when the window is opened. Updated Database Validation window to offer to open the connection to the email service or application if it is not open when resetting passwords. Updated SQL Login Maintenance window to offer to open the connection to the email service or application if it is not open when resetting passwords. Updated Activity Cleanup code to not use standard GP syUserInRole() function as this would stop shortcuts being displayed when Remember Company was used. Version 18.03 build 28.5 (Released 19-Jan-2021) Installer: 18.03.0028.5 ----------------------------------------------------------------------- Updated Runtime Execute window so that a Script Purpose can be passed into the window when creating a new script. Updated SQL Execute Setup window to pass the Project ID and Script Purpose to the Runtime Execute Window when creating a SQL Goto. Updated Parameter List Maintenance to pass the Project ID to the SQL Execute Setup window when creating SQL based Lookups or Lists. Updated Parameter List Maintenance to avoid (ASCII 255) characters being displayed in empty "To" fields when entering Parameter values. Fixed trigger code that restores field values to previous value for Modifier added fields on Modified Windows. Fixed trigger code so that triggers on Modifier added buttons on Modified Windows do not show as "Secondary" triggers. Version 18.03 build 28.5 (Released 13-Jan-2021) Installer: 18.03.0028.5 ----------------------------------------------------------------------- Fixed MBS_Activity_Cleanup Invalid object name 'CO00201' Error by adding in exception handling to syVendorAnalysisDeleteTrigger trigger on ACTIVITY table in system database. Version 18.03 build 28.5 (Released 08-Jan-2021) Installer: 18.03.0028.5 ----------------------------------------------------------------------- Fixed Trigger handler for change event secondary read trigger for modified fields to use correct handler script. Version 18.03 build 28.5 (Released 02-Jan-2021) Installer: 18.03.0028.5 ----------------------------------------------------------------------- Fixed minor UI fault on SQL Execute Setup window. Added MBS_Debug_WCBackground Dex.ini Setting to force background processing of GP Power Tools during login on the Web Client. Updated Trigger Setup Window to not allow the Reject Script option to be used with the Field Changed and Modal Dialog focus events. Updated Trigger Setup - Administration Window to show when Minimize Log Entries is selected on the Logging status column. Updated Project Setup Window to show columns for Trigger Disabled, Automatic Start, Non-Logging & Minimize Log Entries settings. Updated Project Setup Window to show display script Minimize Log Entries settings in the new Logging status column. Updated Report Screen Output Memory to remember maximized or normal state and restore state, even on v18.3 which maximizes by default. Added Update Triggers Button to Project Setup window to mark all triggers as Disabled, Enabled, Automatic Start or Manual Start. Added Minimize Logs or Full Logs for Triggers and Scripts to the Update Triggers Button on the Project Setup window. Prevent shortcut access to modal and internal windows. Updated Company Login Filter to display newly added companies for the Default Path by default. New Companies need to be selected for other paths. Updated About Window to require administrator privileges to Uninstall or Reinstall Winthrop products. Updated Installer Welcome window wording to reduce the chance of confusion about version numbers of Winthrop products vs Microsoft Dynamics GP. Updated GP Power Tools Logging to automatically rename a non-dated log to a dated log if log entries are written before the setting is loaded. Updated Capture Screenshots menu navigation so it can be controlled by security. Updated Resource Information and Finder windows so they can be controlled by security. Updated copyright notice for the year 2021. Version 18.03 build 28.4 (Released 23-Nov-2020) Installer: 18.03.0028.4 ----------------------------------------------------------------------- Added Help Button to windows. Fixed Dynamic Product Selection no showing default window correctly for modified 3rd party windows. Updated Dex.ini Settings window for Reports Tab to update location of DebugRW.txt and DebugLog.txt files and provide drill down zoom. Fixed Database Validation script for v18.2 and v18.3 which was generating a null value for field Schema1 error. Fixed Database Validation script where a user might have multiple schemas accessing a single database causing a duplicate key error. Updated Product Version Check code in Screenshot and Database Validation to check for version info linked to module codes up to 200 rather than 100. Updated ScreenShot System Summary Report to automatically only show current databases if showing all databases pushes the output to larger than 32k. Updated ScreenShot System Summary Report to write to output file in sections so that it can exceed the 32k limit in the file if needed. Updated Activity Cleanup code to automatically elevate VIEW SERVER STATE permissions if needed so that active sessions can be verified. Updated Product Version Validation check to ensure that version numbers are reset in between checking versions for each dictionary. Added MBS_Debug_ProductVersionOverride Dex.ini setting to Product Version Validate to exclude a workstation from version mismatch checks. Version 18.03 build 28.3 (Released 13-Oct-2020) Installer: 18.03.0028.3 ----------------------------------------------------------------------- Updated Resource Finder Case Sensitivity options to be compatible with text fields and Binary collations. Version 18.03 build 28.3 (Released 13-Oct-2020) Installer: 18.03.0028.3 ----------------------------------------------------------------------- Updated option to Administrator Settings window to clean up activity records for disconnected users before login to avoid error message disabling syVendorAnalysisDeleteTrigger. Updated clean up activity records code to only work for current user unless logged on as a user with sysadmin rights as standard user cannot see other users SQL processes. Updated clean up activity records code to only remove DEX_SESSION records when SQL processes are no longer active or there are duplicate records. Fixed clean up activity records code not being activated when Company Login window is not displayed because there is only one company in the system. Fixed Company Login Filter not being activated when Company Login window is not displayed because there is only one company in the system. Fixed Challenge 'sa' with Administrator Password not being activated when Company Login window is not displayed because there is only one company in the system. Version 18.03 build 28.2 (Modified 06-Oct-2020) Installer: 18.03.0028.2 ----------------------------------------------------------------------- Initial 18.3 Build. Updated Password Reset Emails to escape special characters in usernames and passwords when sending html based emails. Updated Website Settings window to add option to hide Homepage Intelligent Cloud Insights website entirely. Changed New users to show their homepage by default rather than Intelligent Cloud Insights. Updated Product Version Validation window to increase its default window size. Updated Prevent Users accessing system until login processes have completed, dialog can be clicked on to close and reopen to refocus to system dialogs. Added option to Administrator Settings window to disable write access checks on Temp, Data and Logging folders for when the checks cause issues with App-V environments. Added option to Administrator Settings window to clean up activty records for disconnected users before login. This can unlock stuck batches and locked windows automatically. Fixed SQL Login Maintenance window not sending Password Reset Emails when only resetting the password without changing password policies. Fixed Dynamic Product Selection handling for PowerUsers when the Modified Alternate ID has the resource is set to the original version of a window or report. Version 18.02 build 28.1 (Released 11-Aug-2020) Installer: 18.02.0028.1 ----------------------------------------------------------------------- System Features Module ---------------------- Registration Remove previous deprecated registration system from product. Enhancements to registration system to preserve invoicing data when automatically creating subscription records for new versions. Updated Table installation system to be more robust and provide more information if there are problems creating a table. Further Updates for Web Client compatibility. Added optional warning or warning and exit feature to the Registration window, so you can prevent users accessing the system if the product is not registered. ScreenShot Updated ScreenShot's System Summary Report to display Dictionary Assembly, Metadata Assembly and Modified Form Assembly DLL files for all products. Updated ScreenShot's System Summary Report to include the SQL Server Collation information. Updated Screenshot window's System Status report to include drive free space for Temporary, Application Data and Logging path folders. Updated ScreenShot window to improve performance when refreshing the window list. Dictionary Assembly Generator Control Added Dictionary Assembly Generator (DAG) Control window to assist with creation of Dictionary Assembly DLL files used by .Net Execute and script parameter functions. Added button to access Dictionary Assembly Generator Control window to .Net Execute References window. Added button to access Dictionary Assembly Generator Control window to Resource Information Script Parameters window. Configuration Export/Import Updated Configuration Export/Import window to make it an advanced mode (Administrator) window which requires elevated permissions and passwords. Updated Configuration Export/Import window with option to export linked resources from Customization Maintenance when exporting. Updated Configuration Export/Import window with option to import linked resources from Customization Maintenance when importing. Resource Explorer Renamed Forms, Windows and Fields Explorer window of the Resource Explorer to Form Explorer. Updated Form Explorer and Menu Explorer windows of the Resource Explorer to show Modified and Alternate Forms, Windows and Fields. Updated Forms Explorer and Menu Explorer to resolve dictionary context bug which could cause no windows to be shown when expanding forms. Added Global Variables Explorer window to Resource Explorer to see global variables in any dictionary. Added Constants Explorer window to Resource Explorer to see global level or form level constants in any dictionary. Fixed issue where Resource Explorer windows would keep maximizing after they had been closed maximized once. Fixed Form Explorer and Menu Explorer windows to show Modifier Added Fields in Scrolling windows as well as normal windows. Fixed Form Explorer and Menu Explorer windows to show forms and windows in the runtime engine DEX.DIC as original rather than alternate. Updated Table Explorer window of the Resource Explorer to show key fields for the primary key of the selected table. Updated Resource Explorer windows to workaround Dexterity bug when a field has a space in its physical name so that the space is converted to underscore. Updated Form Explorer and Menu Explorer windows to only check if fields are alternate or modified when on an alternate or modified window. Updated Resource Explorer to use SQL Cache Tables rather than Memory Cache Tables so they are kept between sessions and add code to update dictionaries automatically as required. Added Options menu to Resource Explorer windows with options to manually refresh the dictionary resources cache tables, if desired. Updated Forms Explorer window to clear scrolling window parent information when it is no longer needed. Fixed extra window being added to .Net scripts when using Names Button. Install Added Additional Launch File Installer to install product into additional Launch Files for multiple Launch File configurations. Updated Additional Launch File Installer to exclude Wennsoft/Key2Act WSUTIL.SET file. Updated Additional Launch File Installer to remember Excluded Launch File Names in WDC_InstallExclude Dex.ini file setting. Updated GP Power Tools Installer to place a copy of the GP Power Tools User Guide manual pdf into the Documentation folder. Added extra warning on login if there is a dictionary version mismatch between version constants and dictionary version properties, usually caused by old custom forms dictionaries. Fixes Fixed Microsoft Dynamics GP bug to re-Load User Dex.ini file when returning from Modifier or Report Writer. Added Workarounds for issues with Dexterity functions File_Probe() and Path_MakeGeneric() when in Web Client or Service Modes. GP Enhancement Added User Name to "This transaction is being edited by another user." dialog for Requisition Entry window (v14 or later). Administrator Tools Module -------------------------- Resource Information Updated Resource Information Error Message search to include the SY_Error_Messages_MSTR_3rd (ALERT3RD) table as well as SY_Error_Messages_MSTR (SY01700) table. Updated Resource Information window to handle Modified resources being returned by the updated Form Explorer. Updated Resource Information window to add Global Variables mode using the Global Variables Explorer. Updated Resource Information window to add Constants mode using the Constants Explorer. Fixed Resource Information window where back button would not work for Messages & Warning resources. Updated Resource Information window to allow showing of selected Window and Field Infomration to work for Modifier Added Fields. Updated Resource Information window to display the datatype for Modifier Added Fields when the modified window is open. Updated Resource Information window to display the value for Modifier Added Fields when the modified window is open. Updated Tools >> Resource Descriptions >> Resource Information menu option to automatically display the details of the currently active field. Resource Finder Added Resource Finder companion window to the Resource Information window to allow for quick identification of where data is stored in the tables. Added Tools >> Resource Descriptions >> Resource Finder menu option to automatically display the details of the currently active field. Updated Resource Finder window to use SQL Execute Setup window to preview data for the selected fields on the selected table. Added Find by Table Field to Resource Finder window to search entire database for any table containing the selected column. Updated Resource Finder window to default list of fields into Sequence order to match the table order. Updated Resource Finder window to allow entry of a physical name into the Field Name, if identified it will be converted to the Technical Name. Updated Resource Finder window to allow searching by data entered into the Field Value with options for database, table prefix and search type. Updated Resource Finder window when using data search to add where clause for the field to limit the data shown. Updated Resource Finder with Redisplay Button and Auto Search Checkbox to allow manual or automatic control of searching when in Find Data mode. Updated Resource Finder to only allow Administrator Users to use the Find Data mode search as it could affect performance and confirm existence of data. Updated Resource Finder to add Find for Value option when using Window Mode to limit results to only tables which contain the field and data from the window field. Updated Resource Finder to add Filtering by Field column name when searching database for specified data. Updated Resource Finder window to use Resource Explorer table cache for improved performance and add timer check to display time taken to read and display the data. Updated Resource Finder window to add case sensitivity control when using Find Data mode. Security Profiler Updated all security windows to fix showing security information for eOne's Extender product since changes were made since it was a Microsoft OEM. Updated all security windows to fix showing security information for eOne's Smart List Builder product since changes were made since it was a Microsoft OEM. Security Information Updated Security Information Window so that POWERUSERS are included when the show Selected checkbox is selected. Added Security Information report to Security Information window to display access rights including Roles and Tasks for currently selected resource. Security Log Updated Security Activity tracking to detailed information and remove out of date data. Updated Security Log window to remember the state of the resource type checkboxes. Security Analyzer Added additional check if all dictionaries are installed on workstation when open Security Analyzer window. If all dictionaries are installed, reminder question is skipped. Added product dictionary version checks to code which keeps the syCurrentResource (SY09400) table up to date, so it will force a refresh if products are installed or updated. Enhanced Security Updated Deny Based Security Enhanced Security window to be able to display security operations limited for specific Security Roles or Security Tasks. Updated Deny Based Security Enhanced Security window to sort Smartlist Favourites by alphabetical order when they are displayed in the tree. Security Denied Fixed illegal address error if Security Denied window is closed while refreshing. Administrator Settings Fixed Additional User Setup Information window so that it will not attempt to auto open if the Administrator Tools module is not registered. Updated Administrator Settings Automatic Logout to add option to clear and close Inquiry windows before attempting to log out. Added Exception Handling to forced clearing and closing of Inquiry windows used by Automatic Logout. Updated Administrator Settings to add a timemout option to automatically close the Login and Company Login windows if they are not closed with a specified time. Updated Administrator Settings User Selection window to allow selection by User Class, Security Alternate Modified ID, Security Role ID or Security Task ID. Added Default Export Mode to Administrator Settings window and update windows with Export feature to use the default value. Updated Administrator Settings window to add option to warn if drive free space for Temporary, Application Data and Logging path folders is low. Updated Administrator Settings window to add option to remove the ACTIVITY table record when automatically logging out to force session to be closed and free up user license. Updated Administrator Settings window to add support for Binary Stream's Multi Entity Management to change colors based on the user's current default entity. Updated Administrator Settings window to add support for Per User Selection of Color Themes for Accessibility support for Vision Impaired or Color Blind users. Updated Administrator Settings window to add support for detailed User Activity tracking. Updated Administrator Settings window to add support for detailed Security Actvity tracking. Fixed Company Color Schemes to ensure that when a theme is reset for a company other than the logged in company, the settings are removed from the company level table on next login to that company. Fixed Company Color Schemes to ensure that default colors are restored when selecting a Binary Stream Multi Entity Management Segment ID that does not have a color theme defined. Added option to Administrator Settings window to control if the User Additional Information window opens below or to the right of the User Setup window. Added ability to use a SQL Lookup with the User Setup Additional Information User Defined Field so you can control what can be entered into each field. Added option to Administrator Settings window to Prevent user activity until login processes have completed. This displays a "Please Wait" modal dialog until login has finished. Dictionary Control Updated Dictionary Control User Selection window to allow selection by User Class, Security Alternate Modified ID, Security Role ID or Security Task ID. Dynamic Product Selection Updated Dynamic Production Selection User Selection window to allow selection by User Class, Security Role ID or Security Task ID. Security Alternate Modified ID is already included. Company Login Filter Updated Company Login Filter to add option to hide the "Remember this company" checkbox from the Company Login window. User Activity Log Updated User Activity Log window to add filters modes for User Status and User Type. Fixed User Activity Log window to correctly include the final five columns (Automatic Logout data) when exporting to file or email. Updated User Activity tracking to log detailed information and remove out of date data. Updated User Activity tracking to include Machine Name, Windows Login, User Type and Client Type data in statistics. Fixed User Activity Tracking handling for capturing Machine Name data, fixed hanging on login in previous beta release. Window Position Memory Updated Window Position Memory window to allow overriding of the resizable window check to force a window to be resizable. This is because the check sometimes fails to identify resizable windows. Added more window to the default windows for Window Position Memory so that it now includes all common Transaction, Cards and Inquiry windows be default for Financial, Sales, Purchasing and Inventory. Login Limits Updated Login Limits window to add option to reserve a user license for a specific user. Reserved Licenses will be removed from the main pool of licenses. Updated Login Limits window to add visual overlay indicator to the user tree to show which users have settings and what type of settings are selected. Updated Login Limits window to add By User (with Settings) and By Company (with Settings) views to make it easy to locate which users and/or companies have settings associated. Updated Login Limits check to include check for Reserved Users and ensure that available maximum users is reduced by the number of reserved users. Fixed Login Limits window By User (with Settings) and By Company (with Settings) views not working 100% correctly. Launch File Configuration Added File Selection button to the Additional Files window of Launch File Configuration so that files can be selected rather than typed in. Updated Launch File Configuration to add an additional check for write access to the application folder before attempting to make changes to launch files. Website Settings Added Website Settings window to allow control of the Websites used by the Connect Homepage section and the Intelligent Cloud Insights Homepage section. Added Dex.ini setting MBS_Debug_DisableWebsiteSettings=TRUE to disable Website Settings changes, if required. Product Version Validation Added warning dialog on login which displays details of mismatched product dictionary versions detected on the current workstation. Added new Product Version Validation window to view and edit product dictionary version information recorded for system and all workstations. Added Workstation Column and All view to Product Version Validation window so you can get the system versions and all workstation versions showing in a single view. Added Export to file or email feature to Product Version Validation window so the displayed version information can be exported. Fixes Fixed Splitter Resizing issues when maximizing windows by store splitter position as a percentage value rather than an absolute pixel number. Fixed issue with updated User Selection Windows where they would not activate options when using the Exclude users and companies checkbox. Fixed issue with updated User Selection Windows where they would activate options when using the Exclude users and companies checkbox for unselected users when new modes are being used. Fixed issue with cleanup code when deleting User Classes and User Company Access data. Developer Tools Module ---------------------- Project Setup Updated Project Setup window to add optional Open Form field to allow opening a Form in any dictionary. Use this to open primary window for a project. Updated Project Setup window to add option to Rename Entire Project. This will update all children of the project with the new Project ID. Updated Project Setup window to add option to Duplicate Entire Project. This will also duplicate all children of the project to the new Project ID. Updated Project Setup window to add option to Delete Entire Project. This will also remove all children of the project along with the Project. Added tables for Project Resources feature of Developer Tools module to allow Resources from Customization Maintenance to be linked to Projects. Updated Configuration Export/Import window to add support for tables for Project Resources feature. Updated Project Setup window to add support for tables for Project Resources feature. Updated Backup and Restore window to add support for tables for Project Resources feature. Updated Project Setup window to allow Resources from Customization Maintenance to be linked to Projects. Updated Project Setup window with option to export linked resources from Customization Maintenance when exporting Projects. Added workaround fix to issue where Visual Studio Addin Events for Functions and Procedures are disabled after importing a Customization Maintenance package. Trigger Setup Added Pull Focus from Window before script option to Trigger Setup window to force field change and posts scripts to run on a window before executing the script. Added System Dialog Mode to Trigger Setup window to allow the selection between displaying Information, Warning, Error or Debug system dialogs. Added Allow Trigger Recursion (defaults to off) to Trigger Setup window to prevent trigger processing to cause the trigger to fire again and cause looping. Added Field Changed Event to Focus triggers on Trigger Setup window. Changed event runs whenever the field changes even if underlying script is not executed. Added Global Level with Parameters and Form Level with Paramters Events to Procedure and Function triggers to allow viewing of parameters passed to scripts. Replaced all Continuum (Dynamics.Application) functionality with new DictionaryRoot methods, which is faster and more stable. Reversed fixes required for Web Client compatibility to disable triggers and scripts on modified forms as Continuum is not available on Web Client. Updated Trigger Registration so that if a trigger is marked as Minimize Log Entries, it will only create log entries if there is an error. Updated Trigger Setup window to allow a table to be selected for Focus Events on Scroll Fill Before Original. Table contents are copied to the window before script executed. Updated Trigger Setup User Selection window to allow selection by User Class, Security Alternate Modified ID, Security Role ID or Security Task ID. Added Message ID to Trigger Setup window to allow for the Warning Dialog to be overridden with a language based Message. Updated Trigger Setup window to validate trigger resources when alternate or modified and suggest triggering on original resource instead. Updated Trigger Setup window to handle Modified resources being returned by the updated Form Explorer. Updated Trigger Setup window to automatically update script when toggling Modified checkbox instead of forcing a reset of the script. Updated Trigger Setup window to add Global Variables Explorer to Names Button of the Script Editor. Updated Trigger Setup window to add Constants Explorer to Names Button of the Script Editor. Updated Trigger Setup window to add Constants Explorer (value) to Names Button of the Script Editor. Updated Trigger Setup window to add "default to" commands to default scripts so that fields on the current window don't need to be fully qualified. Updated Trigger Setup window to warn the user when attempting to use a Modifier Added Field in a script for a trigger mode that does not support the use of Modified Mode or Modified Mode is not available. Fixed Trigger Setup window to understand to treat forms and windows in the runtime engine DEX.DIC as original rather than alternate. Fixed Trigger Setup window to require table name to be selected for Scroll Fill triggers for both Before Original and After Original. Updated Trigger Setup window so that when changing the Trigger Attach only resets the script for Modal Dialog focus triggers. Updated Trigger Setup window to add zoom buttons to Form and Window fields on the Resource tab. Updated Trigger Setup window so that Scrolling Fill Reject Record option is only available when trigger attached Before Original. Updated Trigger handling so that if log entries are minimized they will stay minimized after additional triggers have fired. Updated Trigger Setup window to turn on Security Check option when Modified Script option is enabled. This will avoid Illegal Address Errors when the Modified window is not used by not running the trigger script. Updated Trigger Initialization scripts to honor minimize log entries when starting triggers using Parameter Lists. Updated Trigger Initialization scripts when starting projects to remove message when none of the triggers will start logging. Added Placeholder for Substitution option to the Insert Button on the Trigger Setup window. Trigger Status Added Trigger Status Report to Trigger Status window to allow list of currently registered triggers to be printed on a report. Runtime Execute Setup Updated Runtime Execute Setup User Selection window to allow selection by User Class, Security Alternate Modified ID, Security Role ID or Security Task ID. Updated Runtime Execute Setup window to handle Modified resources being returned by the updated Form Explorer. Updated Runtime Execute Setup window to add Global Variables Explorer to Names Button of the Script Editor. Updated Runtime Execute Setup window to add Constants Explorer to Names Button of the Script Editor. Updated Runtime Execute Setup window to add Constants Explorer (value) to Names Button of the Script Editor. Updated Runtime Execute Setup window and Runtime Executer window to add a Minimize Log Entries checkbox. Updated Custom RW Functions handler code to check script purpose matches and use Minimize Log Entries checkbox. Updated Custom Web Service handler code to use Minimize Log Entries checkbox. Updated Custom URL Drillback handler code to use Minimize Log Entries checkbox. Updated Custom SQL Goto handler code to use Minimize Log Entries checkbox. Updated Runtime Execute Setup window to warn the user when attempting to use a Modifier Added Field in a script and Modified Mode is not available. Fixed Runtime Execute Setup window to stop a seeded lookup failing when a script is selected in the lookup. Added Placeholder for Substitution option to the Insert Button on the Runtime Execute Setup window. SQL Execute Setup Updated SQL Execute Setup User Selection window to allow selection by User Class, Security Alternate Modified ID, Security Role ID or Security Task ID. Updated SQL Execute Setup window and SQL Executer window to add a Minimize Log Entries checkbox. Fixed SQL Execute Setup window to stop a seeded lookup failing when a script is selected in the lookup. Updated SQL Execute Setup window to correctly handle conversion of array fields, composite fields and array of composite fields from their Dexterity Technical names. Updated SQL Execute Setup window to improve reliability and performance of conversion of Dexterity Technical Names to SQL Physical Names. Updated SQL Execute Setup window to workaround Dexterity bug when a field has a space in its physical name so that the space is converted to underscore. Updated SQL Execute Setup to improve detection for DROP, DELETE and TRUNCATE Commands in the SQL Query Script to remove false positives caused by fields containing keywords. Updated SQL_Results window to honor minimize log entries setting on triggers and scripts. Added Timers to SQL Execute Setup window to show how long a query took to run and be displayed. Added notification on the status link when query results are limited by the number of records field to SQL Execute Setup window. Added an Insert Button to the SQL Execute Setup window to insert syntax for standard Transact SQL commands. Added Placeholder for Substitution option to the Insert Button on the SQL Execute Setup window. Added Option to automatically close SQL Results window or clear the SQL Execute window after a SQL Goto script has been executed. SQL Executer Added Timers to SQL Executer window to show how long a query took to run and be displayed. Added notification on the status link when query results are limited by the number of records field to SQL Executer window. SQL Results Added Timers to SQL Results window to show how long a query took to run and be displayed. Added notification on the status link when query results are limited by the number of records field to SQL Results window. .Net Execute Setup Updated .Net Execute Setup User Selection window to allow selection by User Class, Security Alternate Modified ID, Security Role ID or Security Task ID. Updated .Net Execute Setup window to handle Modified resources being returned by the updated Form Explorer. Updated .Net Execute Setup window to open Dictionary Assembly Generator (DAG) Control window when selected resources in a DLL that cannot be found. Updated .Net Execute Setup window to add Global Variables Explorer to Names Button of the Script Editor. Updated .Net Execute Setup window to add Constants Explorer (value) to Names Button of the Script Editor. Updated .Net Execute Setup window and .Net Executer window to add a Minimize Log Entries checkbox. Fixed .Net Execute Setup window to stop a seeded lookup failing when a script is selected in the lookup. Added Placeholder for Substitution option to the Insert Button on the .Net Execute Setup window. Parameter List Maintenance Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Company Address Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Employee Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Employee Class Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Salesperson Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Territory Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Shipping Method Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Payment Terms Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Price Level Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Country Code Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Checkbook Lookup. Updated Parameter List Maintenance window and Parameter List Entry window to add support for the Currency Lookup. Added a Placeholder Lookup dialog to allow Placeholders to be inserted into scripts when not linked with a Parameter ID. Updated SQL Lookup window to substitute Placeholders for data before running query on the Parameter List Maintenance window. Updated SQL List functionality to substitute Placeholders for data before running query on the Parameter List Maintenance window. Updated Parameter List Maintenance window to refresh SQL based Lists when they gain focus so that can update dynamically based on data in other parameters. Updated Parameter List Maintenance window to validate SQL Lookup single fields when they gain focus so that can update dynamically based on data in other parameters. Updated Parameter List Maintenance window so that the use of Placeholders for filtered SQL Lists and filtered SQL Lookups is explained. Parameter List Entry Updated SQL Lookup window to substitute Placeholders for data before running query on the Parameter List Entry window. Updated SQL List functionality to substitute Placeholders for data before running query on the Parameter List Entry window. Updated Parameter List Entry window to refresh SQL based Lists when they gain focus so that can update dynamically based on data in other parameters. Updated Parameter List Entry window to validate SQL Lookup single fields when they gain focus so that can update dynamically based on data in other parameters. Messages Setup Added Messages Setup window to Developer Tools module to created reusable messages with multi-lingual support. Added Messages Lookup window to Developer Tools module. Added tables for Messages feature of Developer Tools module to allow storage of language based Messages to use in triggers and scripts. Updated Configuration Export/Import window to add support for tables for Messages feature. Updated Project Setup window to add support for tables for Messages feature. Updated Backup and Restore window to add support for tables for Messages feature. Dynamic Trigger Logging Updated Dynamic Trigger Logging Script Setup window to add the Global Variables Explorer to the Names Button. Helper Functions Updated Helper Functions window to use Button Drop Down List with hierarchy for the growing list of Helper Functions. Updated Helper Functions window to add both load and execute Helper Functions when Executing Scripts from Runtime Execute, SQL Execute or .Net Execute. Updated Helper Functions window user interface to support 25 new Helper Functions being added. Updated Helper Functions window to support adding of 25 new Helper Functions code into scripts. Updated Helper Functions so that if they are called from a trigger that is marked as Minimize Log Entries, they will only create log entries if there is an error. Updated Helper Functions window to support new Table Buffer helper functions. Updated Helper Functions window to support MBS_Runtime_Execute_Modified_Delayed and MBS_Runtime_Execute_Modified_Background helper functions for Dexterity, Visual C# and Visual Basic.Net. Added MBS_Set_Window_Value series of Helper Functions to set the value of a Field on any window of any form of any dictionary. Added MBS_Get_Window_Value series of Helper Functions to get the value of a Field on any window of any form of any dictionary. Added MBS_Run_Window_Value Helper Function to execute the change script of a Field on any window of any form of any dictionary. Added MBS_Set_Window_Value_Focus Helper Function to change the focus to a Field on any window of any form of any dictionary. Added MBS_Set_Window_Value_Visible Helper Function to show or hide a Field on any window of any form of any dictionary. Added MBS_Set_Window_Value_Enabled Helper Function to enable or disable a Field on any window of any form of any dictionary. Added MBS_Set_Window_Value_ReadOnly Helper Function to lock or unlock a Field on any window of any form of any dictionary. Added MBS_Get_Window_Value_Exists Helper function to check if a field exists on any window of any form of any dictionary. Added MBS_Set_Window_Value_Modified series of Helper Functions to set the value of a Field on any window of any form of any modified dictionary. Added MBS_Get_Window_Value_Modified series of Helper Functions to get the value of a Field on any window of any form of any modified dictionary. Added MBS_Run_Window_Value_Modified Helper Function to execute the change script of a Field on any window of any form of any modified dictionary. Added MBS_Set_Window_Value_Modified_Focus Helper Function to change the focus to a Field on any window of any form of any modified dictionary. Added MBS_Set_Window_Value_Modified_Visible Helper Function to show or hide a Field on any window of any form of any modified dictionary. Added MBS_Set_Window_Value_Modified_Enabled Helper Function to enable or disable a Field on any window of any form of any modified dictionary. Added MBS_Set_Window_Value_Modified_ReadOnly Helper Function to lock or unlock a Field on any window of any form of any modified dictionary. Added MBS_Get_Window_Value_Modified_Exists Helper function to check if a field exists on any window of any form of any modified dictionary. Added MBS_Arguments_Get_Count Helper Function to return the number of arguments passed into a function or procedure trigger handler. Added MBS_Arguments_Get_Type Helper Function to return the data type of an argument passed into a function or procedure trigger handler. Added MBS_Arguments_Get_Value Helper Function to return the value of an argument passed into a function or procedure trigger handler. Added MBS_getmsg Helper Function to return a message resource from any installed Dexterity product dictionary. Third party messages will be >= 22000. Added MBS_Get_Error_Message Helper Function to return Error Messages from the SY_Error_Messages_MSTR table or SY_Error_Messages_MSTR_3rd table (if >= 100000). Added MBS_Trigger_Update_Dialog Helper Function to update the message and mode displayed by a trigger from the trigger handling script before it is displayed. Added MBS_Trigger_Update_Email Helper Function to update the email address used by a trigger from the trigger handling script before the email is sent. Added MBS_Get_DateTime Helper Function to get the current local or UTC date and time with milliseconds. Added MBS_Get_Table_Buffer_Value series of Helper Functions to get the value of a Field from any table buffer on any form of any dictionary. Added MBS_Set_Table_Buffer_Value series of Helper Functions to set the value of a Field from any table buffer on any form of any dictionary. Added MBS_Copy_To_Window Helper Function to copy table fields to the matching fields on a window on a form. Does not check AutoCopy property. Added MBS_Copy_From_Window Helper Function to copy table fields from the matching fields on a window on a form. Does not check AutoCopy property. Added MBS_Copy_To_Window_Modified Helper Function to copy table fields to the matching fields on a window on a modified form. Does not check AutoCopy property. Added MBS_Copy_From_Window_Modified Helper Function to copy table fields from the matching fields on a window on a modified form. Does not check AutoCopy property. Added MBS_Memory_Set series of Helper Functions to set data to datatyped memory variables, faster than the table based MBS_Param_Set Helper Function. Added MBS_Memory_Get series of Helper Functions to get data from datatyped memory variables, faster than the table based MBS_Param_Get Helper Function. Added MBS_Memory_Del series of Helper Functions to delete data from datatyped memory variables, faster than the table based MBS_Param_Del Helper Function. Added MBS_Get_Message Helper Function to retrieve message for the current Language ID (defaults to English-US if not found). Added MBS_Get_Global series of Helper Functions to get the value of global variables in any dictionary. Added MBS_Set_Global series of Helper Functions to set the value of global variables in any dictionary. Added MBS_Get_Constant series of Helper Functions to get the value of global level or form level constants in any dictionary. Added MBS_Table_Buffer_Get Helper Function to issue get or change table commands on a form's table buffer. Added MBS_Table_Buffer_Save Helper Function to issue the save table command on a form's table buffer. Added MBS_Table_Buffer_Remove Helper Function to issue the remove table command on a form's table buffer. Added MBS_Table_Buffer_Release Helper Function to issue the release table command on a form's table buffer. Added MBS_Table_Buffer_Range Helper Function to issue range table commands on a form's table buffer. Added MBS_Table_Buffer_Clear Helper Function to issue clear table command on a form's table buffer. Added MBS_Table_Buffer_Fill Helper Function to issue fill table command on a form's table buffer. Updated MBS_Runtime_Execute_Delayed Helper Function to honor minimize log entries setting state as at when the script is placed into the queue. Updated MBS_Runtime_Execute_Background Helper Function to honor minimize log entries setting state as at when the script is placed into the queue. Added MBS_Runtime_Execute_Modified_Delayed to allow a script to execute against a modified window delayed. Added MBS_Runtime_Execute_Modified_Background to allow a script to execute against a modified window in the background. Added MBS_SQL_Lookup_Validate to validate a field against the data returned by a custom SQL Lookup based on a SQL Execute script. Added MBS_SQL_Lookup_Parameter_Validate to validate a field against data returned by a custom SQL Lookup called from a Parameter List. Added MBS_Pull_Window_Focus Helper Function to force any change or post scripts to be executed by pulling focus from the window. Added MBS_SQL_Goto_GetData Helper Function to the Helper Functions window so it can be selected for additional fields from a SQL Goto script. Added MBS_SQL_Goto_Close Helper Function to manually close SQL Results window or clear the SQL Execute window from a SQL Goto script. Fixed bug in the Script Parameter helper functions where last parameter value was not returned. Fixes Fixed bug where blank lines were being added to text fields such as scripts when configuration settings (.dbg.xml) files were imported. Database Tools Module --------------------- XML Table Export Updated XML Export window to add Options menu with link to built in Table Export tool. XML Table Import Updated XML Import window to add Options menu with link to built in Table Import tool. Database Validation Updated Database Validation to find and fix situations where the Database User's default schema is not set to dbo. Added additional check if all dictionaries are installed on workstation when open Database Validation window. If all dictionaries are installed, reminder question is skipped. Password Reset Email Settings Renamed Database Validation Email Settings window to Password Reset Email Settings as it is also used from the SQL Login Maintenance and User Setup windows. Added Password Reset Email Settings window to the Microsoft Dynamics GP menu navigation and to the User Setup window Additional menu. Copy User Settings Added Copy User Settings window to Database Tools to allow copying of all users settings in the system database from one user to another user. Updated Copy User Settings window to use Resource Explorer table cache for improved performance and add timer check to display time taken to read and display the data. Updated Copy User Settings to preserve Note Indexes when overwriting existing records. Fixed Copy User Settings issues with counting records and copying table data in runtime mode. SQL Trigger Control Added new SQL Trigger Control window to Database Tools module to identify and disable, enable or delete SQL triggers. GP Enhancement Added an option to the SQL Maintenance window when Database Tools module is registered to backup and restore table data when dropping and creating tables. Version 18.02 build 27.7 (Released 15-Feb-2020) Installer: 18.02.0027.7 ----------------------------------------------------------------------- Fixes required for Web Client compatibility during login and switch companies. Fixes required for Web Client compatibility to disable triggers and scripts on modified forms as Continuum is not available on Web Client. Fixes required for Web Client compatibility to the registration system when using a proxy server. Fixes required for Web Client compatibility to prevent Dynamics Product Selection dialog opening twice for grouped windows. Updated Project Setup window to open Resource Explorer to allow Resource Explorer to remember data read from dictionaries while Project Setup stays open. Updated Project Setup window to display Trigger Setup Form and Dictionary details and allow opening of the form using the Open Form button. Fixed Bug in Resource Information when typing in an exact table technical name, it did not update dictionary back to core Dynamics for a core table. Fixed Bug where Remember Company feature on the Company Selection window was no longer being disabled if it clashed with Company Login Filter. Version 18.02 build 27.6 (Released 03-Jan-2020) Installer: 18.02.0027.6 ----------------------------------------------------------------------- Fixed User ID not always being shown when transaction is being edited by another user. Fixed Scheduled Trigger scheduling for Mode : Each Time Scheduled to avoid retry loop and only schedule at correct times. Version 18.02 build 27.6 (Released 17-Dec-2019) Installer: 18.02.0027.6 ----------------------------------------------------------------------- Updated Trigger Setup window so that changing Trigger Attach for Scheduled Event timings does not refresh the trigger handling script. Updated Trigger Setup window so that changing Trigger Event for Timed Event timings does not refresh the trigger handling script. Fixed SQL Execute Setup window to resize the "script to be executed" pane seen when the script is executed. Updated the Visual Basic Addin DLL to improve exception handling. Updated registration of GP Power Tools triggers to provide an error number if trigger registration fails. Fixed Modal Dialog Trigger registration to not expect a Modified window. Updated Modal Dialog Trigger registration to show Dialog on Window of Form
in Dictionary in the log. Updated Modified Field Trigger registration to show Field of Window of Form in Dictionary (Modified). Version 18.02 build 27.5 (Released 24-Oct-2019) Installer: 18.02.0027.5 ----------------------------------------------------------------------- Enhanced Registration support for trial keys. Version 18.02 build 27.5 (Released 07-Oct-2019) Installer: 18.02.0027.5 ----------------------------------------------------------------------- Initial Build for Modern Lifecycle 18.02 release. Updated for Microsoft Dynamics GP October 2019 RTM code. Version 18.00 build 27.5 (Released 30-Sep-2019) Installer: 18.00.0027.5 ----------------------------------------------------------------------- Added option to capture reads to missing Dex.ini settings to the Dex.ini Configuration window. Added Resource Information window to the Resource Descriptions menu at application and form levels. Added IP Address and IP Name information to the ScreenShot system status report. Added fix to store and restore Home Page Settings when changing Home Page roles, especially for GP 2018 R2 or later. Fixed "All Call Stacks In Use" error caused when Dex.ini settings capture was enabled for version 14.00 or later. Added Support for Modern Lifecycle version numbering. Version 18.00 build 27.4 (Released 28-Aug-2019) Installer: 18.00.0027.4 ----------------------------------------------------------------------- Fixed Dex.ini Configuration window so that Edit Dex.ini button moves correctly when window resized. Updated Database Validation to handle situation where system database name case does not match name defined in the table data. Added Report Writer function RW_GetUserMasterAdditionalData() to get to the Additional User Master data, parameters , . Updated Report Writer function rw_TableHeaderString() to call RW_GetUserMasterAdditionalData when parameters are -5261, "User" , 0, . Added Copy to Clipboard Button to Resource Information Window to copy Resource so it can be pasted into scripts (similar to Names Buttons on script editor windows). Version 18.00 build 27.3 (Released 14-Aug-2019) Installer: 18.00.0027.3 ----------------------------------------------------------------------- Added Update Check window to application menus as Check for GP Power Tools Updates. Added Exclusion of Parity's PS_Authorize window to Window Position Memory and Window Position Check due to compatibility issue. Fixed issue where Report Destination could be set to an invalid path under specific conditions and could cause a dialog to be displayed. Further update to fix issue where Report Destination could be set to an invalid path under specific conditions. Version 18.00 build 27.3 (Released 30-Jul-2019) Installer: 18.00.0027.3 ----------------------------------------------------------------------- Added expansion window to Dynamic Trigger Logging to allow the data from a field or global variable to be logged. Fixed Password Reset email illegal address error on GP 2018 R2 when changing password on the Enter User Names window. Version 18.00 build 27.3 (Released 12-Jul-2019) Installer: 18.00.0027.3 ----------------------------------------------------------------------- Updated Registration system to ensure grace period stays active if Update Keys is clicked after subscription has already expired. Added Message and Warning mode to Resource Information to be able to identify where a dialog message is stored and which product it is from. Updated Configuration Export/Import so that importing of projects maintains the current default project. Updated Password Reset email to send to Administrator only when user's email address has not been entered on the Additional User Information window. Added Password Reset email when changing password on the Enter User Names window when Database Tools module is registered. Version 18.00 build 27.2 (Released 24-Jun-2019) Installer: 18.00.0027.2 ----------------------------------------------------------------------- Fixed Administrator Settings options for Automatic Logout Not being disabled when feature is disabled. Version 18.00 build 27.2 (Released 19-Jun-2019) Installer: 18.00.0027.2 ----------------------------------------------------------------------- Updated GetDotNetWindowHandleByName() to log error rather than display a dialog. Error only caused when opening window 'User_Find ' of form User_Lookup due to the space after the window name. Version 18.00 build 27.2 (Released 15-Jun-2019) Installer: 18.00.0027.2 ----------------------------------------------------------------------- Added warning message when unable to update Launch File from Launch File Configuration or Dictionary Control. Fixed incorrect chapter headings in the GP Power Tools User Guide. Updated Security to include lookup forms for new windows, Company Login Filter, Login Limits and Dynamic Product Selection. Version 18.00 build 27.1 (Released 28-May-2019) Installer: 18.00.0027.1 ----------------------------------------------------------------------- Fixed issue where Dynamics Product Selection returned incorrect security data for Powerusers when original Dynamics form was default. Version 18.00 build 27.1 (Released 24-May-2019) Installer: 18.00.0027.1 ----------------------------------------------------------------------- System Features Module Added option to control individual logging modes on startup. Added User Name to "This transaction is being edited by another user." dialog for Sales Transaction Entry window. Added User Name to "This transaction is being edited by another user." dialog for Purchase Order Entry window. Added User Name to "This transaction is being edited by another user." dialog for Purchasing Invoice Entry window. Added User Name to "This transaction is being edited by another user." dialog for Receivings Transaction Entry window. Fixed error "GP Power Tools: GetPO() of form POP_PO_Entry before function trigger registration failed." on GP 2013 R2 release. Added Calculator window with links on Application and window Tools menus, Quicklinks and the standard Toolbar. Added Clipboard Support to Calculator so that numbers can be copied to and from the calculator. Added Memory features to Calculator along with Backspace button. Increase Registration Server Ping Timeout from 5 seconds to 10 seconds to avoid false activating of offline mode. Updated Menu Navigation to move About GP Power Tools and GP Power Tools Feedback Survey from Setup to Routines. Added Menu Navigation for GP Power Tools Registration window to Routines menu. Administrator Tools Module Added Launch File Configuration Tables to allow storage of Launch File Configuration Settings. Added Launch File Configuration Tables to Configuration Maintenance, Configuration Export/Import and Setup Backup & Restore windows. Added Launch File Configuration window to define rules for rolling out Dynamics.set launch file changes automatically. Added Launch File Configuration Preview window to show the changes that the rules will make on next login. Added processing of Launch File Configuration rules on login to apply changes if needed and make a backup of the previous Launch file. Fixed Launch File Configuration window to update paths when changing product ID or location ID. Added renaming of additional DLL files to Launch File Configuration when adding or removing products from the Launch File. Added warning when saving Launch File Configuration when Advanced Security will end up above Smartlist in the launch file as this causes an additional login dialog on launch. Added Menu Navigation and Security for Launch File Configuration window. Added Dynamic Product Selection Tables to allow storage of Dynamic Product Selection dialogs settings for modified/alternate forms and reports. Added Dynamic Product Selection Tables to Configuration Maintenance, Configuration Export/Import and Setup Backup & Restore windows. Added Dynamic Product Selection window to allow for dynamic selection of Original, Modified, Alternate or Modified Alternate Windows and Reports. Added Preview to Dynamic Product Selection window to display example dialogs based on settings. Added changing of dictionary selection based on selection from Dynamic Product Selection dialog. Updated Security Profiler window so that it shows when Dynamic Product Selection has changed the resource opened. Added handling to Dynamic Product Selection to ensure triggers are given the correct information when they check which window is opened. Updated Dynamic Product Selection to open default resource (as per security) when cancel is pressed on the keyboard entry dialog. Added handling to Dictionary Control to ensure triggers are given the correct information when they check which window is opened. Added Menu Navigation and Security for Dynamic Product Selection window. Added Details window to the Security Log window to show all users and company log records for the selected security object. Updated Resource Information window to display Search Results in a pane on the right hand side in alphabetical order. Fixed Resource Explorer not displaying the selected dictionary when first opened, but working for subsequent uses. Added Checkbox option to hide Inactive Users from Security Information window. Updated Automatic Logout warning dialog to bring window to front and take focus so it cannot be missed. Updated Automatic Logout warning dialog window to ensure that it cannot be accidentally dismissed when it opens. Updated Administrator Settings window to add disable focus option for Automatic Logout warning dialog. Updated Automatic Logout warning dialog window to include the company and user details for when multiple sessions are open. Fixed Automatic Logout warning dialog window not moving to top most window correctly. Fixed Company Login Filter not allowing company checkboxes to be selected. Fixes bug introduced in Build 26. Fixed Company Login Filter where it was failing to identify path names with folders included when single file names worked. Added Lookup Window Positioning to Company Login Filter Lookup window to ensure lookup opens relative to calling window. Added warnings when saving or enabling a Company Login Filter profile where there are no companies selected for the Default Path as this could prevent logging in. Fixed GP Power Tools not showing in the area page section of the Menu Explorer window of the Resource Explorer. Updated Dictionary Control to suppress Rockton Toolbox Exit warning when exiting after launch files changes made. Fixed Security Profiler, Security Warning Dialog and Security Activity tracking starting when not registered. Updated handling of table cleanup when deleting users to trigger off the stored procedure called. Added Lookup Window Positioning to Login Limits Lookup window to ensure lookup opens relative to calling window. Added MBS_Debug_LookupPosition Dex.ini setting to disable Lookup Window Positioning. Set to FALSE to disable. Added MBS_WindowPositionCheck procedure for external ISVs to call if they need to temporarily disable the Window Position Check feature. Added MBS_WindowPositionMemory procedure for external ISVs to call if they need to temporarily disable the Window Position Memory feature. Added MBS_WindowPositionMemoryResize procedure for external ISVs to call if they need to temporarily disable Resizing from the Window Position Memory feature. Developer Tools Module Added SQL Execute Gotos Table to allow storage of Goto data for SQL Execute related windows. Added SQL Execute Gotos Table to Configuration Maintenance, Configuration Export/Import and Setup Backup & Restore windows. Added SQL Execute Custom Goto scripts to Runtime Execute window using Script Purpose SQLExecuteGotoHandler. Added MBS_SQL_Goto_Get_Data Helper function to read SQL data from SQL Execute Setup, SQL Executer and SQL Results windows. Added MBS_SQL_Results_Goto Help function to execute a SQL Script and display results and also link to a script's SQL Gotos. Added Goto Button to SQL Results, SQL Executer and SQL Execute Setup windows with code to call SQLExecuteGotoHandler. Added SQL Execute Setup Gotos window to SQL Execute Setup Window to define SQL Execute Goto using Runtime Execute scripts. Updated SQL Execute Setup, SQL Executer and SQL Results window to export to email using the current user's email address. Updated SQL Results window to show Script Name in the title bar and email subject when linked to SQL Execute script for Gotos. Added User and Company Selection in Runtime Execute Setup for Script Purpose SQLExecuteGotoHandler to control who has access to SQL Gotos. Added support for field focus triggers to be registered in the context of a modified dictionary. Added support for trigger handler scripts to be executed in the context of a modified dictionary. Fixed default trigger script generation for when being executed against a modified dictionary. Added support for modal dialog triggers to be registered for handling of ask(), warning, error and getstring() dialogs. Added support for field context menu triggers to be registered. Added support for modal dialog and context menu triggers with access to table buffer. Updated default scripts for modal dialog triggers to include comments about parameters and standard code for handling dialogs. Added Hide Window Action to Trigger Setup window for Focus Events on Window Pre event running Before Original code. Added additional fields needed to support Visual Studio Integration Toolkit integration into Trigger Setup window. Added Visual Studio Integration Toolkit integration to allow Application Level Menu triggers from Trigger Setup window. Added URL based Drill Backs to run custom scripts to Runtime Execute window using Script Purpose DrillBackHandlerCustom (v12.0 or later). Format: dgpp://dgpb/?Db=&Srv=&Cmp=&Prod=5261&Act=SCRIPT&Func=RuntimeExecute&ID=&Param= Updated Runtime Execute window Script Purpose DrillBackHandlerCustom example script to open Customer Maintenance. Added MBS_Token Helper function to parse comma separated parameter list from URL based Drill Back. Added User and Company Selection in Runtime Execute Setup for Script Purpose DrillBackHandlerCustom to control who has access to Drill Back. Updated Trigger Setup window to add Release Notes window with Timestamping. Updated Runtime Execute Setup window to add Release Notes window with Timestamping. Updated SQL Execute Setup window to add Release Notes window with Timestamping. Updated .Net Execute Setup window to add Release Notes window with Timestamping. Updated Parameter List Setup window to add Release Notes window with Timestamping. Updated Project Setup window to add Release Notes window with Timestamping. Updated Trigger Setup window to add Project ID as a sort order. Updated Runtime Execute Setup window and Runtime Executer window to add Project ID as a sort order. Updated SQL Execute Setup window and SQL Executer window to add Project ID as a sort order. Updated .Net Execute Setup window and .Net Executer window to add Project ID as a sort order. Updated Parameter List Setup window to add Project ID as a sort order. Updated Project Setup window to default to Project ID sort order when opening other windows. Updated Trigger Lookup window to add Project ID as a sort order and expand to dual line lookup. Updated Runtime Execute Lookup window to add Project ID as a sort order and expand to dual line lookup. Updated SQL Execute Lookup window to add Project ID as a sort order and expand to dual line lookup. Updated .Net Execute Lookup window to add Project ID as a sort order and expand to dual line lookup. Updated Parameter List Lookup window to add Project ID as a sort order and expand to dual line lookup. Added Trigger Type, Trigger Event, Trigger Attach columns to the list of components in the Project Setup window. Updated Start Button in Project Setup window to allow starting of all Automatic Start Triggers as well as Project Triggers. Added Import Button to Project Setup window to import project objects with option to remove objects no longer in the project. Fixed refreshing of logging and trigger status from Start and Stop buttons on Project Setup window. Updated Logging Control, Trigger Status and Project Setup windows so that they will close Trigger Setup window when starting triggers when possible. Added MBS_Field_ParseText Helper function to replace built in Field_ParseText() function so that text datatype can be returned. Updated ServiceCreateCustom Service Procedure to use text datatype when converting from the collection of .Net Strings to avoid 255 character limit. Updated ServiceDeleteCustom Service Procedure to use text datatype when converting from the collection of .Net Strings to avoid 255 character limit. Updated ServiceGetCustom Service Procedure to use text datatype when converting from the collection of .Net Strings to avoid 255 character limit. Updated ServicePostCustom Service Procedure to use text datatype when converting from the collection of .Net Strings to avoid 255 character limit. Updated ServiceUpdateCustom Service Procedure to use text datatype when converting from the collection of .Net Strings to avoid 255 character limit. Updated ServiceGetCustom Service Procedure to use MBS_Field_ParseText() when converting to the collection of .Net Strings to avoid 255 character limit. Updated ServicePostCustom Service Procedure to use MBS_Field_ParseText() when converting to the collection of .Net Strings to avoid 255 character limit. Updated Template scripts for Service Procedures to use MBS_Field_ParseText Helper function instead of the built in Field_ParseText() function. Updated SQL Execute Setup window to better handle column data larger than 256 characters returned by SQL Server, Listview display is still limited to 256 characters per column. Updated SQL Executer window to better handle column data larger than 256 characters returned by SQL Server, Listview display is still limited to 256 characters per column. Updated SQL Results window to better handle column data larger than 256 characters returned by SQL Server, Listview display is still limited to 256 characters per column. Updated Helper Function MBS_SQL_Check_Exists to handle column data larger than 256 characters returned by SQL Server and better NULL handling. Updated Helper Function MBS_Export_SQL_Query_To_File to handle column data larger than 256 characters returned by SQL Server and better NULL handling. Added Lookup Window Positioning to Project Setup Lookup window to ensure lookup opens relative to calling window. Added Lookup Window Positioning to Trigger Setup Lookup window to ensure lookup opens relative to calling window. Added Lookup Window Positioning to Runtime Execute Lookup window to ensure lookup opens relative to calling window. Added Lookup Window Positioning to SQL Execute Lookup window to ensure lookup opens relative to calling window. Added Lookup Window Positioning to .Net Execute Lookup window to ensure lookup opens relative to calling window. Added Lookup Window Positioning to Parameter List Lookup window to ensure lookup opens relative to calling window. Added Lookup Window Positioning to Custom SQL Lookup window to ensure lookup opens relative to calling window. Added option to unregister triggers when opening the Trigger Setup window. Updated Dexterity Help on Trigger Setup and Runtime Execute Setup windows use Dex.chm file to fix examples not displaying. Updated Trigger Status window to remember and restore whether the scrolling window is expanded. Fixed Field Name being cleared when using Get Table and Set Table options in the Helper Functions window. Updated Names Lookups on Trigger Setup window script tab to open initially to the context of the script dictionary. Updated Names Lookups on Runtime Execute Setup window to open initially to the context of the script dictionary. Added Script Purpose description onto the Runtime Execute report from the Runtime Execute window. Added MBS_Security_Form_Check Helper Function to allow for easy checking of which version of a form is in use. Added option to display simple string system dialog instead of text system dialog in actions tab of Trigger Setup window. Added option to check form security before executing script to ensure correct version is in use to Trigger Setup window. Added MBS_Security_Form_Check Helper Function to the Helper Functions window to allow for ease of inserting into code. Added option for Names Button to use Clipboard to the Script menu of Trigger Setup, Runtime Execute Setup, SQL Execute Setup and .Net Execute Setup windows. Database Tools Module Updated Database Validation Email Settings window so it can be opened from another window. Added SQL Login Maintenance window to Database Tools module to allow updating of Password Policy and Passwords for SQL Logins. Added Lookup Window Positioning to XML Export Lookup window to ensure lookup opens relative to calling window. Version 18.00 build 26.2 (Released 18-Feb-2019) Installer: 18.00.0026.2 ----------------------------------------------------------------------- Added improved logging of Registration system calls. Added improved handling for systems that are offline and cannot access the registration server. Added option to mark a system as not internet connected so that it stays offline. This can help with communication timeouts. Updated Administrator Settings User and/or Company Selection window to offer a User Class view. Updated Dictionary Control User and/or Company Selection window to offer a User Class view. Updated Trigger Setup User and/or Company Selection window to offer a User Class view. Updated Runtime Execute Setup User and/or Company Selection window to offer a User Class view. Updated SQL Execute Setup User and/or Company Selection window to offer a User Class view. Updated .Net Execute Setup User and/or Company Selection window to offer a User Class view. Updated User Activity Log Maximum Users window to allow sorting of data by columns and display selection count. Added improved handling for systems that are offline and cannot access the update check server. Added further changes to improve handling of systems that are offline and cannot access the registration server. Version 18.00 build 26.1 (Released 14-Feb-2019) Installer: 18.00.0026.1 ----------------------------------------------------------------------- Fixed Administrator Settings fields refreshing incorrectly (esepecially buttons) when Applying Settings. Updated Security Log table error handling when changing selected checkbox state. Fixed Dexterity SQL Login dialog opening when running logging on startup. Version 18.00 build 26.1 (Released 12-Feb-2019) Installer: 18.00.0026.1 ----------------------------------------------------------------------- Registration and Update Check system Fixed minor user interface faults with checkboxes on some windows. Updated Registration window to format contact details and standardize the country selection. Further updates to Registration Update Check systems to improve performance and functionality. Updated About window and registration window for better Web Client compatibility. Updated About window to simplify un-install with option for workstation only or full system un-install. Fixed Registration System to ensure new module is registered with same expiry date as existing base module. Updated Offline Registration Request Report for compatibility with Registration system. Updated Country auto formatting to remove not found error when selecting countries with additional words in their name. Updated Copyright Notices for 2019. Enhancements to Automatic Update Check and Registration systems to include additional warnings and version check. Fixed minor issues with error messages in Registration system. Fixed issue with Registration Contact Details window where the list of countries disappears. System Features Module Added Find A Window menu shortcut to Tools menu on every window for both menus and ribbons. Added Raise All Windows menu shortcut to Tools menu on every window for both menus and ribbons. Added instructions to go to Logging Settings window to warning on login when Logging Folder does not have write access. Added instructions to "Use an UNC Pathname to a folder on a network share with write permissions" to Logging Settings window. Added Terminal Server status to System Status Report from ScreenShot window. Added Limited User Count to System Status Report from ScreenShot window (v16.00 or later). Added Modules Registered details to System Status Report from ScreenShot window. Added Customizations Installed details to System Status Report from ScreenShot window. Added Addin DLLs Installed details to System Status Report from ScreenShot window. Fixed missing zip file attachment when emailing logs when Send Email preview window is used. Updated Email Settings window and Send Email windows to enable word wrap on the text editor fields. Fixed issue where User Level Dex.ini Settings for MBS_Debug_SetupMode was not being remembered. Administrator Tools Module Added New Administrator Settings User Tables to Configuration Maintenance window. Added New Administrator Settings User Tables to Setup Backup & Restore window. Added Option to select specific users and/or companies for features on Administrator Settings window. Added control of feature by users and/or companies to Window Position Check and Window Position Control settings. Added access to core Dex.ini Editor window from Dex.ini Configuration window (v12.00 or later). Added warning when setting Security Profiler Automatic Open mode to Errors & Warnings to avoid additional triggering. Added Created Time, Curr. Time, Last Date, Last Time, Prev. Date and Prev. Time columns to Security Log Tracking Table. Updated Security Log Window and Security Log report to display the additional date and time columns. Added User Activity Tracking Tables to Configuration Maintenance, and Setup Backup & Restore windows. Added User Activity Tracking options to Administrator Settings window. Added User Activity Log window and report to see data captured. Added User Activity Auto Logout feature to Administrator Settings window which checks for activity at Dexterity and SQL. Added User Activity Auto Logout auto save feature which will attempt to save windows which could prevent logging out. Added User Activity Tracking data capture of daily maximum sessions for system, companies and users. Added User Activity Log Maximum User window and report to see data captured with a bar graph and list of users logged in. Updated Company Login Filter to add option to define a custom order for the companies to be listed in the Company Login window. Fixed window growing issue with Window Position Memory for Screen Output window on monitors greater than 100% DPI. Added option to disable Automatic Window Position Check for specific windows to the Window Position Memory window. Updated Automatic Logout to make the SQL activity (last_batch from sysprocesses) optional as it is affect by timed processes. Added Tables to support Login Limits to control the number of sessions on a per user or per company basis. Added Login Limits Tables to Configuration Maintenance, Configuration Export/Import, and Setup Backup & Restore windows. Added Login Limits Window and report to set up the Login Limits options. Fixed issue with Dexterity Activity_GetBackgroundStatus() function which removes all background timed processes. Updated Automatic Logout to capture statistics when it is activated, shown on the User Activity Log window. Updated Automatic Logout to automatically restart timed process if it has been stopped. Added Login Limits functionality which checks if a user is allowed to log into a company on the Company Login window. Added optional Automatic Logout warning dialog to count down final minute before logging out. Added logging of cancelling of Automatic Logout warning dialog, shown on the User Activity Log window. Added optional secondary Automatic Logout time when user sessions are approaching maximum sessions available. Added option to include all users instead of just Full users when checking current activity for Login Limits. Added writing to GP Power Tools log file when Login Limits blocks access. Fixed User Activity Tracking data counts for per user and per company data. Fixed automatic scaling for graph on User Activity Log Maximum User window for user and company view. Added User Setup Additional Information Table to allow storage of additional information against the User Master. Added User Setup Additional Information Table to Configuration Maintenance and Setup Backup & Restore windows. Added User Setup Additional Information Settings to Administrator Settings window. Added User Setup Additional Information parallel window and synchronized with the User Setup window. Improved stability of cancelling Automatic Logout Dialog window. Updated Automatic Logout to suppress Rockton Toolbox Exit warning. Added Send Email Button to User Setup Additional Information window. Added User/Company selection to the Disable Automatic Logout Dialog option in Administrator Settings window. Added population of Default Site from User Setup Additional Information window to Item Transaction Entry. Added population of Default Site from User Setup Additional Information window to Item Transfer Entry Added population of Default Site from User Setup Additional Information window to Invoice Entry. Added population of Default Site from User Setup Additional Information window to Sales Transaction Entry. Fixed Issue where Window Position Memory, Window Position Check and Window Title features were not working. Updated Company Login Filter window to create Default profile if no profiles are present. Updated Login Limts window to create Default profile if no profiles are present. Added population of Default Site from User Setup Additional Information window to Item Inquiry. Added populating Employee ID on User Setup Additional Information window if already set up in US Payroll (v14.0 or later). Fixed issues with Window Position Memory, Window Position Check and Window Title settings for alternate windows. Fixed features breaking when changing settings for Window Position Memory, Window Position Check and Window Title. Added check for Login Limits for remembered company and prevent skipping of the Company Login window if limits reached. Fixed focus being pulled from User Setup window User Setup Additional Information window is automatically opened. Updated preview mode on User Setup Additional Information, Login Limts and Company Login Filter windows. Updated Security Activity Tracking to not log checking of Security Objects when opening Smartlist window. Added Option to re-Enable Security Activity Tracking when opening Smartlist to Administrator Settings window. Developer Tools Module Added Tables to support publishing of Runtime Execute, SQL Execute and .Net Execute scripts for specific users and/or companies. Added New Runtime Execute, SQL Execute and .Net Execute User Tables to Configuration Maintenance window. Added New Runtime Execute, SQL Execute and .Net Execute User Tables to Configuration Export/Import window. Added New Runtime Execute, SQL Execute and .Net Execute User Tables to Setup Backup & Restore window. Added New Runtime Execute, SQL Execute and .Net Execute User Tables to Project Setup window. Added Option to select specific users and/or companies when publishing scripts to the Runtime Execute Setup window. Added Option to select specific users and/or companies when publishing scripts to the SQL Execute Setup window. Added Option to select specific users and/or companies when publishing scripts to the .Net Execute Setup window. Added filtering of Scripts as per selected users and/or companies for published scripts to Runtime Executer window. Added filtering of Scripts as per selected users and/or companies for published scripts to SQL Executer windows. Added filtering of Scripts as per selected users and/or companies for published scripts to .NetExecuter windows. Added filtering of Scripts as per selected users and/or companies for published scripts to Runtime Execute Lookup window. Added filtering of Scripts as per selected users and/or companies for published scripts to SQL Execute Lookup windows. Added filtering of Scripts as per selected users and/or companies for published scripts to .NetExecute Lookup windows. Added Table to support Remembering of System and Company database selection for SQL Execute Setup window. Added Table to Configuration Maintenance, Configuration Export/Import, Setup Backup & Restore, and Project Setup window. Added Remembering of System and Company database selection for SQL Execute Setup window. Added option to set a parameter in a Parameter List as Hidden so it can be used as a parameter with helper functions only. Added Option to Stop All Triggers and Logging to Project Setup window, this is required before opening Trigger Setup window. Added Add Button to Project Setup window to simplify adding of Triggers, Scripts and Parameter Lists to Projects. Added Full Dexterity Help File to the GP Power Tools Installer. Added Help Button to bottom right of Script editor in Trigger Setup window to open Dexterity Help File. Added Help Button to bottom right of Script editor in Runtime Execute Setup window to open Dexterity Help File. Added Generate Pass through sanScript for Visual C# and Visual Basic from the Runtime Execute window. Database Tools Module Fixed Issue with Database Validation when it attempts to launch Dynamics Utilities when needed to Synchronize account framework. Updated Database Validation Fix Users window to allow for 21 character passwords on GP 2018 R2 or later. Updated Database Validation to check for the maximum length in char and text fields when checking for file conversion data loss. Added Database Validation Setup Table to allow for storage of Password change notification email. Added Database Validation Setup Table to Configuration Maintenance and Setup Backup & Restore windows. Added Email Settings window to Database Validation to allow editing of the default Password change notification email. Updated Database Validation Fix Users window to be able to send password change notification emails. Updated Database Validation to allow Email Settings window for password change notification emails to be opened any time. Updated Database Validation to store the setting for whether to send passwords via email where possible. Updated Database Validation to include User ID when sending password change notification emails. Updated Database Validation to include manually set passwords in Emailing and report functionality. Miscellaneous Changes Fixed Your attempt to log out failed because tables are open error when switching users. Added MBS_Get_DateTime procedure and MBS_Get_DateTime() function for retrieval of time or UTC time with milliseconds. Improved form exclusion check for system window in ScreenShot and Window Position Memory & Window Position check code. Version 18.00 build 25.3 (Released 24-Jul-2018) Installer: 18.00.0025.3 ----------------------------------------------------------------------- Fixed SQL Error message from Database Validation Fix Users when there is more than on trigger on ACTIVITY table. Fixed issue with Addin DLL not loading in Web Client or Service Modes. Version 18.00 build 25.2 (Released 17-Jul-2018) Installer: 18.00.0025.2 ----------------------------------------------------------------------- Fixed Script Not Found Error caused by changes to Window Position Memory resizable check. Version 18.00 build 25.1 (Released 10-Jul-2018) Installer: 18.00.0025.1 ----------------------------------------------------------------------- Further updates to Registration Update Check systems to improve performance and functionality. Updated Security Profiler to stop hidden GP Power Tools forms from showing in the Security Profiler. Updated Window Position Memory so that it will only resize a window that is marked as resizable. Added Option to Administrator Settings to disable Window Position Memory functionality. Version 18.00 build 24 (Released 01-Jul-2018) Installer: 18.00.0024.4 --------------------------------------------------------------------- Updates to Registration systems for better performance and Sub Site Support. Version 18.00 build 24 (Released 27-Jun-2018) Installer: 18.00.0024.3 --------------------------------------------------------------------- Fixed Unassigned Security Operations report so that it ignores records assigned to the SUPERUSER Security Task ID. Fixed initial home page not displaying on web client when GP Power Tools installed. Updates to Registration systems for better error reporting and Sub Site Support. Version 18.00 build 24 (Released 28-May-2018) Installer: 18.00.0024.2 --------------------------------------------------------------------- Fixed incorrect Security ID field position on Resource Information window. Version 18.00 build 24 (Released 09-May-2018) Installer: 18.00.0024.1 --------------------------------------------------------------------- Updates to Registration and Update Check systems. Added Auto Login when there is only one company to Company Login Filter. Added Display Database Name as prefix or suffix to Company Login Filter. Added Company Sort Order selection for Company Name, Database Name or Company ID order to Company Login Filter. Updated Security Analyzer query for Security Operations not assigned to any Task to exclude SUPERUSER. Updated Database Validation to show Password Policy is available without having to actually enter a Password for manual mode. Added MBS_Return Procedure to allow setting of window fields without issues caused by old() function on existing field change script. Version 18.00 build 23 (Released 05-Apr-2018) Installer: 18.00.0023.9 --------------------------------------------------------------------- Added visual indicator of when registration window is running in offline mode. Fixed auto renewal code for free products to renew annual subscriptions from 45 days before expiry. Updated Database Validation to include failure messages in the Database Validation Log when processing fails. Updated Database Validation to continue after a SQL Login/ User processing error rather than abort further processing. Updated Folder Write Access Checks to not look for local application data folder when running in Web Client mode. Updated Setup Backup and Restore to not use the local application data folder when running in Web Client mode. Updated Window Position Memory to include the Payables Transaction Entry window in the default transaction and maintenance windows. Updated tooltip on Dex.ini Settings window for option to disable Window Position and Size Memory to the Report Writer Screen Output window. Version 18.00 build 23 (Released 13-Mar-2018) Installer: 18.00.0023.8 --------------------------------------------------------------------- Added additional exception handling to ensure the Communicating with Registration Server window gets closed. Updated Script Menu on Trigger Setup window to add keyboard shortcuts and remove clash with Ctrl-L for Lookups. Updated Script Menu on Runtime Execute Setup window to add keyboard shortcuts and remove clash with Ctrl-L for Lookups. Updated Script Menu on SQL Execute Setup window to add keyboard shortcuts and remove clash with Ctrl-L for Lookups. Updated Script Menu on .Net Execute Setup window to add keyboard shortcuts and remove clash with Ctrl-L for Lookups. Updated Script Menu on Runtime Executer window to add keyboard shortcuts. Updated Script Menu on SQL Executer window to add keyboard shortcuts. Updated Script Menu on .Net Executer window to add keyboard shortcuts. Added automatic naming of export file pathname based on Project ID to Project Setup window. Added List of Triggers, Scripts and Parameter Lists to Project Setup window with double click to drill down. Added Start and Stop buttons to Project Setup window to start and stop all triggers for the current project. Added Synchronization of List of Triggers on Project Setup window to Trigger Setup window. Added Synchronization of List of Dexterity Scripts on Project Setup window to Runtime Execute Setup window. Added Synchronization of List of SQL Scripts on Project Setup window to SQL Execute Setup window. Added Synchronization of List of .Net Scripts on Project Setup window to .Net Execute Setup window. Added Synchronization of List of Parameter Lists on Project Setup window to Parameter Maintenance window. Added MBS_Project_Start and MBS_Project_Stop Helper Functions to Helper Functions window. Added Start and Stop All Triggers for Selected Project to the Trigger Status window. Added Start All Triggers for Selected Project to GP Power Tools Logging Control main window. Added MBS_Script_Substitute Helper Function which can be used to manually substitute parameters for values, use with MBS_Parameter_Placeholder and MBS_Parameter_ Helper Functions. Added MBS_Parameter_Placeholder Helper Function to retrieve the standard Parameter List placeholder string depending on language. Added MBS_Parameter_String Helper Function to convert a string value into the correct format for substitution depending on language. Added MBS_Parameter_Number Helper Function to convert a number value into the correct format for substitution depending on language. Added MBS_Parameter_Currency Helper Function to convert a currency value into the correct format for substitution depending on language. Added MBS_Parameter_Boolean Helper Function to convert a boolean value into the correct format for substitution depending on language. Added MBS_Parameter_Date Helper Function to convert a date value into the correct format for substitution depending on language. Added MBS_Parameter_Time Helper Function to convert a time value into the correct format for substitution depending on language. Added MBS_Parameter_Load Helper Function to force a Parameter List ID to load to facilitate automatic parameter substitution when running scripts with Helper Functions. Added MBS_Parameter_Set_String Helper Function to set the value of a string parameter for the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Set_Number Helper Function to set the value of a number parameter for the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Set_Currency Helper Function to set the value of a currency parameter for the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Set_Boolean Helper Function to set the value of a boolean parameter for the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Set_Date Helper Function to set the value of a date parameter for the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Set_Time Helper Function to set the value of a time parameter for the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Get_String Helper Function to get the value of a string parameter from the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Get_Number Helper Function to get the value of a number parameter from the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Get_Currency Helper Function to get the value of a currency parameter from the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Get_Boolean Helper Function to get the value of a boolean parameter from the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Get_Date Helper Function to get the value of a date parameter from the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Parameter_Get_Time Helper Function to get the value of a time parameter from the loaded Parameter List, use with MBS_Parameter_Load Helper Function. Added MBS_Script_Substitute, MBS_Parameter_Placeholder and MBS_Parameter_* Helper Functions to Helper Functions window. Added MBS_Parameter_Load, MBS_Parameter_Set_* and MBS_Parameter_Get_* Helper Functions to Helper Functions window. Added Window Position and Size Memory to the Report Writer Screen Output window. Added MBS_Debug_DisableScreenOutputMemory Dex.ini setting to disable Screen Output Memory to the Dex.ini Settings window. Added Generate Pass through option to Script menu on Trigger Setup window to create Dexterity trigger registration and handler scripts for developers. Updated Save and Continue functionality on Trigger Setup, Runtime Execute Setup, SQL Execute Setup and .Net Execute Setup windows. Added Save and Contine functionality to Project Setup and Parameter List Maintenance windows. Version 18.00 build 23 (Released 16-Feb-2018) Installer: 18.00.0023.7 --------------------------------------------------------------------- Updated Defaults for new systems to enable System Password caching. Fixed Security Analyzer to drill back to User Setup window from Password Policy Query instead of User Security window. Disable Bitmap Scaling Settings for Version 11.0 on Dex.ini Settings window as it is not supported. Added Creation of DynUtils.exe.manifest file for Bitmap Scaling Settings on Dex.ini Settings window. Added check for write access to Logging Folder, Application Data Folder and Windows Temporary Folder on login. Added check for Required Fields settings on login and make sure that Required Fields are visible if enabled. Fixed Dynamics GP Bug where RememberUser Dex.ini setting is not written to System Dex.ini when Per User Dex.ini files are enabled. Added Dex.ini Setting MBS_Debug_Break to force open of Dexterity Script Debugger (when enabled) prior to logging into Dynamics GP. Added additional handling to registration system to prevent users entering incorrect data. Version 18.00 build 23 (Released 09-Feb-2018) Installer: 18.00.0023.6 --------------------------------------------------------------------- Added expansion button to display the Static Values for datatypes to Resource Information window. Added additional handling to registration system when unable to access registration servers. Fixed Token Date Drop Down List width covering up Date Field in Parameter List Entry window. Fixed MBS_Command_Form error in Service Mode when using Helper functions that check for Parameter Substitutions. Version 18.00 build 23 (Released 24-Jan-2018) Installer: 18.00.0023.5 --------------------------------------------------------------------- Added Dictionary Product ID values to product selection drop down list on Dynamic Trigger Logging Trigger List window. Added Dictionary Product ID values and Background or caused by Product details to Dynamic Trigger Logging. Added Zoom to windows explorer for folder containing settings file for Dynamic Trigger Logging Trigger List window. Added Zoom to windows explorer for folder containing settings file for Setup Backup and Restore window. Updated Registration System to include optional logging facility. Updated Workflow windows (Version 14.0 or later) to allow a Super User to temporarily have Power User access. Version 18.00 build 23 (Released 15-Dec-2017) Installer: 18.00.0023.4 --------------------------------------------------------------------- Automatically remove Application.GpPowerTools.dll from Addins folder if present. Fixed Automatic Update Check displaying error messages if unable to contact web service. Added Retry option to Update Check window to allow error messages to be displayed if needed. Added warning when Addin DLL is not installed when opening Registration window. Added additional warnings when Addin DLL is not installed when trying to register. Added additional instructions to Registration Contact Details window. Added Access to Registration window from Additional Menu of Dynamics GP Registration window. Added version information to Registration and Registration Contact Details windows. Improved Script Debugger Context control for Resource Explorer and Menu Explorer windows. Improved Script Debugger Context control for Window Position Memory window. Added Script Debugger Context window when using Script Debugger to allow context changing. Changed Default Dictionary Context on Runtime Execute to Script Debugger context (if enabled). Fixed Script Debugger Context window to not use alternate line colours for the Listview as even lines were not showing on some systems. Added option to link Resource Information window with Dexterity Script Debugger open script dialog. Version 18.00 build 23 (Released 02-Dec-2017) Installer: 18.00.0023.3 --------------------------------------------------------------------- Update Installer Help Links. Version 18.00 build 23 (Released 27-Nov-2017) Installer: 18.00.0023.2 --------------------------------------------------------------------- Initial Microsoft Dynamics GP 2018 release. Version 16.00 build 23 (Released 27-Nov-2017) Installer: 16.00.0023.2 --------------------------------------------------------------------- Added Play Fast... option to the Macro menu to allow easy playback of macros three times faster than normal. Added Save and Continue option to the Script menu on Trigger Setup window to allow quick saving while working. Added Save and Continue option to the Script menu on Runtime Execute Setup window to allow quick saving while working. Added Save and Continue option to the Script menu on SQL Execute Setup window to allow quick saving while working. Added Save and Continue option to the Script menu on .Net Execute Setup window to allow quick saving while working. Fixed Script menu on Runtime Execute Setup disabling incorrect options when Parameter List entry is occurring. Fixed Script menu on SQL Execute Setup disabling incorrect options when Parameter List entry is occurring. Fixed Script menu on .Net Execute Setup disabling incorrect options when Parameter List entry is occurring. Fixed incorrect Series being reported for Forms, Tables, Reports on the Resource Explorer windows. Added Dictionary Product ID values to product selection drop down lists on Trigger Setup window. Added Dictionary Product ID values to product selection drop down list on Runtime Execute Setup window. Added option to hide Table Groups for the Table Explorer window of the Resource Explorer. Added option to hide Table Groups for the Table view of the Enhanced Security window. Added progress bar when reading dictionary resources for forms, tables, reports and scripts (procedures and functions). Version 16.00 build 23 (Released 15-Nov-2017) Installer: 16.00.0023.1 --------------------------------------------------------------------- Fixed Display Parameters to include final carriage return to make cutting and pasting work better. Fixed Resource Explorer window to allow display of form level procedures and functions from dictionaries other than Dynamics. Fixed Technical Name Zoom button on Resource Information window to force field change scripts to run when button is clicked. Fixed zooming to Runtime Executer window from Runtime Execute Setup window when Script ID is blank. Fixed zooming to SQL Executer window from SQL Execute Setup window when Script ID is blank. Fixed zooming to .Net Executer window from .Net Execute Setup window when Script ID is blank. Fixed SQL Execute Setup window to allow percentage values in the result set to be sorted numerically. Fixed SQL Executer window to allow percentage values in the result set to be sorted numerically. Fixed SQL Results window to allow percentage values in the result set to be sorted numerically. Fixed Security Analyzer window to allow percentage values in the result set to be sorted numerically. Fixed Trigger Setup - User and Company selection window always forcing record to be saved. Fixed Dictionary Control - User and Company selection window always forcing record to be saved. Fixed Form Level Menu & Field Context Menu types Trigger Script not defaulting when Menu Entry text is populated. Fixed Single Field Error generating and From, To error message when changed to a larger value in Parameter Lists. Added Uppercase Custom Lookups (both SQL and Form) to Parameter Lists to force uppercase for data entered. Added data validation for Single Field Custom Lookup (SQL) and Custom Lookup (SQL) Uppercase for Parameter Lists. Fixed Parameter Lists where List and List (SQl) modes only showed the data once when parameters substituted multiple times. Fixed incorrect detection of DELETE, DROP and TRUNCATE command in SQL Execute Setup window. Fixed Security exemption for SQL Lookup and Form Lookup windows. Fixed Conversion of Resource Names into .Net format for working with Visual C# and Visual Basic.Net. Added Optional display of Resource Names in .Net format on status line of Form, Table and Script Explorers. Added Script Explorer with Parameters option to build complete call for function or procedures in Script Editor windows. Fixed Database Validation to recreate Database Users with incorrect Security IDs (SIDs) on other non Dynamics GP databases. Fixed Database Validation to allow fixing of access issues, but not file conversions while users are logged into the system. Updated ScreenShot System Status to provide information for System and current Company databases by default. Added Option to provide information on all databases on ScreenShot System Status to Administrator Settings window. Added Option to provide information on all databases on ScreenShot System Status to Trigger Setup window. Added Option to provide information on all databases to ScreenShot window, defaults from Administrator Settings window. Added feature to update Last User and Last Company information when exiting store details from last session closed. Added Dex.ini setting to disable update Last User and Last Company information on exit into Dex.ini Settings window. Updated Resource Explorer Tables to use Memory Tables so that they remain populated for duration of current instance of GP. Fixed Script Explorer not showing hidden forms or forms with no windows on them. Added note to use Enhanced Security window to add data to Security Denied and Security Hidden windows. Added Register Button to Trigger Status window to allow Automatic Trigger Mode to be started. Added Dialog asking if Logging should be stopped when unregistering all logging triggers from Trigger Status window. Added check if logging already started when starting or already stopped when stopping and add code to handle. Fixed Logging on Startup presenting a login dialog due to attempting to read SQL data before being logged in. Fixed Do Not Remind Again not working for Registration dialogs. Added Automatic Check for Updates feature. Added internal Registration System and Mekorma Product Manager removal and cleanup. Version 16.00 build 22 (Released 19-Jun-2017) Installer: 16.00.0022.7 --------------------------------------------------------------------- Updated SQL Execute to include System database in All Companies mode if System Database selected in drop down list. Updated SQL Execute and SQL Executer windows to clear results panes when executing before any dialogs are shown. Updated Runtime Execute and Runtime Executer windows to clear status line when executing before any dialogs are shown. Updated .Net Execute and .Net Executer windows to clear output pane when executing before any dialogs are shown. Fixed Administrator Settings window when on Web Client to show additional status messages correctly. Updated Automatic Window Positioning to not be active when Integration Manager is running. Updated Window Position Memory to not be active when Integration Manager is running. Updated Code Signing Certificate. Fixed Enhanced Security window not showing correct options for Document Access in the Purchasing Series. Updated Exit after Processes feature to be Web Client compatible and added menu option to QuickLinks. Improved handling of GO SQL Statement in SQL Execute Setup and SQL Execute windows and related functions. Added ability to only execute selected section of T-SQL script to SQL Execute Setup window. Added ability to only execute selected section of Dexterity script to Runtime Execute Setup window. Added Check for Updates to Options menu of About GP Power Tools window. Updated Descriptions for Service Based Procedures. Fixed Automatic Window Positioning code to use Dexterity to move window and only use Windows calls if Dexterity fails. Updated Trigger registration error messages to include product name. Added Goto Line feature to Script menu on Trigger Setup, Runtime Execute Setup, SQL Execute Setup and .Net Execute Setup windows. Updated to check for and clean up CR/LF to replace with just CR in .Net Execute Setup window. Added Display Parameters feature to Resource Information window when in Procedures and Functions mode. Version 16.00 build 22 (Released 16-May-2017) Installer: 16.00.0022.6 --------------------------------------------------------------------- Fixed Window Position Memory for SmartList window to avoid Unhandled Script Exception for GP 2013 builds before SP2. Added additional Bright Themes and new Light Themes to Company Color Schemes in Administrator Settings window. Total built in themes for Company Color Schemes is now 110 themes. Version 16.00 build 22 (Released 09-May-2017) Installer: 16.00.0022.5 --------------------------------------------------------------------- Updated Parameter List Entry window to default To values to the From value when it is empty. Fixed Project Setup window to show correct File Path tooltip when reading existing records. Added Reset Path button to Project Setup window, to reset back to default path value. Fixed partial seeding of Parameter Lists Custom SQL Lookups not working. Fixed SQL Executer window to allow Parameter Lists to work more than once while a script is loaded. Added Vertical Splitter Adjustment buttons with approximately 10 positions to .Net Execute Setup window. Added Vertical Splitter Adjustment buttons with approximately 10 positions to SQL Execute Setup window. Added support for GO statement to SQL Execute window to allow multiple sets of statements to be executed. Added support for GO statement to SQL Executer window to allow multiple sets of statements to be executed. Added support for GO statement to SQL Results window to allow multiple sets of statements to be executed. Added support for GO statement MBS_Export_SQL_Query_To_File Helper Function. Added support for GO statement MBS_SQL_Check_Exists Helper Function. Added support for GO statement MBS_SQL_Results Helper Function. Version 16.00 build 22 (Released 02-May-2017) Installer: 16.00.0022.4 --------------------------------------------------------------------- Updated Trigger Setup window to stop asking to reset script when changing Menu Trigger text. Updated Company Color Themes to use User Display Preference settings for Link Fields and Required Fields. Updated Company Color Themes to override User Display Preference color settings when needed for inverted themes. Added fix for Dynamics GP Bug where Apply button on User Display Preferences only works one time. Added additional checks to ensure correct window handle is used when repositioning and retitling windows. Updated default values for Email, Logging and Administrator settings to enable recommended features for new installs. Adjusted window repositioning code when capturing window handle for 3rd party products to use foreground window method. Version 16.00 build 22 (Released 15-Mar-2017) Installer: 16.00.0022.3 --------------------------------------------------------------------- Fixed Logging Settings and Email Settings windows from giving incorrect warnings when saving. Version 16.00 build 22 (Released 14-Mar-2017) Installer: 16.00.0022.2 --------------------------------------------------------------------- Updated SQL Execute Setup Generate Passthrough to use variables for Database Names. Added code to create/update SUPERUSER Security Role and Security Task as suggested by Mark Polino. Version 16.00 build 22 (Released 08-Mar-2017) Installer: 16.00.0022.1 --------------------------------------------------------------------- Fixed handling of all custom triggers on SY_Current_Activity table for Database Validation window. Fixed Window Position Memory to remove "Syntax Error: Local." issue when opening windows from Smartlist. Fixed Window Position Memory restoring last position whenever window is restarted. Now only works when window is first opened. Version 16.00 build 22 (Released 23-Feb-2017) Installer: 16.00.0022.1 --------------------------------------------------------------------- System Module: High DPI Monitor help Added Windows Bitmap Scaling feature to Dex.ini Settings window. Daily GP Power Tools Log Added feature where GP Power Tools User Company Log file can be renamed each day and logs older than a specified number of days will be removed. Emailing of Logs Added Create Compressed Folder and Create Zip File from Folder functionality support. Added option to email captured logs as a zip file when stopping Manual Logging Mode to Logging Settings window. Challenge sa User on Login Added option to challenge 'sa' user on login with the GP Power Tools Administrator Password before access given. ScreenShot Enhancements Added Display Name and Domain Name information to System Status report. Administrator Module: Deny Based Security Added Deny Based Security Tables to system, including Setup Backup and Restore window. Added Security Denied window to display security resources denied for users and companies. Added Security Hidden window to display navigation items hidden for users and companies. Update Security Information window to handle Deny Based Security. Update Security Analyzer window to handle Deny Based Security. Added Enhanced Security window to control Deny Based Security and Hidden Security settings. Added Field Level Security to Enhanced Security window copy functionality. Added Scan for missing Menu Entries to add to the syMenuMstr (Menu Master) table to Enhanced Security window. Company Login Filter Added tables to support new feature of Company Login Filter. Updated Setup Backup and Restore to support new tables for Company Login Filter. Updated Configuration Export/Import to support new tables for Company Login Filter. Added Company Login Filter window and filtering functionality to Company Login window. Added menu navigation for Company Login Filter feature. Window Position Memory Added tables to support new feature of Window Position Memory. Updated Setup Backup and Restore to support new tables for Window Position Memory. Updated Configuration Export/Import to support new tables for Window Position Memory. Added Window Position Memory window with default windows for common cards and transactions windows. Added menu navigation for Window Position Memory feature. Added Additional Menu option to User Preferences window to allow user to reset their Window Memory Settings. Added Reset Window Memory Settings window to Window Memory Setup window for Administrator to reset users' settings. Dictionary Control Enhancements Added User and/or Company selection to Dictionary Control when using "After Login" settings. Resource Information Enhancements Added the field value when the form containing the window for the field is open to Resource Information window. Usability Enhancements Added 8 more Window Title options to Administrator Settings using Company Name and User Name. Added Logging facility to Automatic Window Re-positioning code, uses MBS_Debug_LogWinData=TRUE Dex.ini Setting. Added option to only request System or Administrator Password be entered once per session. Security Enhancements Fixed issue where Security Profiler has an error if the windows is closed while new rows are being added. Added hint text to bottom of Security Information window to remind users to Expand the System Level node. Developer Module: Dynamic Trigger Logging Added MBS_Debug_LogListPath setting to point to Dynamic Trigger List to capture script and database events. Added Dynamics Trigger List Setup window to configure Dynamics Trigger Lists. Generate Pass through Scripts Added Generate Pass Through sanscript code feature to Runtime Execute Setup and SQL Execute Setup windows. Parameter Lists Enhancements Added SQL select statement based Drop Down Lists to Parameter Lists using a SQL Execute Script ID. Added SQL select statement based Custom Lookup to Parameter Lists using a SQL Execute Script ID. Added Dexterity Form based Custom Lookup to Parameter Lists using definition of form, windows and fields. Project Grouping Added Project Setup window to allow grouping of triggers, scripts and parameters into projects. Added Project ID field into Trigger Setup and Parameter Maintenance windows. Added Project ID field into Runtime Execute Setup, SQL Execute Setup and .Net Execute Setup windows. Updated Configuration Export/Import window to work with Projects including automatic selection of linked resources. Updated Project Setup window to allow export of project and all linked resources. Updated Setup Backup and Restore window to include Project Setup table. Trigger Setup Enhancements Added New Trigger Type of Login and Logout Event to the Trigger Setup window. Added New Trigger Type of Scheduled Event with Daily, Weekly and Monthly Types and additional options to Trigger Setup window. Improved Trigger Script exception handling to avoid errors stopping trigger actions from running. Added option to perform trigger actions when script has failed to execute or when condition is not met. Improved Script Find and Replace functionality to include initially selected text if it matches the find text. Fixed Timed Process and Scheduled Process triggers to remove entry from Timed Process Queue when stopping. Added option to email captured logs as a zip file when a logging Trigger fires and condition met. Added Exported record xml file and Exported table xml file to zip file when captured by a Trigger. Added lines written using MBS_Auto_Log helper function into the body of the email generated by a Trigger. Hides the Process Monitor window when unregistering timed or scheduled processes so it does not flicker on screen. New Helper Functions Added MBS_Runtime_Execute_Background to execute Dexterity scripts in the background queue. Added MBS_Runtime_Execute_Delayed to execute Dexterity scripts delayed (after foreground queue). Updated Helper Functions window to support MBS_Runtime_Execute_Background and MBS_Runtime_Execute_Delayed. Added MBS_SQL_Lookup and MBS_Form_Lookup helper functions to provide custom lookup functionality to scripts. Added MBS_SQL_Lookup_Parameter and MBS_Form_Lookup_Parameter helper functions to provide custom lookup functionality to scripts is settings for predefined Parameter Lists. Added MBS_SQL_Results helper function to display results of SQL queries in a window with export facilities. Added MBS_DUOS_Set, MBS_DUOS_Get, MBS_DUOS_Del, and MBS_DUOS_DelAll Helper Functions to simplify storage of data in the Dynamic User Object Store (SY90000) DUOS table. Database Module: Database Validation Enhancements Added Batch Activity and System Activity tables in clean up code for users and companies in Database Validation. Added option to generate passwords when recreating logins for Fix Users function of Database Validation. Added Database Validation Passwords report to display users and their generated passwords. Added window to allow selection of users to remove SQL Logins to force login and password to be recreated. XML Export and Import Enhancements Added extra error handling for XML_Write_Passed and XML_Read_Passed used by Security Profiler. Product Wide: Navigation Enhancements Added Find a Window menu option to open built-in Find a Window dialog (for GP 2013 or later). Rename Automatic Debugger Mode and associated windows to Automatic Trigger Mode and Trigger Setup and Status. Added direct menu selections for individual tabs of the Administrator Settings window. Updated menu navigation to simplify GP Power Tools module breakdown. Miscellaneous Added Redisplay Button to Configuration Maintenance window. Updated Splitter controls on multiple windows so that it did not overwrite the status field underneath. Fixed Upgrade registration message by re-enabling Dynamics.set launch file re-ordering to ensure product manager is above GP Power Tools. Version 16.00 build 21 (Released 05-Nov-2016) Installer: 16.00.0021.8 -------------------------------------------------------------------------- Updated Installer to force re-install of Mekorma Product Manager when dictionary has been deleted. Updated Subscription Expiry dialogs to allow them to be dismissed for longer periods. Updated SQL Permission Checks to use 'SQLLoginID' of globals instead of 'User ID' of globals to support Web client only users. Removed ribbon from sub windows on Runtime Execute Setup, SQL Execute Setup and .Net Execute windows. Changed Auto Open of GP Power Tools Logging Control window to open after foreground processing is completed. Changed Legend windows on Security Information, Enhanced Security and Database Validation to no longer be modal. Fixed Automatic window re-positioning when using DPI scaling on individual monitors. Updated Automatic window re-positioning to give priority to top left corner of window when resolution smaller than window. Version 16.00 build 21 (Released 12-Sep-2016) Installer: 16.00.0021.7 --------------------------------------------------------------------- Fixed handling for Scrolling window with spaces in its name in Automatic Debugger Mode Setup. Updated Mekorma Product Manager support files. Version 16.00 build 21 (Released 01-Sep-2016) Installer: 16.00.0021.6 --------------------------------------------------------------------- Added Users with Password Policy Status query to Security Analyzer window. Added Field Level Security to Go To Button on Security Information window. Fixed Multiple module registration on initial login only working if MEP before GPPT in DYNAMICS.SET. Fixed System Text color not being visible on a white background when working with Inverted text company color themes. Version 16.00 build 21 (Released 18-Aug-2016) Installer: 16.00.0021.5 --------------------------------------------------------------------- Added Service Based Architecture Logging functionality for version 14.00 onwards. Fixed Security Information window to remove Limited User warning when resource Excluded from Security. Fixed Administrator Controlled Logging Path not saving from Logging Settings window. Fixed Security Log window Export feature to use correct column list. Fixed Security Object Explorer window of Resource Explorer to show Unknown Security Types. Fixed Resource Information window handling of Unknown Security Types. Version 16.00 build 21 (Released 22-Jul-2016) Installer: 16.00.0021.4 --------------------------------------------------------------------- Fixes to Window position control to support multiple monitors and alternate primary monitor positions. Fixes to Window position and size settings in Dex.ini Settings window to support multiple monitors. Fixed error message when using seeded lookup on Runtime Executer, SQL Executer and .Net Executer windows. Added User Lookup as option to Parameter Lists. Fix System Status report to show correct version information as Windows no longer reports versions beyond 8. Added Send Email option to Application Tools Menu and to Windows Tools Menu. Added Send Email option to Standard Toolbar and Quicklinks. Fixed Raise All Windows to only use open windows. Bug introduced with previous build trigger changes. Updated Security Log window so that Resources Excluded from Security have a disabled checkbox and cannot be selected. Updated Security Log window to add Export to File or Email functionality. Added selection checkbox to Security Profiler to allow selection of rows to include when creating Security Tasks. Enhanced Security Information Legend window to include legend for right hand pane of window. Version 16.00 build 21 (Released 13-Jul-2016) Installer: 16.00.0021.3 --------------------------------------------------------------------- Fix conversion error when Parameter List substitution occurs for the second last character in a script. Disable Execute Button on Runtime Execute Setup and Runtime Executer windows when Parameter List dialog is open. Disable Execute Button on SQL Execute Setup and SQL Executer windows when Parameter List dialog is open. Disable Execute Button on .Net Execute Setup and .Net Executer windows when Parameter List dialog is open. Disable Preview Button on Parameter List Maintenance window when Parameter List dialog is open. Disable Automatic Opening of Security Profiler window when Microsoft Dynamics GP is running Integration Manager. Remove Last Password Expiry Check date records for users from tables when Password Expiry Check is disabled. Changes to avoid duplicate key error on table MBS_CompanySettings_Triggers caused by registering too many triggers. Changed Screenshot and Usability enhancements to reuse triggers rather than register and unregister on demand. Changed Resources Information show selection to reuse triggers rather than register and unregister on demand. Changed Scrolling Window check to cache results to avoid registering and unregistering additional triggers. Version 16.00 build 21 (Released 02-Jul-2016) Installer: 16.00.0021.2 --------------------------------------------------------------------- Fixed Company Color Schemes not saving Theme Group and Theme Name when changing for companies other than current company. Fixed error caused when closing Security Analyzer window while it was still populating records in the background. Added Filters to Security Log window along with background processing to populate data. Update syCurrentResources (SY09400) table to add Product Name to OData objects when missing. For version 16.00 or later. Version 16.00 build 21 (Released 01-Jul-2016) Installer: 16.00.0021.1 --------------------------------------------------------------------- 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. 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. 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. 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. 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. 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. 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. 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. 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. Version 16.00 build 20 hotfix 10 (Released 18-Mar-2016) Installer: 16.00.0020.15 -------------------------------------------------------------------------------- Allow Preview Mode for windows when GP Power Tools core module is registered and additional modules are not. Version 16.00 build 20 hotfix 9 (Released 18-Mar-2016) Installer: 16.00.0020.14 ------------------------------------------------------------------------------- Initial build for Microsoft Dynamics GP 2016 Version 14.00 build 20 hotfix 9 (Released 17-Mar-2016) Installer: 14.00.0020.14 ------------------------------------------------------------------------------- Added feature to remove invalid Database Users for companies where user does not have access granted. Added feature to User Access Setup window to prevent "This user could not be added to one or more databases." errors. Added feature to User Access Setup window to prevent "This user could not be removed from one or more databases." errors. Fixed Database Validation for better support for binary sort order on SQL Server. Version 14.00 build 20 hotfix 8 (Released 02-Mar-2016) Installer: 14.00.0020.13 ------------------------------------------------------------------------------- Fixed table error when adding or removing users, companies or company access. Version 14.00 build 20 hotfix 7 (Released 26-Feb-2016) Installer: 14.00.0020.12 ------------------------------------------------------------------------------- Do not cache scripts when called by Service Based Architecture to allow changes to take effect immediately. Fixed registration failure on login or when calling Service Procedures via Service Based Architecture. Installer updated to comply with Microsoft's changes to Windows Enforcement of Authenticode Code Signing and Timestamping. Version 14.00 build 20 hotfix 6 (Released 08-Feb-2016) Installer: 14.00.0020.11 ------------------------------------------------------------------------------- Allow demonstration systems to be registered in Trial Mode. Must only have sample company installed and no live companies. Version 14.00 build 20 hotfix 5 (Released 18-Nov-2015) Installer: 14.00.0020.10 ------------------------------------------------------------------------------- Improved Multiple Instance handling. Version 14.00 build 20 hotfix 5 (Released 18-Nov-2015) Installer: 14.00.0020.9 ------------------------------------------------------------------------------ Fixed Signing of Dictionary Assembly DLL files. Version 14.00 build 20 hotfix 5 (Released 18-Nov-2015) Installer: 14.00.0020.8 ------------------------------------------------------------------------------ Fixed User Name not updating when selecting users from right hand pane on Security Information window. Added Visual indicator for Inactive Users on left and right hand panes of Security Information window. Added prompt to enable Security Activity Tracking if opening Security Log window and there is no data to display. Updated Database Validation to identify and fix Database Users where the Security ID does not match the SQL Login. Updated Installer to track Mekorma Product Manager version and ensure it is not overwritten with older version. Fixed Area Page Navigation Button creation to ensure it occurs after Dynamics GP has created its area pages. Version 14.00 build 20 hotfix 4 (Released 21-Oct-2015) Installer: 14.00.0020.7 ------------------------------------------------------------------------------ Allow use of import statements in Runtime Execute window. Fixed access to SQL tables prior to login when using Logging on Startup option in Dex.ini Settings. Fixed Macro Logging so it does not display error message when first Dexterity Instance is not a Dynamics GP application. Updated Services to include Transactions handling and better script error handling, including Script Purpose Check. Remove Transaction rollback from ServicePostCustom Service Enabled Procedure. Fixed Database Validation Table Grant error on missing physical table. Fixed Database Validation Incorrect Parameters for CreateLogin issue on GP 2013 R2. Updated Installer to stop Microsoft Dynamics GP related Services. Version 14.00 build 20 hotfix 3 (Released 11-Sep-2015) Installer: 14.00.0020.6 ------------------------------------------------------------------------------ Updates to subscription expiry handling. Version 14.00 build 20 hotfix 2 (Released 03-Sep-2015) Installer: 14.00.0020.5 ------------------------------------------------------------------------------ Fixed issue with incorrect table names for Configuration Export/Import causing imports to fail. Version 14.00 build 20 Hotfix (Released 19-Aug-2015) Installer: 14.00.0020.4 ---------------------------------------------------------------------------- Fixed URI Meta data on ServicePostCustom Service Enabled Procedure for version 14.00 onwards. Fixed Logging options on Tools menu not initializing correctly after login. Problem caused by a Dexterity bug. Added check to see if SQL Database has a status of Online before it can be selected in Database Validation window. Added check to see if SQL Database has a status of Online before reading data and settings in System Status report. Added check to see if SQL Database has a status of Online before Executing scripts in SQL Execute window. Added check to see if SQL Database has a status of Online before Executing scripts in SQL Executer window. Changed Navigation for Runtime Execute, SQL Execute and .Net Execute to add the word Setup to differentiate from the Executer windows. Fixed Database Validation to create Logins as Disabled when the user is marked as Inactive within Microsoft Dynamics GP. Added Handling of Offline Databases to Database Validation window to avoid errors when database cannot be accessed. Added Handling of Incorrect System Database or Company ID in company database SY00100 table for version 12.00 onwards. Fixed issues with case sensitivity on Binary Sort Order SQL Servers for Database Validation. Improve clean up of previous Product Install. Version 14.00 build 20 (Released 02-Aug-2015) Installer: 14.00.0020 ------------------------------------------------------------------- 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). Version 12.00 build 19 (Released 18-Sep-2014) --------------------------------------------- Fixed prompt for SQL Login showing when using Start Logging on next startup only option in Dex.ini Settings window. Fixes for SQL Server 2000 Compatibility. Fixed About Product window Re-install button not being moved to the Ribbon when in Ribbon mode. Enabled Ribbon for Helper Functions window. Added four Product menu items to Tools menu on the Ribbon on every window. Added MBS_Debug_SkipVersionChecks Dex.ini setting for testing Product on upcoming versions. Updates to understand and handle Web Client Only users for GP 2013 R2. Added option to Product Feedback Survey dialog to allow for a reminder in 7 days. Added Dex.ini setting to disable GP 2013 R2 Ribbons in Desktop client on a per workstation basis. Added Procedures & Functions Mode to Resource Information window to allow identification of procedure and function scripts from logs. Added Area Page View to Menu Explorer window in Resource Explorer. Note: Build 19 adds 26 hours to total 1506 hours of development since 2008. Version 12.00 build 18 Hotfix (Released 23-May-2014) ---------------------------------------------------- Fixed incorrect position of Security ID field on Resource Information window. Added Dictionary ID to forms and reports dictionary lists in Security Information window. Added button to open Resource Information window from Security Information window. Added link to Product Portal when F1 is pressed for Help. Changed Security Profiler to only show dialog once per session when it wants to automatically open but access is denied. Added EnableServerDropDown setting to Startup tab of Dex.ini Settings window. Added DefaultLastUser setting to Startup tab of Dex.ini Settings window. Added DefaultLastCompany setting to Startup tab of Dex.ini Settings window. Fixed issues when main application window is minimized and Prevent application windows from opening outside of the visible desktop area is enabled. Note: Build 18 Hotfix adds 8 hours to total 1480 hours of development since 2008. Version 12.00 build 18 (Released 23-Feb-2014) --------------------------------------------- Fixed Table Records field not cleared when Clear Button is pressed on Resource Information window. Fixed Resource Information window displaying Resource Not Found prematurely when in Form, Window and Field mode. Clear cached copy of Runtime Execute script when Automatic Debugger Mode is not enabled so changes are immediately reflected. Clear cached copy of SQL Execute script when Automatic Debugger Mode is not enabled so changes are immediately reflected. Fixed Security setup for Security Information and Automatic Debugger Mode Status windows. Update Button Drop Down Lists in Security Information window so that they remain unsorted under GP 2013 SP2 or later. Fixed Exporting from Security Information Resources window failing when Security Task or Security Role ends with an asterisk (*). Hide unavailable options from the Debugger Menu on the main Product window to match the options button. Changed code to move post login tasks into the background when running on the web client to avoid causing home page not to appear. Remove Parameter Cleanup when changing companies or leaving Dynamics as it is causing issues with DUOS when changing companies. Fixed User Selection for Automatically Starting Triggers being lost in the Setup Automatic Debugger Mode window. Updated Dex.ini Write code to clear User Level Dex.ini setting, if Dex.ini setting should be Global. Fixed Writing of User Level Dex.ini settings to ensure settings are removed from the syUserDexIniSettings (SY01405) table when writing a blank value. Added display of Full and Self-Serve users to ScreenShot System Status for GP 2013 or later. Changed Configuration Export/Import window to use Desktop Alerts when Exporting and Importing completed. Added option to include Security Task and Security Role information on the Security Information Resources window. Added menu option to Refresh Resource Information syCurrentResources (SY09400) Table to the Security Information window. Changes to support Limited User Security Access made to Security Profiler and Security Information windows. Changed Logging of Security Events to only write log entries when Security Profile is open or Dynamics displays a security error dialog. Added options to stop or disable trigger after trigger has run and condition was met to Setup Automatic Debugger Mode window. Added additional validation of Debugger.xml Setup File version and build to avoid accidental overwriting when performing test upgrades. Changes to window position memory system to ensure that the window will not be opened beyond the visible areas of the desktop. Added Window Sequence Number to Resource Explorer and Menu Explorer as Window Resource ID and Window Sequence Number do not always match. Added additional dialogs during installation to setup Recommended Configuration for Advanced Mode and Path Setting. Added DebugFonts Dex.ini setting to the Reports tab of the Dex.ini Settings window (as per KB 870341). Added Word Template Processing Engine Logging settings to Dex.ini Settings window. Added feature to change Windows Bitmap Font size Registry Settings to the Other tab of the Dex.ini Settings window. Added Hyperlinks to Product Portal and Product Survey on the About Product window. Added Re-install Button to About Product window, so that Menus, Toolbars, Quicklinks and Security settings can be easily re-installed and re-applied to all users. Added feature to automatically show currently selected Window and Field information in the Resource Information window. Added Product Feedback Survey window to request feedback via online Survey. Added option to prevent application windows from opening outside of the visible desktop area into Administrator Settings window. Added Option to disable Visual Basic for Application (VBA) to the Dictionary Control window. Added Option to disable Visual Studio Tools Addins (VSTools) to the Dictionary Control window. Added Option to create or update Security Task and Security Role based on the Resources and Security Objects captured by the Security Profile window. Note: Build 18 adds 98 hours to total 1472 hours of development since 2008. Note: Database Validation adds 114 hours to the total. Version 12.00 build 17 hotfix 2 (Released 09-Apr-2013) ------------------------------------------------------ Fixed Product and ScreenShot Toolbar icons cannot be removed. Fixed Product and ScreenShot Quick Links cannot be removed. Fixed issue where newly created users were missing menus and/or toolbars. Fixed Composite Field Data not displaying for 3rd party Composite fields in Resource Explorer windows. Fixed SQL Profile Traces from multiple instances of Dynamics GP on the same SQL Server showing up as Stranded Traces. Updated Security Information Window to allow access to be controlled independently of the Microsoft Dynamics GP Security windows. Added Database Type field for Tables to Resource Information window. Fixed error message when searching for tables with spaces in their technical name on Resource Information window. Note: Build 17 hotfix 2 adds 8 hours to total 1374 hours of development since 2008. Version 12.00 build 17 hotfix (Released 25-Jan-2013) ---------------------------------------------------- Fixed repeated creation of Screenshot and Product Toolbar buttons on the Standard Toolbar. Fixed SQL Profile Trace setup errors when user exists in SY01400 table but does not have a SQL login. Note: Build 17 hotfix adds 7 hours to total 1366 hours of development since 2008. Version 12.00 build 17 (Released 19-Dec-2012) --------------------------------------------- Added check to avoid Product main window and Automatic Debugger Mode Status window from opening outside the desktop area. Added check for non POWERUSER users before suggesting to add MBS DEBUGGER USER Security Role, to handle when all users are POWERUSERs. Fixed results List view on SQL Execute window not sizing when window first opened. Fixed Automated Screenshot capture so that it includes the list of attached screenshot bitmap files. Fixed Information Button icons on ScreenShot and Dictionary Control windows. Updated Lookup windows for wider description fields and fix tooltips on New and Open buttons. Changed Settings Applied dialogs to Desktop Alerts for the Administrator Settings, Dictionary Control and Dex.in Configuration windows (except when on Web Client). Changed Company Colors to store color selections at both system and company level to ensure colour themes are maintained when copying databases. Added ability to selectively import items contained in a Debugger Settings xml file on the Configuration Export/Import window. Added Splitter Controls with position memory to "Explorer" style windows in the Resource Explorer. Added Splitter Control with position memory to the Security Information window. Enable Colors in the Dexterity Script Debugger and editing of option from the Automatic Debugger Mode Setup and Runtime Execute windows. Add Options menu to refresh application navigation to Security Profiler window, allows users to apply security changes without exiting. Added Product button to Standard Toolbar. Added Product icon to About Product and main Product windows. Added Product and Capture Screenshots to Quick Links on the Homepage. Added Logging Password and option to hide Individual Logging Mode options to the Administrator Settings window. Added optional Logging Password check to Turning on Manual Logging Mode via main Product window or Tools menu. Added Back Button to Resource Information window to return to previous resources since window was opened. Added Array and Component Fields to Resource Information window and fixed Back Button for field only searches. Added zoom to Table Resource Descriptions and Field Resources Descriptions windows from Resource Information window. Added Data Type information to Field information section on Resource Information window. Changes for Dynamics GP 2013 compatibility with Named System Databases. Updates to Handling of Dex.ini settings to handle separate Global and User Level Dex.ini files introduced in Dynamics GP 2013. Update ScreenShot to handle separate Global and User Level Dex.ini files introduced in Dynamics GP 2013. Update Administrator Settings window to handle separate Global and User Level Dex.ini files introduced in Dynamics GP 2013. Update Setup Automatic Debugger Mode window to handle separate Global and User Level Dex.ini files introduced in Dynamics GP 2013. Update Dex.ini Configuration feature to handle separate Global and User Level Dex.ini files introduced in Dynamics GP 2013. Add support for Exchange Mail (via Exchange Web Services), set up in Administrator Settings window. Added Support for Windows 8 and Windows Server 2012 to System Status Report. Updated Security Profiler and Security Dialogs to handle when access is denied due to the resource being excluded from the Web Client. Changed Dictionary Control to Disable Editing of the Launch file when running on the Web Client. Disabled Window Title and Company Color Schemes in the Administrator Settings window when on Web Client. Updates to not use Window Size and Position memory on Web Client as moving and sizing windows in the Web Client is not reflected in Dexterity. Disabled saving and email of screenshots in ScreenShot window when on Web Client as it is not supported. Disabled Macro Logging mode when on Web Client as it is not supported. Adding message that Microsoft Outlook Client email mode is not available when in the Web Client. Changed Desktop Alerts to use System Dialogs on Web Client as Desktop Alerts are not supported on Web Client. Updates for Web Client User Interface issues and Window Ribbons for Dynamics GP 2013. Note: Build 17 adds 72 hours to total 1359 hours of development since 2008. Version 11.00 build 16 Hotfix (Released 12-Jul-2012) ---------------------------------------------------- Fixed keyboard shortcuts on Runtime Execute and SQL Execute windows for Execute Button, now Alt-E or Ctrl-E. Fixed issue with Cache tables when writing to path with a period (.) in it. Fixed Resource Explorer Exporting showing "[Not Found]" for blank columns on display. Fixed logging of Smartlist related security errors causing logs to grow. Now errors will only be logged if the Security Profiler is open. Fixed Export File Names from Security Information Resources window to represent data being exported rather than current user and company. Fixed Resource Explorer so that it does not generate an error when checking the number records in a table that does not exist in SQL Server. Fixed Dictionary Control being applied to incorrect dictionaries when Dictionary ID is contained within a Dictionary ID of an enabled product. Fixed Dictionary Control being disabled for non "after login" settings when starting Automatic Debugger Mode or Manual Logging Mode. Added updated Status column on Security Profiler to display when the Status value has been changed from standard settings by Dictionary Control. Updated Automatic Debugger Mode when using Automatic Start to compress User/Company data by storing All User or All Company records. Changed non dictionary Security Object access denied messages to be treated as warnings by the Security Profiler Automatic Open mode. Fixed Illegal Address error from Security_Profiler_Other_POST script which could sometimes occur when switching companies. Disabled Automatic Debugger Mode Status hyperlink on main Product window when access to the window is not available. Added separator to Options menu on main Product window to match the Debugger menu on the window. Note: Build 16 Hotfix Release adds 14 hours to total 1287 hours of development since 2008. Version 11.00 build 16 (Released 05-Jan-2012) --------------------------------------------- Fixed Security Information Show Resources not displaying when a Security Role not assigned to any users was selected. Fixed Logs, screenshots and table/record dumps being overwritten when new logs started in the same second by adding suffix to filename. Update Trigger handling to allow Restore Value option to work for Text Field datatypes. Fixed Security Privilege errors for non Dictionary Resource Security Objects not being logged when Security Profiler is running in the background. Fixed Manual stopping of non-logging triggers using MBS_Trigger_Stop helper function not working. Fixed Field Physical Name search in Resource Information window to handle Composite and Array fields correctly. Fixed Tables Containing Field Lookup in Resource Explorer to handle Composite and Array fields. Fixed Screenshot not being able to save image files to a UNC pathname. Files now saved to temp and moved to UNC Path. Added check to see if email system is in use when emailing Screenshots as part of processing a trigger. Updated Product main window to move Logging Options to a sub window and just show current status. Added optional display of form details when Security Privileges error is displayed to Administrator Settings. Added Table restricted to Table Trigger Type to Automatic Debugger Mode to provide form restricted database triggers. Added Focus Event with Table Trigger Type to Automatic Debugger Mode to provide access to a specified table buffer from the form. Added Form Menu Trigger Type to Automatic Debugger Mode. Added Minimize Debugger Log Entries for use with Automatic Debugger Mode Non-Logging Triggers to avoid writing to the Debugger Log. Add option to Exclude Selected Users on Automatic Debugger Mode Triggers rather than include selected users. Added option to control which logging modes are restarted when Automatic Debugger Mode trigger fires. Added MBS_Logging_Start and MBS_Logging_Stop helper functions to programattically turn on and off Manual Logging Mode. Updated ScreenShot's System Status report with Debugger Version and Settings folder, SQL Session SPID, and fixed Data Folder Path. Added HOMEDRIVE and HOMEPATH Environment Variables to ScreenShot's System Summary Report. Added Physical Memory Status to Screenshot's System Status Report. Added Database information about System and Company Databases to ScreenShot's System Status report. Added Dex.ini Setting MouseWheel to the Other tab of the Dex.ini Settings window. Added MBS_Debug_LogAppDetails Dex.ini Setting to log details of the current application, available from Startup tab of Dex.ini Settings window. Added Export to File or Email option to Tables Containing Field Lookup in Resources Explorer. Added Export to File or Email option to Associated Tables Lookup in Resources Explorer. Added performance enhancements to reading of the debugger.xml setup file using ctree caching files. Improved performance for XML Export, Resource Information and Resource Explorer windows when displaying the number of records in tables. Extended Automatic Debugger Mode Trigger Name field size from 30 to 60 characters and updated windows and reports to match. Extended Runtime Execute Script Name field size from 30 to 60 characters and updated windows and reports to match. Extended SQL Execute Script Name field size from 30 to 60 characters and updated windows and reports to match. Extended XML Export Profile Name field size from 30 to 60 characters and updated windows and reports to match. Added smart positioning for initial position of Product main window based on primary screen resolution. Added smart positioning for initial position of Automatic Debugger Mode Status window based on primary screen resolution. Added Window Position Memory to Automatic Debugger Mode Status window using MBS_Debug_WinDebuggerStatus Dex.ini setting. Added separate Auto Open setting to automatically open the Product main window after login, previously was controled by Debugger Setup Mode setting. Added checks for Logging Paths selection to check folder exists and has write access. Added highlighting of Linked Table on the Associated Table Lookup for a Form in Resource Explorer. Updated Automatic Debugger Mode Trigger Administration and Configuration Export/Import windows to show non-logging triggers with a different icon. Added Macro Recording Facility to Individual Logging, Manual Logging Mode and Automatic Debugger Mode. Added check for MouseWheel=FALSE on version 10.0 and disable Macro Recording if Mouse Scroll Wheel not disabled. Added SQL Profile Tracing Facility to Individual Logging, Manual Logging Mode and Automatic Debugger Mode. Add features to Administrator Settings to configure, create and remove SQL Profile Tracing SQL Components. Added Support for SQL Profile Tracing to specify Maximum Trace File Size and Maximum Number of Trace Files. Added Version Control Checking for SQL Profile Tracing Stored Procedures to ensure SQL Tracing is only enabled when latest stored procedures are installed. Added Check for SQL version to ensure that SQL Profile Tracing Events not compatible with SQL Server 2005 are excluded from the stored Procedures. Added SQL Profile Trace SQL Components and permissions cleanup into un-install feature. Added Detection and cleanup of stranded SQL Profile Traces on login. Added SQL Profile Trace List window to display active traces and allow for stopping of stranded traces. Added Trigger Administration Window for quick changes to delete, enable/disable or change start mode of triggers. Added by User, by Database and by Role SQL Server Roles Views to right hand pane of Security Information Window. Reserve Tilde (~) prefix for Trigger IDs, Script IDs and Profile IDs for use by Microsoft Support. Added Automation Functionality for use by Microsoft Support. Added Dex.ini settings MBS_Debug_Automate_File, MBS_Debug_Automate_Script, MBS_Debug_Automate_Status. Added Additional User Confirmation Dialogs for Microsoft Support Diagnostics. Note: Build 16 adds 202 hours to total 1273 hours of development since 2008. Version 11.00 build 15 (Released 22-Jul-2011) --------------------------------------------- Fixed Screenshot processing dialog covering screenshot captured bitmaps. Fixed Menu Explorer button not repositioning correctly when Automatic Debugger Mode Setup window resized. Fixed initial position for Product Main window not opening in bottom right corner. Version 11.00 build 15 (Released 29-Jun-2011) --------------------------------------------- Fixed Dictionary Control to not enable triggers for all products unless Dictionary Control is actually in use. Fixed Call Stacks in Use Error when using Reject Script option on the Automatic Debugger Mode Setup window. Fixed Tab Sequence and focus changes for Automatic Debugger Mode Setup window. Fixed error when Non-Logging Mode Triggers captured Table dumps and record dumps to xml files. Fixed Script Find and Replace to mark window as changed when text is replaced. Fixed Automatic Debugger Mode Setup window to change to Script tab when using Script menu commands. Fixed ScreenShot temporary files not being removed when emailing without using preview Send Email window. Fixed System Status to show number of products and correct product name for GP 2010 onwards. Fixed Series not showing correctly in Resource Explorer for resources with a series greater than System. Fixed Resource Explorer displaying folders for resources currently hidden from display. Fixed Drill back to Resource Information window from Security Profiler Window for non-resource Security Objects. Fixed Dictionary not changing when selecting Table from the Tables containing Field Lookup. Fixed handling of Maximized windows when remembering window state. Fixed issue with more than one User ID and/or Company ID prefix being added to Window Titles. Fixed Conversion of inline comments (--) on last line with no final carriage return on SQL Execute window. Fixed handling of Excel Report Builder Security Objects, which were added for v10.0 Service Pack 2 or later. Fixed handling of Extender Security Objects, which were added for v10.0 Service Pack 4 or later Fixed issue with Extender Enterprise by adding check for Microsoft Extender vs Extender Enterprise as internal resources are different. Added Logging Defaults to the Administrator Settings window. Added functionality to allow selection of which logging options are used with Manual Logging Mode. Updated Automatic Debugger Mode Setup window to use tabs to allow additional actions and options. Added Menu Explorer lookup to the Automatic Debugger Mode Setup window. Changed Automatic Debugger Mode to allow Keep Focus and Restore Value options to work without Reject Script. Added Logging selections to the Automatic Debugger Mode Setup window. Added functionality to allow selection of which logging options are used with Automatic Debugger Mode Triggers. Added Desktop Alert action to Automatic Debugger Mode. Added SQL Where Clause to Automatic Debugger Mode Triggers when exporting the entire table. Added ScreeenShot actions to the Automatic Debugger Mode setup window. Added functionality to allow Screenshots to be saved or emailed when Automatic Debugger Mode Trigger fires. Updated Automatic Debugger Mode Trigger Report from the Setup Automatic Debugger Mode window to include new fields. Added check to confirm existence of Dictionary files from ScreenShot's System Summary report. Added MBS_Debug_Version dex.ini setting, used to check when Product is upgraded on current workstation. Added automatic enabling of Script Debugger Enhanced mode, unless already specifically disabled. Fixed performance issue when displaying series information on Security Information Resources window. Updated Security Information Resources Window to use background processing (when possible) to populate the listview. Updated Product main window with User Interface improvements. Updated Keyboard shortcut for Raise All Windows menu command to Ctrl-Shift-R to avoid clash with Navigation Lists Refresh. Added Tooltips to show Dex.ini setting names on Dex.ini Settings and Dex.ini Configuration windows. Added automatic update of Standard Mode Security Role for all users in all companies. Added prompt for enabling Advanced Mode during initial installation by user with POWERUSER role. Added Data Type, Control Type, Storage Size and Keyable Length to Resource Explorer windows when displaying Field Resources. Added number of items displayed to status bar area of Resource Explorer Windows. Added status line and table record count to the Associated Tables Lookup in the Resource Explorer. Added status line and table record count to the Table containing Fields Lookup in the Resource Explorer. Added status lines to the Key lookup window in the Resource Explorer. Added Field Sequence number to Table Explorer window in Resource Explorer to show fields in table order. Added number of records for Table Mode in the Resource Information window. Changed Column order on Security Profiler window to provide more user friendly information first. Added display of Series Name and number to Security Profiler window. Updated Security Profiler Report from the Security Profiler window to include series fields. Added visual cues to System nodes in Security Information window to show which Roles, Tasks and Alternate Modified IDs are assigned to the current user. Added Security Object Type and Series node into the left pane of the Security Information window. Added User & Company, Security Task, Security Role and Alternate Modified IDs display to Security Information Resources window. Added optional display of Series Name and number to Security Information Resources window. Added memory of checkboxes on the Security Information Resources window. Updated Window position and size functionality to ensure that stored size is not less than window's minimum. Added Inclusion of System Database when Converting Dexterity table references in SQL Execute for other system series. Added warning dialog as a Safety Check for DELETE, DROP or TRUNCATE command into SQL Execute window. Added warning dialog as a Safety Check for system Dex.ini settings into the Dex.ini Configuration window. Added Display of Dex.ini Settings that could be changed into the Dex.ini Configuration window. Added SQL Where Clause to XML Export Window to allow for selective exporting of data from tables. Added MBS_Trigger_Start Helper Function to programmatically start an Automatic Debugger Mode Trigger. Added MBS_Trigger_Stop Helper Function to programmatically stop an Automatic Debugger Mode Trigger. Added Helper Function MBS_Export_SQL_Query_To_File to export SQL Queries to Text Files. Added Email System API call: MBS_Email_API which can be called using call with name in dictionary. Added populating of syCurrentResources (SY09400) table with other resource types when clearing data. Added Security Object Explorer window to Resource Explorer to view non-resource Security Objects. Automatically populate syCurrentResources (SY09400) table when opening Security Information window. Added Support for additional Security Objects to Security Information window. Added support for Security Information Resource window for non-resource security objects. Added Support for additional Security Objects to Security Profiler Window. Added Automatic Opening of Security Profiler for non-resource Security Objects. Added support for Unknown Security Objects to the Security Profiler and Security Information Windows. Added support for Extender Security Objects to the Security Profiler and Security Information Windows. Added support for SmartList Builder Security Objects to the Security Profiler and Security Information Windows. Added support for Unknown Security Objects to the Security Object Explorer window in the Resource Explorer. Added support for Extender Security Objects to the Security Object Explorer window in the Resource Explorer. Added support for SmartList Builder Security Objects to the Security Object Explorer window in the Resource Explorer. Added support for Security Objects to Resource Information Window. Added a printable report to the Security Information Resources window. Added interface for ExportLinesPerPage and ExportPDFLinesPerPage settings on Report tab of Dex.ini Settings window. Note: Build 15 adds 154 hours to total 1071 hours of development since 2008. Version 11.00 build 14 (Released 25-Nov-2010) --------------------------------------------- Added Ctrl-R as Shortcut Accelerator Key for Raise All Windows (v10.0 or later). Shift Company Color data storage from DUOS to coUserDefaults table, with automatic backwards compatibility. Added support for Temporary tables into the Table Explorer window in the Resource Explorer. Added support for Temporary tables into the Resource Information window. Added Table Keys information to Table Explorer window in the Resource Explorer. Added Table Keys lookup window to Resource Explorer. Added Display Keys button to Resource Information window when in Table and Field mode. Added text to Dex.ini Changes window shown at login to identify it as a Suppport Debugging Tool feature. Added User Account Control (UAC) check when attempting to un-install Product. Added User Account Control (UAC) check when move products or deleting products in the launch file using Dictionary Control. Added User Account Control (UAC) check when unchunking during installation. Added User Account Control (UAC) state to the System Status report form ScreenShot. Changes to minimise Suppport Debugging Tool scripts captured when turning on and off script logging. Changes to Reject Script functionality in Advanced Debugging Mode to restore fields to their previous values. Changes to Reject Script and Reject Record functionality so it can be controlled by using the OUT_Condition variable. Added Keep Focus and Restore Value options to Reject Script functionality in Advanced Debugging Mode. Fixed Non-logging triggers disabling Manual Logging Mode and Automatic Debugger Mode. Fixed Security Information Show Resources Window showing Resource ID and Dictionary ID in incorrect columns. Note: Build 14 adds 26 hours to total 917 hours of development since 2008. Version 11.00 build 13 (Released 13-May-2010) --------------------------------------------- Fixed Runtime version checks on login and for Dex.ini Settings window and Script Logging hotfix. Fixed Manual Logging Mode and Automatic Debugger Mode disabling active non-logging triggers. Fixed restoring of Toolbar colors for depressed buttons when de-activating Company Colors. Fixed Resource Explorer, Table Explorer, Report Explorer seeding when there is a space in the resource name. Change SQL Execute Tab Delimited Export to use .txt extension. Added User ID and Company ID into Trigger Fired message for Automatic Debugger Mode, shows on email messages sent. Added Clear Button to the Security Profiler Window. Added MBS_Debug_ShowRuntime Dex.ini setting to control access to Runtime Engine resources. Added support to Resource Explorer, Table Explorer, Report Explorer to reference Runtime Engine. Added support for Automatic Debugger Mode triggers and Runtime Execute scripts to reference Runtime Engine. Improved Company Color Settings depending on version of Microsoft Dynamics GP. Added Email Address field to Options window of Automatic Debugger Mode Setup window which can be used to override the default Administrator email address. Added smarter form opening and closing logic to Resource Explorer to prevent it being closed while still being used by another form. Performance enhancements when opening windows and starting and stopping logging modes. Added memory to Resource Information window; Resource Type, Search Mode and Case Sensitive fields. Added feature to remember current location when changing views to show or hide missing and hidden resources in the Resource Explorer and Menu Explorer windows. Added window position memory to the main Product window. Added All Dictionary modes to tree for the Resource Explorer, Table Explorer and Report Explorer windows. Added Dictionary and Series information to the right hand panes of the Resource Explorer, Table Explorer, Menu Explorer and Report Explorer windows. Added Table Group Display and Technical names to right hand pane of the Table Explorer window. Added Export to tab delimited, comma delimited or html from the Resource Explorer, Table Explorer, Menu Explorer and Report Explorer windows. Added Resource Selection via Resource Explorer to Security Information window. Added security check to Security Information window to ensure user has access to Security Setup windows. Added Security Information window to Options menu and Debugger Menu to allow window to be opened directly by user. Added Security Information Resource window to show security information down to resource level. Added Theme Selection for Company Color coding feature with 16 themes. Added Raise All Windows feature to the Application Menu (v10.00 or later). Note: Build 13 adds 241 hours to total 891 hours of development since 2008. Version 11.00 build 12 (Released 09-Mar-2010) --------------------------------------------- Update Operating System Identification for new Operating Systems supported by Runtime_GetOSInfo() function. Fixed XML Table Import window failing to import. Version 11.00 build 12 (Released 24-Feb-2010) --------------------------------------------- Initial v11.00 release Added MAPI option to Email Modes as MAPI now supports sending of multiple attachments (v11.0 only). Changed Context menus on Security profiler and Resource Information windows to use new Dexterity menus (v11.0 only). Improved Dexterity resource conversion handling on the SQL Execute window to allow table names not to be specified. Added feature to filter Associated Tables lookup in the Resource Explorer to only include tables having a specified field. Added feature to Resource Information window to display tables which contain a specified field. Version 10.00 build 12 (Released 10-Feb-2010) --------------------------------------------- Fixed Company Based color schemes not changing when switching companies. Fixed Company Based Color schemes being reset even when disabled in Administrator Settings. Fixed Error message when using SQL Execute window against the System Database. Fixed Login dialog appearing when using "Start Logging on next startup only" option. Fixed incorrect colouring of static text in window toolbar for Resource Explorer and SQL Execute Windows. Fixed handling of v10.0 table security for Resource Information, Security Profiler and Security Information (v10.0 only). Fixed looping caused by Security Profiler attempting to open when access to the Security Profiler window is denied. Fixed security access error when Product menu window attempts to open automatically when access is denied. Fixed Resource Information window Open Button to allow it to work when resource name contains spaces. Fixed Default Path for three logging facilities to use dex.ini path if specified. Fixed issue where file dialogs were causing application to crash. Allow ScreenShot to email System Status and optional files without windows being selected. Added Network User Name to Screenshot's System Summary Report. Added "Show Debug Messages on next login" option to Dex.ini Settings window. Added new ScriptLogEnhanced Dex.ini setting to Dex.ini Settings window. Added control of Windows Toolbar color to Company Based color schemes (v10.0 only). Added Report Explorer to Resource Explorer for use with the Resource Information window. Added Series All to the Report Explorer window to show all reports regardless of series. Added Series All to the Table Explorer window to show all tables regardless of series. Added Table Groups to the Table Explorer window to show tables in their logical table groups. Added Table Group All to the Table Explorer window to show tables regardless of the table group they belong to. Added support for custom reports to Report Explorer and Resource Information windows. Added User and Company tree to Security Information window. Added Security Role, Security Task and Alternate Modified Forms and Report Views to Security Information window (v10.0 only). Added Security Role (System Level), Security Task (System Level) Views to Security Information window (v10.0 only). Allow Security Information window to be opened without a resource selected so that new views can be used. Added ability to disable Modified forms and reports from the Dictionary Control Window. Speed up Debugger Settings window Tab 1 (Debug) display code. Removed pause caused when Resource Explorer is opened by initializing each explorer window when it is first used. Performance improvements to XML Table Export and XML Table Import features. Approximately 25% faster. Speed up loading of Lookup windows by only loading required table from setup file. Added warning message to Security Information window when Security is not enabled for a company. Remember Last Company Logged into using SQLLastCompany Dex.ini setting. Added Apply Button to Dictionary Control window. On SQL Execute window, moved Syntax information to an additional window to increase screen real estate. Added better handling of notification messages when no data sets returned on SQL Execute window. Added Seeding of Resource Explorer windows from Resource Information Window and XML Table Export window. Improved Usability of Resource Explorer window to allow tree selection to be used when no items selected in list. Added Tooltips to display file paths, useful when the path is longer than the visible areas of the field. Added Zoom to Resource Information window from Security Profiler window using double click or context menu. Added Table handling for Dex.ini Configuration window. Added Dex.ini Configuration window and processor on login. Added Administrator Default Dex.ini Settings to Dex.ini Configuration window. Added Workstation Configuration Override setting to Dex.ini Configuration window. Added additional handling to Dex.ini Settings window when changing settings controlled by Administrator. Added audit information (Created Date, Modified Date, User ID, Windows User) to setup tables and add additional table for XML Table Export Profiles. Added Profiles to XML Table Export window to allow multiple sets of tables to be setup and exported. Added Report to XML Table Export window. Updated Configuration Export/Import to support XML Table Export Profiles. Note: 650 hours of development since 2008. Version 10.00 build 11 (Released 14-Jul-2009) --------------------------------------------- Updated Trigger Report to match changes for Build 11. Fixed security access for XML Progress window. Version 10.00 build 11 (Released 02-Jun-2009) --------------------------------------------- Added Keyboard Shortcut to Tools menu for opening Product. Added Keyboard Shortcuts to Tools menu for starting and stopping Manual Logging Mode. Added Product menu item to individual window's Tools menu so it is available at all times (v10.0 only). Added ScreenShot menu item to individual window's Tools menu so it is available at all times (v10.0 only). Added menu items for starting and stopping Manual Logging Mode to the individual window's Tools menu so it is available at all times (v10.0 only). Added Keyboard Shortcuts to Debugger Menu. This is available under Extras (v8.0 and v9.0) or on the window's menu bar itself (v10.0). Added Keyboard Shortcuts to the Options menu on the main Product window. Removed Zoom to About window from main window, you can use Options >> About instead. Added NULL detection and handling to SQL Execute window. Added Exception handling to external calls used for right click context menu. Added Path checking and Exception Handling to XML Export and XML Import windows. Added Resource Explorer windows into Product, so Advanced Security is no longer needed. Added Setup File (debugger.xml) Version Check to ensure all workstations using a setup file have the same build. Fixed duplicate issue when saving Triggers or Scripts after printing report from window. Fixed Date and Time spacing on Security Profiler Report. Fixed Dictionary Control disabling of Alternate Windows and Reports. Fixed table positioning when browsing through records after saving with SQL Execute, Runtime Execute and Setup Advanced Debugger Mode windows. Fixed Resource Explorer lookups activating Resource Information window Search Again mode when returning values. Prevent selection of Temporary Tables from XML Export window. Global Change of font back to System font to enable easier translation. Automatic Debugger Mode Performance improvements, no longer reading XML Setup file when triggering. The Setup file is now only read when the triggers are registered. Improved Load and Save performance of Setup Automatic Debugger Mode, Runtime Execute and SQL Execute windows. Performance improvement by caching SQL Execute and Runtime Execute scripts called by Automatic Debugger Mode Trigger scripts. Added Tabs to Administrator Settings window to allow for new options. Added Company Based color schemes similar to VBA method described in the Hybrid - Changing Screen Colours Depending on Company Example blog post. Added option to activate Test or Historical dialog when logging into companies, based on method described in the Setting up Test and Historical Companies blog post. Added option to change the titles on the main Application window (v8.0 and v9.0) or for all Windows (v10.0 only) to include Company ID and/or User ID. This allows quick identification of windows when running multiple instances of Microsoft Dynamics GP. Added Email Body template which is used with the Send Email window. Added Email Signature which is added to all emails sent by the Product. Added Email Engine supporting mail via Outlook client or SMTP via CDO. The SMTP mode can be used from a workstation or terminal server which does not have Outlook installed and configured. Added Send Email window for sending separate emails. This provides a user interface when using SMTP mode which can be used for reporting issues to the system administrator. Added Export to File or Email to SQL Execute using Tab Delimited, Comma Delimited or HTML Table formats. Added Send Email for use in Triggers when conditions are met using Automatic Debugging Mode. Added Trigger Date Restriction to Options window for use with Automatic Debugger Mode. Added options to execute reject script or reject record commands from non logging Triggers. Added ability to enter a Table's Physical Name on the XML Export window. Added ability to lookup a form's associated tables from the Resource Information Window. Added ability to lookup a form using menu navigation from the Resource Information Window. Added facility to call Runtime Execute scripts from the Report Writer using the rw_ReportStart, rw_ReportEnd, rw_TableHeaderString, rw_TableHeaderCurrency, rw_TableLineString, and rw_TableLineCurrency report writer user defined functions. See following KB for more information: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;888884 Version 10.00 build 10 (Released 18-Dec-2008) --------------------------------------------- Update About Box to use Microsoft Dynamics GP product name from Dynamics.set. Change Trigger Handlers to stop logging earlier so logs do not include Debugger scripts. Added additional Troubleshooting messages into Log file. Added ScreenShot functionality based on eOne Integrated Business Solutions Screenshot utility code. Added Report to Security Profiler window. Added Export and Import to Security Profiler window. Added Open and Security Info features to Security Profiler window. Added right mouse click context menu to Security Profiler window. Added Security Info window to display the Security information of a selected resource. Added Administrator Settings window to store Administrator settings. Added Automatic Open option for Security Profiler window. Added Table Group Resources to Resource Information window. Added Search Mode (Exact Match, Begins With, Contains) and Case Sensitive checkbox to Resource Information window. Added Search Again feature to Resource Information window. Added Open and Security Info features to Resource Information window. Added right mouse click context menu to Resource Information window. Fixed No Debugging Tool SQL Logging turning off when swapping companies. Ensure Product triggers are active after returning from Modifier or Report Writer. Version 10.00 build 9 (Released 03-Sep-2008) -------------------------------------------- Changed DebugRW interface and added extra Dex.ini Settings. Version 10.00 build 8 --------------------- Added Non Logging Trigger Mode. Version 10.00 build 7 --------------------- Added Timed Event Triggers Feature To Automatic Debugger Mode. Added Product Setup mode Dex.ini setting to prevent automatic starting of Triggers. Added Start Logging on next startup only Dex.ini setting to allow logging of the Login process. Added User Interface for Dex.ini setting AllowWrongDex. Added User Interface for Dex.ini setting ApplicationName. Added User Interface for Dex.ini setting AutoInstallChunks. Added User Interface for Dex.ini setting DebugRW. Added User Interface for Dex.ini setting ExportOneLineBody. Added User Interface for Dex.ini setting QueueMoreInfo. Added User Interface for Dex.ini setting ShowAdvancedMacroMenu. Added User Interface for Dex.ini setting ShowAllMenuItems. Added User Interface for Dex.ini setting SkipVersionChecks. Added User Interface for Dex.ini setting SuppressDateChangeDialog. Added User Interface for Dex.ini setting SuppressSound. Improved Path handling so allow logs and exports to be stored in designated path along with the setup file. Added zooms to allow destination folders to be opened, only when in Advanced Mode. Version 10.00 build 6 --------------------- Added Configuration Maintenance window to allow setup tables to be cleared. Added Configuration Export/Import window to allow setup objects to be exported and imported. Added Script Context Selection to Automatic Debugger Mode Setup window. Added Report Printing Facility to Automatic Debugger Mode Setup window. Added Report Printing Facility to Runtime Execute window. Added Report Printing Facility to SQL Execute window. Added Runtime Engine version build check. Added Insert Code Button to add standard Dexterity code constructs to scripts. Added Dexterity Syntax colour highlighting and Font Style and Size control. Added Find, Find and Replace, and Syntax Checking. Added SQL Select Statement Execute Helper Function. Added Dexterity Sanscript Execute Helper Function. Added SQL Execute Script ID loader Helper Function. Added Runtime Execute Script ID loader Helper Function. Added Parameter Set, Get, Delete and Delete All Helper Functions. Added Debugging Tool Logging Helper Function. Version 10.00 build 5 --------------------- Moved DEX.INI settings to a new window. Added DEX.INI setting to rename DEXSQL.LOG each day. Changed Interface to use On/Off buttons rather than checkboxes. Added Manual Logging Only Mode. Added Multiple Trigger functionality so that multiple issues can be debugged from a single install. Added Support for Triggers on Focus Events, Procedures/Functions and Warning Dialogs. Added features to select users and companies to control which users triggers activate for (support for Terminal Server). Added Debugger Status window to show which triggers are active at any time. Added Window state, position and size memory so that main feature windows open where they were last closed. Added Product Advanced Mode to hide Administrator only features unless enabled. Added option to change location of Debugger.xml Setup File so that a single setup file can be shared. Added ability to store multiple scripts for Runtime Execute. Added ability to store multiple scripts for SQL Execute. Added Automatic Syntax Check on saving to Debugger Setup and Runtime Execute. Added Helper Functions to simplify working with Window Fields and Table Fields across dictionaries. Added Help Function Assistant to add Help Function code to scripts. Added Product User Guide manual. Version 10.00 build 4 --------------------- Initial v10.00 release Version 9.00 build 4 -------------------- Add XML Record Dump to Automatic Debugger Mode Add XML Table Dump to Automatic Debugger Mode Change format of Debugger.xml Setup file to store additional information Add Logging of access denied from Security Profiler Add XML Table Export facility Add XML Table Import facility Add Dictionary Control facility Increased Security checks for access to XML Export, XML Import and Dictionary Control windows Version 9.00 build 3 -------------------- Add Read Trigger to Automatic Debugger Mode Improve Resource Information Window Version 9.00 build 2 -------------------- Add Resource Information and Security Profiler Version 9.00 build 1 -------------------- Initial Build External APIs ============= Email System API call example code ---------------------------------- local string l_EmailFrom; local string l_EmailTo; local string l_EmailCC; local string l_EmailBCC; local string l_EmailSubject; local text l_EmailBody; local text l_EmailSignature; local boolean l_EmailSignatureDefault; local text l_EmailAttachments; local boolean l_EmailPreview; local boolean l_EmailAutoSend; l_EmailTo = "email@domain.com"; l_EmailSubject = "Email API Test"; l_EmailBody = "This is a test of the Email API"+char(13); l_EmailSignatureDefault = true; l_EmailAttachments = l_EmailAttachments + "C:\Dex1000\Data\Dex.ini"+char(13); l_EmailAttachments = l_EmailAttachments + "C:\Dex1100\Data\Dex.ini"+char(13); l_EmailPreview = false; l_EmailAutoSend = false; call with name "MBS_Email_API" in dictionary 5261, l_EmailFrom, l_EmailTo, l_EmailCC, l_EmailBCC, l_EmailSubject, l_EmailBody, l_EmailSignature, l_EmailSignatureDefault, l_EmailAttachments, l_EmailPreview, l_EmailAutoSend; Dynamic Trigger Based Logging ============================= Use the MBS_Debug_LogListPath Dex.ini setting to define the path to a tab delimited text file with the following columns. The first line is the headers for the columns. Dict Event Resource SubResource FieldResource 0