Click here to
Subscribe to
our Newsletter
Good News for the Microsoft Dynamics GP Community.
This 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.7 (October 2024) release. This download is provided to the ISV community to help them prepare for the final code when it is released.
GP Power Tools Build 31 is releasing soon and will be adding amazing new functionality, including a “No Code / Low Code” customization tool for Microsoft Dynamics GP, a method of adding fields directly to windows without needing alternate or modified windows, and a Database Space Recovery tool.
Please read on and register for the webinar hosted by Njevity on Tuesday 20th August 9:00am-10:30am (US Central Time).
If you missed the webinar, the video is included at the bottom of the article.
As Community Summit 2024 in San Antonio, Texas, USA on 13-17th October 2024 approaches, Dynamic Communities have released a survey to get an insight into the Microsoft Dynamics GP Community.
The survey will close on 30th August 2024, so spread the word and complete the survey before it closes.
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.
GP Power Tools has a powerful feature called Company Login Filter. This feature was created to allow the selection of companies to be controlled based on the application configuration used to launch Microsoft Dynamics GP.
It has a number of other features such as controlling the order of the companies listed and optionally showing the database name for the company, but if configured incorrectly it does have the ability to block access to the application by removing access to all the companies.
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.
A couple of weeks ago, we had an unusual support case: upgrading two of our products, Visual Studio Integration Toolkit and GP Power Tools, was failing with a SQL Server error I had never seen before.
The errors only occurred on the customer’s live system, but the install worked fine on their development system. Eventually the cause for the issue was identified.
Today, my good friend Beat Bucher, had the same error and I was able to tell him the cause straight away. Read on for a full explanation.
Last week, AccountingWare, the people behind the ActivReporter reporting tool for GP, released the updated 2024 version of their report on the future of Dynamics GP. You might remember that I asked for my readers to complete the two surveys on the future of Microsoft Dynamics GP, well this is the resulting report from the second survey.
This report (based on 149 respondents) again confirms anecdotal evidence that most of the Microsoft Dynamics GP customer base is happy staying with Dynamics GP for the foreseeable future, and also that most of the few who are moving off GP are moving away from Microsoft’s ERP solutions.