Click here to
Subscribe to
our Newsletter
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….
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.
With the release of build 29 of GP Power Tools, a feature was added that will automatically close the Report Writer Screen Output window after a period of time.
As customers have been upgrading their systems to the latest GP Power Tools build they have been noticing that the Report Writer Screen Output closes by itself.
This article explains how to change the timeout setting and why this new feature is so important.
The recent Build 28.8 hotfix of GP Power Tools incorporated some Developer Tools module changes to enable so very cool customization options for updating reports based on temporary tables. The big feature enhancement is the ability to store a Table Reference as a Memory parameter.
References in Dexterity are like pointers to a particular resource, so the Table Reference allows access to the particular instance table buffer without needing to pass the table as a parameter to a script.
Welcome to the eighth and final article in the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.
The series should be read in order starting with the introduction article:
In this article we will put everything in the previous articles together in a video demonstration of the steps.
Welcome to the seventh article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.
The series should be read in order starting with the introduction article:
In this article we will adjust security and GP Power Tools settings to publish the customization to all users.
Welcome to the sixth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.
The series should be read in order starting with the introduction article:
In this article we will use Report Writer to modify the Detailed Item List report to add a calculated field which in turn calls the custom RW Function created in the previous article.
Welcome to the fifth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.
The series should be read in order starting with the introduction article:
In this article we will use GP Power Tools to create a custom Report Writer (RW) function which will allow our custom URL field to be easily added to reports in the Report Writer.
Welcome to the fourth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.
The series should be read in order starting with the introduction article:
In this article we will use GP Power Tools to add the business logic to make the URL field work. We will make the hidden button open the URL in a browser window and add https:// at the beginning of the URL field if it is not added by the user.