GPPT

Leave a comment Posted on by WinthropDC GP Power Tools, Products

#GPPT GP Power Tools Build 30.2 hotfix released

David Meego - Click for blog homepageToday we are pleased to announce the release of GP Power Tools Build 30.2. It has been about six months since GP Power Tools Build 30.1 was released and we have been working on consolidating all the features and functionality of that build as well as fixing some minor bugs.

We have also been encouraging our customers to get updated onto the latest builds of our products for their versions of Microsoft Dynamics GP. We always want our customers on the latest code to get the best experience with all the new features and fixes, but we have also discontinued old builds primarily because of the Security Vulnerability discovered in August 2022.

Continue reading →

Leave a comment Posted on by WinthropDC Batch Posting Service Toolkit, Dynamics, GP, GP Power Tools, Microsoft, Products, Visual Studio Integration Toolkit

Installation Failing with ANSI_WARNINGS and CONCAT_NULL_YIELDS_NULL Errors

David Meego - Click for blog homepageA couple of weeks ago, we had an unusual support case: upgrading two of our products, Visual Studio Integration Toolkit and GP Power Tools, was failing with a SQL Server error I had never seen before.

The errors only occurred on the customer’s live system, but the install worked fine on their development system. Eventually the cause for the issue was identified.

Today, my good friend Beat Bucher, had the same error and I was able to tell him the cause straight away. Read on for a full explanation.

Continue reading →

Leave a comment Posted on by WinthropDC Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT You do not have permission to run FN_TRACE_GETINFO

David Meego - Click for blog homepageGP Power Tools has the ability to capture SQL Profile Traces as one of the five different types of logs it can generate from Microsoft Dynamics GP.

To achieve this, GP Power Tools needs to change some permissions on the SQL Server so that it can both generate the Trace programmatically and also copy the resulting files to the shared Logging Folder.

Continue reading →

Leave a comment Posted on by WinthropDC Batch Posting Service Toolkit, Dynamics, GP, GP Power Tools, Microsoft, Products, Visual Studio Integration Toolkit

Registration Expired or Failed Dialog shown when launching Microsoft Dynamics GP

David Meego - Click for blog homepageWe are currently seeing an increase in customer sites reporting the Registration Expired or Failed dialog when launching Microsoft Dynamics GP.

This dialog is to notify users that a Winthrop Development Consultants product is no longer registered and action needs to be taken by the system administrator to fix the subscription and restore the product’s functionality.

Continue reading →

4 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Item Cards Version 3

David Meego - Click for blog homepageThis is a further update to the previous version of the change tracking project for Item Cards:

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

Continue reading →

6 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Customer and Vendor Cards Version 4

David Meego - Click for blog homepageThis is another update to the previous versions of the change tracking projects for Customer and Vendor cards:

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

Continue reading →

6 Comments Posted on by WinthropDC Development, Dexterity, GP Power Tools, Products

#GPPT Remotely requesting immediate Automatic Logout

David Meego - Click for blog homepageGP 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.

Continue reading →

Leave a comment Posted on by WinthropDC Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT GP Power Tools has detected mismatched product dictionaries

David Meego - Click for blog homepageWhen GP Power Tools Build 28 was released, it added a new Product Version Validation feature. One function of Product Version Validation is to warn when it detects Dexterity Product Dictionary version mismatches.

A dialog will be displayed after logging into Microsoft Dynamics GP explaining which product dictionary versions are mismatched for the current workstation. Once dismissed the application will continue as normal. However, mismatched product dictionaries are a security and data damage risk, and the issue should be resolved as soon as possible.

Continue reading →

5 Comments Posted on by WinthropDC Batch Posting Service Toolkit, GP Power Tools, Products, Visual Studio Integration Toolkit

Uninstalling Winthrop Products and Removing previous versions from Programs and Features

David Meego - Click for blog homepageThis article covers how to uninstall Winthrop Products and also how to remove previous versions showing in Programs and Features in the Control Panel.

Winthrop Products use a two-step uninstall process and will not uninstall from the Programs and Features applet in the Control Panel until they have first been uninstalled from the Microsoft Dynamics GP application. This allows the products to clean up all the settings, tables and other SQL objects from the SQL Server as well as removing themselves from the application installation before the files are removed by uninstalling from the control panel.
Continue reading →

2 Comments Posted on by WinthropDC Development, Dexterity, GP Power Tools, Products

#GPPT Controlling System Dialogs using Modal Dialog Focus Triggers

David Meego - Click for blog homepagePreviously, 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.

Continue reading →

Leave a comment Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Making the Multicurrency Access Setup window usable

David Meego - Click for blog homepageDuring 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.

Continue reading →

Leave a comment Posted on by WinthropDC Conference, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPUC23 Don’t miss tomorrow’s free GP Power Tools Webinar

David Meego - Click for blog homepageAfter the successful Great Plains User Conference (GPUC) event held in Fargo, ND, USA and online recently by Implementation Specialists, they are also hosting webinars for the sponsors of the event.

Winthrop Development Consultants has their session coming up tomorrow. See why GP Power Tools is the favorite addon product for all GP Customers globally. It’s free, so register now.

[Edit] If you did miss the live session, don’t worry the link for the recording is provided below.

Continue reading →

Leave a comment Posted on by WinthropDC Batch Posting Service Toolkit, Conference, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training, Visual Studio Integration Toolkit

#MSDynGP Microsoft Dynamics GP 18.6 – October 2023 has released

David Meego - Click for blog homepageThe latest and greatest version of Microsoft Dynamics GP has been released, and it contains a number of new features and bug fixes.

Winthrop Development Consultants has already updated its products for this Microsoft Dynamics GP 18.6 – October 2023 release. They are now built against the final build and so are no longer beta builds.

Check out the previous article for more information:

Continue reading →

4 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Report Writer, SQL Server

#GPPT Speeding up Custom Report Writer Functions

David Meego - Click for blog homepageA 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:

Continue reading →

Leave a comment Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Report Writer

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

David Meego - Click for blog homepageI 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….

Continue reading →

1 Comment Posted on by WinthropDC Development, Dexterity, GP Power Tools, Products, Visual Studio Integration Toolkit

#GPPT Best Practices for Developing with GP Power Tools

David Meego - Click for blog homepageWe 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.

Continue reading →

2 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Controlling Any Dialog. Automatic Email Login

David Meego - Click for blog homepageThis 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.

Continue reading →

5 Comments Posted on by WinthropDC Batch Posting Service Toolkit, GP Power Tools, Products, Visual Studio Integration Toolkit

Installer Error: Microsoft Dynamics GP Process Monitor (DPM.exe)

David Meego - Click for blog homepageToday, we have an interesting support case where the installer for a Winthrop Development Consultants product failed to complete with the following error message:

  • A version of Microsoft Dynamics GP Process Monitor (DPM.exe) is currently running, please exit the application and click Retry or click Cancel to exit the installer.

Continue reading →

4 Comments Posted on by WinthropDC Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training, Visual Studio Integration Toolkit

#MySummitNA Winthrop Development Consultants at Community Summit Charlotte 2023

David Meego - Click for blog homepageIn 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 9th to Friday 13th October 2023), I will be running Dexterity Fundamentals training at the JW Marriott hotel. Then on Sunday 15th 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.

Continue reading →

Leave a comment Posted on by WinthropDC Band, Development, Dexterity, Dynamics, GP Power Tools, Microsoft, Products, Report Writer

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

David Meego - Click for blog homepageYesterday, 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.

Continue reading →