#GPPT Using .Net Math Functions from Microsoft Dynamics GP

David Meego - Click for blog homepageA recent customization project I was working on using GP Power Tools required the calculation of a square root as part of some number crunching needed to work out material quantities on a Sales Order Processing transaction.

While Dexterity (the language behind Microsoft Dynamics GP) is great at accounting style mathematics (as per a standard calculator), it does not have advanced functions for powers, logs, and trigonometry (as per a scientific calculator). This means that there is no “native” method to calculate a square root.

However, Dexterity (from v14.0 onwards) has a .Net Interop which allows you to import and call .Net libraries directly from your Dexterity scripts. This example shows how to call the System.Math library as well as other advanced techniques, such as Custom Forms and Virtual Fields.

Continue reading

#GPPT Making Tax Registration Number on Purchasing Vendor Detail Entry Required

David Meego - Click for blog homepageThis is the sixth article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Tax Registration Number field on the Purchase Order Entry – Purchasing Vendor Detail Entry sub window (separate form) required.

Continue reading

#GPPT Making Salesperson ID on Sales Customer Detail Entry Required

David Meego - Click for blog homepageThis is the fifth article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Salesperson ID field on the Sales Transaction Entry – Sales Customer Detail Entry sub window (separate form) required.

Continue reading

#GPPT Making Substitute Item 1 on Item Maintenance Options Required

David Meego - Click for blog homepageThis is the fourth article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Substitute Item 1 field on the Item Maintenance Options sub window (same form) required.

Continue reading

#GPPT Making Tax Registration Number on Vendor Maintenance Options Required

David Meego - Click for blog homepageThis is the third article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Tax Registration Number field on the Vendor Maintenance Options sub window (same form) required.

Continue reading

#GPPT Making Tax Registration Number on Customer Maintenance Options Required

David Meego - Click for blog homepageThis is the second article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Tax Registration Number field on the Customer Maintenance Options sub window (same form) required.

Continue reading

#MSDynGP Microsoft Dynamics GP v18.8 ISV Pre-release installers now available

David Meego - Click for blog homepageGood News for the Microsoft Dynamics GP Community.

Friday 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.8 (October 2025) release. This download is provided to the ISV community to help them prepare for the final code when it is released.

Continue reading

#GPPT Making Window Fields Required and Why It Does Not Always Work

David Meego - Click for blog homepageThis is the first post in a series of six articles discussing making additional Window Fields required and why the standard technique using Modifier does not always work.

For a field to behave as required, there are a number of different factors that must all fall into place. This article will explain the theory and what can go wrong. Links to examples with sample code will be published over the next week.

Continue reading

#GPPT Tracking changes to Item Cards Version 5

David Meego - Click for blog homepageThis is yet another update to the previous version of the change tracking project for Item cards:

Based on the version 4 project, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Continue reading

#GPPT Tracking changes to Customer and Vendor Cards Version 6

David Meego - Click for blog homepageThis is yet another update to the previous versions of the change tracking projects for Customer and Vendor cards:

Based on the version 5 projects, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Continue reading

#MSDynGP Checking which Products have been used in Dynamics GP

David Meego - Click for blog homepageThis article is designed to help you perform a system audit on your Microsoft Dynamics GP system and is used as part of my Microsoft Dynamics GP Systems Audit session in the first week of the Dynamics GP Strategic Planning Digital Summit being held each Wednesday for the next 5 weeks.

Identifying the installed products in the system is fairly easy as you can look at the Dynamics.set launch file to see all the Dexterity product dictionaries loaded.

However, having a product loaded in a system does not necessarily mean that it has been used.

Continue reading

#MSDynGP Register Today for the Dynamics GP Strategic Planning Digital Summit

David Meego - Click for blog homepageAttention all Microsoft Dynamics GP Customers.

With the End of Support for Dynamics GP by 2031, existing GP customers need to plan what they want to do moving into the future. Should they stay with Dynamics GP? Should they implement a new Microsoft ERP? Should they implement an ERP from another company?

Dynamics Communities have joined with community members to present a free five week Dynamics GP Strategic Planning Digital Summit.

Continue reading

#GPPT Tracking changes to Item Cards Version 4

David Meego - Click for blog homepageThis is another update to the previous version of the change tracking project for Item cards:

Based on the version 3 project, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.

Continue reading

#GPPT Tracking changes to Customer and Vendor Cards Version 5

David Meego - Click for blog homepageThis is another update to the previous versions of the change tracking projects for Customer and Vendor cards:

Based on the version 4 projects, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.

Continue reading

#MySummitNA Community Summit 2025 Presenter Spotlights Podcast with Noah Moseley

David Meego - Click for blog homepageThanks to Noah Moseley for inviting me to be part of his Presenter Spotlights Podcast series.

We had a fun time discussing many topics including Microsoft Dynamics GP development and customization, the End of Support announcement, the training and sessions I will be presenting at Community Summit 2025, and finally Australian chocolates, Tim Tams and Vegemite!

Continue reading

#GPPT GP Demo Day by The ISV Society (28-May-2025)

David Meego - Click for blog homepageWinthrop Development Consultants is taking part in the upcoming GP Demo Day by The ISV Society on 28th May 2025 at 1:00pm (US Eastern Time).

Join us and see how the new GP Power Tools Form Control module helps you adapt Microsoft Dynamics GP to your exact business needs—with little to no code.

Continue reading

#BPST #GPPT Automatically Posting Batches with Batch Posting Service Toolkit and GP Power Tools

David Meego - Click for blog homepageI have been meaning to write this article for quite a while. The Batch Posting Service Toolkit (BPST) is a product created by Winthrop Development Consultants to provide a variety of methods for posting, maintaining, transferring batches, etc.

The API’s (Application Programming Interface) can be called externally as a Service Based Architecture (SBA) Web Service (for GP 2015 or later), or from inside the Microsoft Dynamics GP application using Dexterity, Visual Studio Tools (via C# or VB.Net) or via GP Power Tools.

The Batch Posting Service Toolkit is exactly that, a toolkit designed to be called by a developer and so it does not have an interface (except for testing the API). However, you can use the Scheduling functionality in GP Power Tools to post batches on a scheduled basis, read on for more details ….

Continue reading

#GPPT Scheduling Tasks like Inventory Reconcile

David Meego - Click for blog homepageScheduling or automating tasks in Microsoft Dynamics GP is a common request, so this example demonstrates a method that can be used to run any process on a scheduled or automated basis using GP Power Tools.

The specific example we will be using is running an Inventory Item Reconcile on items that have been flagged as needing reconciliation. This code was developed in conjunction with Arthur Achilleos, who has agreed for it to be published.

Continue reading

#GPPT Ensuring GL Accounts are entered on Purchase Orders

David Meego - Click for blog homepageA recent GP Power Tools customization project for Microsoft Dynamics GP which I assisted a customer to create, ensures that a GL Account Number is entered on each line of a Purchase Order Transaction.

The customer for which this project created for has allowed it to be published on the blog to benefit anyone else who would like similar functionality.

Continue reading

#GPPT Hiding Windows During Automations

David Meego - Click for blog homepageUsing the GP Power Tools – Developer Tools module for customization is a great method of automating processes in Microsoft Dynamics GP as well as customizing behavior to meet the requirements of your business.

Many customers are also using GP Power Tools to replace Visual Basic for Applications now that it is “End of Life” and unsupported.

I was recently asked how to hide a window opened and closed as part of an automation using GP Power Tools. This article explains the techniques you can use to open a window as hidden.

Continue reading