Click here to
Subscribe to
our Newsletter
Development related Posts
Over time the amount of data stored by your Microsoft Dynamics GP system can get quite large. Without buying new hardware, there is a simple way to make your system faster and decrease the space used to store your databases.
This is where a couple of the features of the Database Module of GP Power Tools come in to help. This is article 1 of 3 in the series.
When GP Power Tools Build 32 was released, it added powerful Custom Table functionality which allows for a developer to create a custom table definition and have that table created in each company automatically. The table can then be used in a similar fashion to a native Dexterity table using a suite of Custom Table Buffer Helper Functions.
This article updates the original article (below), which explained how to create a Custom Forms Module demonstration project, to use Custom Tables instead of SQL Tables for a much faster and simpler implementation.
Welcome to the eleventh article as an update to 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 show how to use Custom Tables (added in Build 32) to store data rather than the DUOS table. In the previous articles we included the Customization Maintenance packages and showed how to use manual SQL tables.
Welcome to the tenth article as an update to 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 show how to use manual SQL tables to store data rather than the DUOS table. In the previous article we included the Customization Maintenance packages. In the following article we will show how to use GPPT Custom Tables (even better than manual SQL tables).
Welcome to the ninth article as an update to 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 provide updates to the project adding the modified window and report to the project. In the following articles we will show how to use manual SQL tables and then GPPT Custom Tables (even better than manual SQL tables).
GP Power Tools Build 32 added Custom Tables as a new feature to the Developer Tools module. Custom Tables can automatically create and maintenance SQL tables in company (or system) databases as defined by the definition in the Custom Tables Setup window.
This is an updated version of the #GPPT Adding Virtual Fields to Item Maintenance project which uses a Custom Table to store the data rather than the DUOS. Easy access to the Custom Tables is provided by a series of Custom Table Buffer Helper Functions which replicate how Dexterity table buffers work.
This is a repost of an original article by Tim Gordon October 2017 that I found very useful but is no longer available online. Originally published as
Thanks to the Internet Archive Wayback Machine I was able to recover the last version of the article from June 2021 and am posting it here as a reference.
This is a repost of an original article by Jason Carr from August 2009 that I found very useful but is no longer available online. Originally published as
Thanks to the Internet Archive Wayback Machine I was able to recover the last version of the article from November 2020 and am posting it here as a reference.
Are you looking to unlock the full potential of your Dynamics GP system?
Hi, I’m David Musgrave, Managing Director of Winthrop Development Consultants from Perth, Western Australia. I’m thrilled to invite you to the one-day workshop: “Optimizing your system with GP Power Tools” at Summit Academy, on Sunday 19th October.
Are you ready to take your Dynamics GP skills to the next level?
Hi, I’m David Musgrave, Managing Director at Winthrop Development Consultants from Perth, Western Australia. I’m excited to invite you to the upcoming GP Dexterity Bootcamp, happening in Orlando the week before Community Summit—from Monday 13th to Friday 17th October.