GP Power Tools has a powerful feature called Company Login Filter. This feature was created to allow the selection of companies to be controlled based on the application configuration used to launch Microsoft Dynamics GP.
It has a number of other features such as controlling the order of the companies listed and optionally showing the database name for the company, but if configured incorrectly it does have the ability to block access to the application by removing access to all the companies.
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.
Today, we are announcing the release of GP Power Tools Build 30.3. Over the last couple of months, a few issues have been discovered, which have now been fixed. We have also enhanced the functionality of a number of features in the product.
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 and fixed in August 2022.
I am excited to announce that as well as the Dexterity Training (during the week before the conference), there will also be GP Power Tools training offered at Academy at Summit in the days before Community Summit in San Antonio, Texas, USA.
The training will be presented as a single full day course on Sunday 13th October 2024, running from 8:00am to 5:00pm with lunch included.
We always have lots of new functionality and enhancements to cover with the release the latest builds of 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.
Today 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.
A 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.
GP 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.
We 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.
This 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.
This 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.
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.
When 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.
This 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
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.
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.
After 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.
The 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:
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:
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….
Winthrop Development Consultants Blog 