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

Read more →

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:

Read more →

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….

Read more →

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

Read more →

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.

Read more →

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.

Read more →

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

Read more →

David Meego - Click for blog homepageSome more great news after the release of new builds of our products.

This morning (Perth Time) I had an email from Terry Heley from Microsoft with a link to a pre-release (ISV Drop) of the upcoming Microsoft Dynamics GP version 18.6 (October 2023) release. This download is provided to the ISV community to help them prepare for the final code when it is released.

Read more →

David Meego - Click for blog homepageOne of the big new features for Build 30 of GP Power Tools is the Note Fix Utility.

In a perfect world the need for a utility to fix issues with Notes would not exist, but this is not a perfect world and some of the design decisions made many years ago when Great Plains Dynamics 1.0 was created in the late 1980’s were a little flawed.

Usually, the first indication to a user that there is a problem with the record notes is when they open a note, and its contents don’t seem related to the record they are currently editing. This is a sign that there are cross linked notes caused by the same Note Index being assigned to more than one record in the company. These duplicate Note Indexes are a symptom of more complex issues. It is best to actively look for and fix the issues before they result in cross linked notes.

Read more →

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

Read more →