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.
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.
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.
Last week, AccountingWare, the people behind the ActivReporter reporting tool for GP, released the updated 2024 version of their report on the future of Dynamics GP. You might remember that I asked for my readers to complete the two surveys on the future of Microsoft Dynamics GP, well this is the resulting report from the second survey.
This report (based on 149 respondents) again confirms anecdotal evidence that most of the Microsoft Dynamics GP customer base is happy staying with Dynamics GP for the foreseeable future, and also that most of the few who are moving off GP are moving away from Microsoft’s ERP solutions.
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.
There have been a number of articles on the future of Microsoft Dynamics GP with the change to the Modern Lifecycle in 2021 and the announcement about ceasing new customer site sales in April 2023.
[Edit] GPUG All-Star, SQL Guru and good friend Kerry Hataley has consolidated all the information from Microsoft into a single article and also produced a Dynamics GP Consolidated Timeline based on the official Microsoft Roadmap, product lifecycle information and the April 2023 announcement.
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.
At Community Summit 2023 in Charlotte, NC, USA we had a session on the future of Dynamics GP immediately after the GP General Session. The Dynamics GP Future’s So Bright, I Gotta Wear Shades session interviewed customers, partners and ISVs to discuss their commitment to the Microsoft Dynamics GP platform.
During the session there was a quick live poll, as well as the link for a more detailed survey was shared.
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.
In the forums recently, I have noticed an increase in threads reporting issues with sending emails using MFA (Multi Factor Authentication) from Microsoft Dynamics GP.
It is possible that you are facing a permissions issue with the App Registration in Azure AD which needs to be resolved before emailing will work smoothly again.
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.
In April 2023, Microsoft announced that Microsoft Dynamics GP will not be available for sale to new customers after April 2026. While the announcement has very little effect on the existing customers, there have been lots of discussions on the future of Microsoft Dynamics GP and its client base.
Microsoft has indicated that they will be supporting the product to 2028 & Beyond. That “& Beyond” clause will be very dependent on what the existing customers using GP do. If the existing customer base continues to use GP and pay their annual enhancement fees, Microsoft’s management will be able to justify continued support beyond 2028 due to the income stream.
Continue reading
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….
Microsoft Dynamics GP customers, please take this quick, anonymous Current State of Dynamics GP survey now.
For the last 25 years or so, questions have been asked about the future of Microsoft Dynamics GP. I partially based my decision to leave Winthrop Dexterity Consultants in 2000 to become a Microsoft employee because of the “imminent demise” of Dynamics GP.
Fourteen years later, when I left Microsoft and started Winthrop Development Consultants, Microsoft Dynamics GP was still well and truly alive and going strong.
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.
Winthrop Development Consultants Blog 