This 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.
This 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.
If you need to customize Microsoft Dynamics GP or maintain existing customizations, David Musgrave from Winthrop Development Consultants will be running two extremely valuable development training courses before Community Summit 2025 and now it is time to register.
The conference will be held on the 19th to 23rd October 2025. There will be pre-conference GP Development training in the week before the conference as well as Academy days before and after the conference itself.
HURRY: LAST DAYS TO REGISTER
This 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.
This 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.
Thanks 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!
Do you want to customize Microsoft Dynamics GP or have customizations that you want to support into the future? Now is your chance for both customers and partners to get trained in Dexterity, the development environment that Dynamics GP is built on.
Understanding Dexterity will help any developer working with Dynamics GP regardless of the development environment they end up using. This knowledge is vital for developers using Dexterity, Visual Studio Tools (C# or VB.Net), “End of Life” Visual Basic for Applications (VBA), or using the GP Power Tools – Developer Tools module.
HURRY: LAST DAYS TO REGISTER
I will be running the 5-day Dexterity Fundamentals for Dynamics GP bootcamp training class in the week before the Community Summit conference in Orlando, Florida, USA in October. Please register for the training now and plan to be in Orlando for the week before the conference.
I 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 ….
Scheduling 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.
A 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.
Using 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.
This example adds filtering on an amount and/or a document number to the Apply Sales Document window when the Find window is used. as well as sorting the documents by date. The additional functionality can make it much quicker to find the correct document for a payment to be applied to, by its amount or by any part of its document number.
This customization also demonstrates some very useful techniques including:
GP Power Tools Build 31 added Virtual Fields as a feature to the Developer Tools module. Virtual Fields allow additional fields to be added to windows without needing Modified or Alternate windows.
Virtual Fields are implemented using a series of Helper Functions which allow windows to be expanded, Virtual Fields to be added and then triggers and scripts applied to use the new fields.
To coincide with the Dexterity Fundamentals training bootcamp that is starting today in San Antonio, Texas, USA, here is a cheat list for creating window layouts that match the Microsoft Dynamics GP user interface standards.
The documentation of the user interface standards uses mathematical formulas to tell you where fields should be located. It is much simpler to use the tips in this article with the grid and offsets instead of the formulas. This article is relevant for working with Dexterity or Modifier.
In just two weeks’ time my wife, Jennifer, and I will be flying from Perth via Sydney and Dallas/Fort Worth to San Antonio, Texas, USA for two weeks at the Community Summit 2024 conference.
During the first week (Monday 7th to Friday 11th October 2024), I will be running Dexterity Fundamentals training at the San Antonio Marriott Riverwalk hotel. Then on Sunday 13th October, I will be running Academy training for GP Power Tools.
Once the conference starts, please come see us at Expo Booth 1425. Read on for more information on the two training classes and seven sessions I am presenting.
Community Summit 2024 in San Antonio, Texas, USA is fast approaching. David Musgrave from Winthrop Development Consultants will be running two extremely valuable training courses and now it is time to register.
The conference will be held on the 13th to 17th October 2024. There will be pre-conference training in the week before, from 7th to 11th October 2024, as well as Academy days before and after the conference itself.
GP Power Tools has the ability to recreate user SQL logins after a server migration using the Database Validation window, or reset multiple user logins using the SQL Login Maintenance window. Both of these methods can use fixed or randomly generated passwords and have the ability to send emails to users with their new password. Also, changing the user’s password from the User Setup window can send an email.
The wording and formatting of these Password Reset emails can be defined in GP Power Tools by your system administrator. You can even use HTML to format the emails as described in the article below:
To be able to send emails to your users, you need to ensure that GP Power Tools knows the email addresses of the users. They are entered into the User Setup Additional Information window which can be opened from the User Setup window (if it is not set to automatically open). The sample code in this project shows how you can take the data from an Excel spreadsheet with the User ID and Emails of the users and import it from the clipboard directly into GP Power Tools.
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.
I will once again be running the 5-day Dexterity Fundamentals for Dynamics GP bootcamp training class in the week before the Community Summit conference in San Antonio, Texas, USA in October. Please register for the training now and plan to be in San Antonio for the week before the conference.
Dexterity is the development environment that Microsoft Dynamics GP is built on and the best tool to use for any customization to the user interface of the product. Knowledge of Dexterity is vital for anyone customizing Dynamics GP even when using other development tools such as GP Power Tools – Developer Tools module, Visual Studio Tools (C# or VB .Net) or “End of Life” VBA (Visual Basic for Application).
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.