#GPPT Preventing Invalid Characters in Customer, Vendor and Item IDs

This is another “Must Have” free customization example for you Microsoft Dynamics GP system when you have GP Power Tools – Developer Tools module.

When creating new Customer, Vendor and Item cards, it is possible to include certain characters in the ID fields which can cause issues with Microsoft Dynamics GP, its ISV products and integrating products.

#Dexterity Announcing Dexterity Training before Community Summit 2024 in San Antonio, TX, USA

I will once again be running the 5-day Dexterity Fundamentals for Dynamics GP bootcamp training class in the week before the Community Summit conference in San Antonio, Texas, USA in October. Please register for the training now and plan to be in San Antonio for the week before the conference.

Dexterity is the development environment that Microsoft Dynamics GP is built on and the best tool to use for any customization to the user interface of the product. Knowledge of Dexterity is vital for anyone customizing Dynamics GP even when using other development tools such as GP Power Tools – Developer Tools module, Visual Studio Tools (C# or VB .Net) or “End of Life” VBA (Visual Basic for Application).

#GPPT #VSIT Adding Windows to Microsoft Dynamics GP Menus with GP Power Tools

Here is a quick project that can make using Microsoft Dynamics GP much easier for your users. We are going to use GP Power Tools along with the free menu module of Visual Studio Integration Toolkit to add windows to the application level navigation menus.

For our example we are going to use the Professional Services Tools Library and add a menu to the main window of the product as well as the Receivables Transaction Unapply window.

[Edit] We are also going to add the Item Reconciler window as that requires some different techniques.

#GPPT Tracking changes to Item Cards Version 3

This is a further update to the previous version of the change tracking project for Item Cards:

• #GPPT Tracking changes to Item Cards Version 2

Based on the version 2 project, this update adds optional emailing of the changes made to a specified address.

#GPPT Tracking changes to Customer and Vendor Cards Version 4

This is another update to the previous versions of the change tracking projects for Customer and Vendor cards:

• #GPPT Tracking changes to Customer and Vendor Cards Version 3

Based on the version 3 projects, this update adds optional emailing of the changes made to a specified address.

#GPPT Remotely requesting immediate Automatic Logout

GP Power Tools has very powerful and flexible Automatic Logout functionality to gracefully log idle users out of Microsoft Dynamics GP. However, this feature requires the user to be idle for a specified period before it will attempt to logout.

As an Administrator there are times where you would like users to exit Microsoft Dynamics GP immediately and don’t want to wait for Automatic Logout to activate. The sample project in this article makes this possible.

#GPPT Controlling System Dialogs using Modal Dialog Focus Triggers

Previously, we have discussed controlling the Report Destination Dialogs and even External Dialogs using GP Power Tools but have not published any examples of controlling the standard System Dialogs shown when the warning, error, ask() or debug commands are used in Dexterity.

This example shows how GP Power Tools adds this functionality not normally available for use with Dexterity. Visual Basic for Applications and Visual Studio Tools both have the ability to trigger before and after Modal Dialogs, but Dexterity does not. GP Power Tools adds the functionality with its Modal Dialog Focus Triggers.

#GPPT Making the Multicurrency Access Setup window usable

During the Dexterity Fundaments Bootcamp training, which was run in the week prior to the Community Summit 2023 conference, one of the attendees came up with an issue using the Multicurrency Access Setup window in Microsoft Dynamics GP.

Their problem is that the list of companies shown on the right-hand scrolling windows are unsorted and the customer has over 300 companies. This makes using this window extremely frustrating and slow. They already owned GP Power Tools and wanted to use it for a fix.

#GPPT Speeding up Custom Report Writer Functions

A few years ago I published an article showing you can use a GP Power Tools custom RW Function to execute a SQL query and return data to a report. This article used some techniques which were valid at the time and while they still work, there are better and faster methods available in the later GP Power Tools builds.

Here is the link to the original article:

• #GPPT Adding data from any SQL table to SOP Documents

#GPPT Adding a QR Code to a GP Report Writer Report

I have been approached a couple of times with the request to place a QR Code (Quick-Response Code) onto a Microsoft Dynamics GP Report Writer report.

My initial response was that it was not possible as there is no way to include a dynamic image in a report. Only static images (such as logos) can be stored in the dictionary and added to reports.

But then I found online a couple of vendors selling QR Code True Type fonts….

#GPPT Best Practices for Developing with GP Power Tools

We are seeing more and more sites realizing the potential of using GP Power Tools – Developer Tools module as their platform for custom development for customizations, tweaking and fixing behavior of code within Microsoft Dynamics GP.

Many customers are using GP Power Tools (GPPT) to replace their unsupported Visual Basic for Applications (VBA) customizations, which is great as GPPT is the best solution for replacing VBA, Dexterity and Visual Studio Tools addins. It offers many benefits over other development tools.

#GPPT Controlling Any Dialog. Automatic Email Login

This week I was asked if GP Power Tools could automatically handle the login to email dialogs. Initially, I was thinking that this would not be possible as the login dialogs for both the Exchange Web Service and Multi Factor Authentication modes are not Dexterity based.

Then I decided to experiment with the .Net SendKeys Class using a .Net Execute script in GP Power Tools to see if the dialogs could be controlled by using code to insert keystrokes into the keyboard buffer.

#MySummitNA Winthrop Development Consultants at Community Summit Charlotte 2023

In just over three weeks my wife, Jennifer, and I will be flying from Perth via Sydney and Dallas/Fort Worth to Charlotte, North Carolina, USA for two weeks at the Community Summit 2023 conference.

During the first week (Monday 9^th to Friday 13^th October 2023), I will be running Dexterity Fundamentals training at the JW Marriott hotel. Then on Sunday 15^th October, I will be running Academy training for GP Power Tools.

Once the conference starts, please come see us at Expo Booth 718. Read on for more information on the two training classes and seven sessions I am presenting.

#GPPT Fixing the 80 character limitation for the rw_CreateSOPTrackingNumberString report writer function

Yesterday, I had a quick chat with one of the legends of the Microsoft Dynamics GP community as they were preparing a session for the upcoming Community Summit 2023 in Charlotte, NC, USA and hit a technical issue which is actually a limitation in Dexterity (the development tool behind Microsoft Dynamics GP).

Read on to find out who is returning to Summit this year and how GP Power Tools solved their problem with the rw_CreateSOPTrackingNumberString() report writer function.

#GPPT #VSIT Using a ListView to display data with a Custom Form

As mentioned in my recent article, it is possible to add a ListView to a window using Modifier along with a hack. So today we are going to show how to use a ListView to display multiple records of data.

This is a practical example which works with Sales Transaction Entry (SOP_Entry) and shows the stock levels at each inventory site that has stock for the selected item on the window.

#GPPT Using GP Power Tools to fix GP Power Tools

With the release of the ISV Drop of Microsoft Dynamics GP v18.6 yesterday. I went through the process of creating Pre-Release Beta builds of the Winthrop Development Consultants products.

One of the issues I came across with the update of GP Power Tools was that the parameters of a form procedure in Dynamics GP had changed and my code could no longer compile as I was receiving a “Wrong number of arguments to ‘MSGraphEmailSendEmail’.” error.

Here is how I used GP Power Tools to fix the code in GP Power Tools.

#GPPT Implementing Custom Forms using GP Power Tools

With the release of GP Power Tools Build 30 combined with the release of Visual Studio Integration Toolkit Build 18 and its Custom Forms Module, GP Power Tools gains the ability to create new windows.

GP Power Tools – Developer Tools module is extremely powerful with its triggering and scripting capabilities using the Dexterity sanScript, SQL Server Transact-SQL, C# and VB.Net languages and over 100 helper functions, but has always lacked the ability to create new windows.

Until now …

#VSIT Custom Forms Module added to Visual Studio Integration Toolkit Build 18

The release of Build 18 of Visual Studio Integration Toolkit fulfills a long-term plan to add advanced modules to the product that extend its functionality beyond the original menu navigation that was offered by its predecessor, Menus for Visual Studio Tools for Microsoft Dynamics GP.

The last big jump in functionality happened with Build 15 when support for Area Pages was added to the Menus module, and over 260 Helper Functions exposing “Dexterity only” functionality to Visual Studio Tools developers was added to the Helpers module.

Build 18 adds an advanced Custom Forms module which allows Visual Studio Tools developers to create their own Dexterity custom windows. These custom forms have the advantage over WinForms as they will work on the Web Client and all other Microsoft Dynamics GP features.

#GPPT Fixing ServiceUpdateVendor Web Service for Microsoft Dynamics GP 18.5

I was approached recently about an issue that a customer was having with the ServiceUpdateVendor Service Procedure being called as a Service Based Architecture (SBA) web service.

The web service call had worked perfectly on the system before upgrading to Microsoft Dynamics GP 18.5. Once they had upgraded, it was failing with an error.

Here is how GP Power Tools fixed the issue.

#MySummitNA Training at Community Summit Charlotte 2023

Community Summit 2023 in Charlotte, North Carolina, USA is fast approaching. David Musgrave from Winthrop Development Consultants will be running two extremely valuable training courses and now it is time to register.

The conference will be held on the 15^th to 20^th October 2023. There will be pre-conference training in the week before, from 9^th to 13^th October 2023, as well as Academy days on the first two days of the conference itself.