#GPPT Modifying Reports based on Temporary Tables

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

Continue reading

#VBA Solving VBA (Visual Basic for Applications) Compatibility Issues

David Meego - Click for blog homepageIn recent times many Microsoft Dynamics GP sites have been having issues with VBA (Visual Basic for Applications). Especially with Microsoft Office Updates breaking functionality and incompatibilities with later Windows Server releases.

There have been compatibility issues reported with sending emails via Outlook and more recently issues with VBA on Windows Server 2019.

Continue reading

#GPPT Reporting for Minnesota’s Wage Theft Law

David Meego - Click for blog homepageThis article is comes about thanks to my friend, Melissa Brown, who approached me for a solution to a reporting requirement she had for a customer due to new legislation brought in by the US state of Minnesota.

The requirement was not possible to solve with the Dynamics Report Writer alone as it involved an array in a table which prevented a static relationship from working to retrieve the data needed.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Video Demonstration

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

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Publishing the project

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

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Modifying the report

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

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Creating the RW function

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

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Using the data

David Meego - Click for blog homepageWelcome 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 http:// at the beginning of the URL field if it is not added by the user.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Saving the data

David Meego - Click for blog homepageWelcome to the third 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 use GP Power Tools to add the business logic to save the data from the newly added custom field on the Item Maintenance window.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Modifying the window

David Meego - Click for blog homepageWelcome to the second 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 use Modifier to add the custom field to the Item Maintenance window.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

David Meego - Click for blog homepageWelcome to a 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 example project will only need six scripts and no external development tools will be required.

The aim of this series is to work through each of the parts of the process and explain with step by step instructions how it works and why various settings are used. The final article also includes a step by step video.

It would be possible to just show the final result, but I want this series to serve as a guide for creating similar customizations in your own system. That said I will provide the final customization files at the end of the series.

Continue reading

#GPUGSummit Developers at GPUG Summit

David Meego - Click for blog homepageHey Developers… Are you attending the GPUG Summit 2017 conference in Nashville, Tennessee in October? If so, this article is to let you know about Microsoft Dynamics GP related Developer content at the conference.

I asked why there was not much content for developers at GPUG Summit and I was told that there are not many developers in attendance. I disagreed and requested a session for Developers, which Bob McAdam promptly organised … thanks Bob. 🙂

Continue reading

RW: Using the rw_TableLineString() and rw_TableLineCurrency() Report Writer functions

David Meego - Click for blog homepageWhen Microsoft Dynamics GP 9.0 was released, it included six new global functions specifically added to make life easier for ISVs (Independent Software Vendors).

These six placeholder functions were added so that Dexterity developers could trigger against them and use the functions to get their custom data on to reports without needing to create alternate reports.

Continue reading

What can Winthrop Development Consultants do for you?

David Meego - Click for blog homepageYou have probably heard that I was made redundant (laid off) from Microsoft in October 2014 and have since restarted and updated the consulting business that I had before my 13.5 years with Microsoft as Winthrop Development Consultants.

Now I hear you ask, “What can David Musgrave and Winthrop Development Consultants do for you?”.

Well, read on to understand what Winthrop Development Consultants’ business model and plans are….

Continue reading