Click here to
Subscribe to
our Newsletter
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 3 of 3 in the series.
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 2 of 3 in the series.
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.
I am finally getting back to work after travelling and presenting at Community Summit 2025 in Orlando and visiting family in the UK. Still got lots of tasks to catch up on but I wanted to write about the Knights of GP.
The Knights of GP is planned to be a community based co-op of customers, consultants, Independent Software Developers (ISVs) and partners who will work together after Microsoft stops supporting Microsoft Dynamics GP to allow the product to remain supported by the community who use and love it. Join us for the tomorrow’s Fireside Chat…
This is an article I wrote for the recently released Fido magazine. The magazine was published in time for Community Summit 2025 in Orlando by Fidesic, who offer Payables Automation solutions for Microsoft Dynamics GP and Microsoft Dynamics 365 Business Central. Go visit them at booth 1545 for the full magazine.
Thanks to Carl Robinette from Fidesic who reached out and offered the opportunity to write an article for the magazine, and to my wife, Jennifer, who helped me with multiple rewrites. 🙂
Today, I am off on my way to Orlando, Florida, USA for the Community Summit 2025 conference. With a 12 hour time difference between Perth and Orlando and an almost equal distance from the equator, I will truly be going halfway around the globe with my Friday lasting 36 hours.
I will be presenting a 5 day Dexterity class and a 1 day GP Power Tools class and then being involved with and presenting at least seven sessions. I will also be taking advantage of a number of “Advanced Networking Opportunities” including being a sponsor of the PowerGP Online party on Wednesday night.
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.
A 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.
This 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.
This 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.