Over a year ago, October 2020 to be exact, I mentioned on a forum post that I have finally worked out how to cycle through a scrolling window using Dexterity code.
Being able to perform an action for each line in a scrolling window has been something that Microsoft Dynamics GP developers have been trying to do since VBA was added to version 4.0 of GP and Visual Studio Tools was added to version 9.0 of GP.
I promised I would blog about this technique … so read on for the details.
Over the last few days I have received a number of requests for clarification of the status of Winthrop Development Consultants’ products and whether they are at risk from the Java Log4J vulnerability that has been in the news recently.
The short answer is no.
For those who would like a bit more information read on…
Winthrop Development Consultants are proud to be one of the sponsors of the K2A Days & GPUC event running in Fargo, North Dakota, USA (the home of Microsoft Dynamics GP) this week.
The event is hosted by Implementation Specialists and for the first two days focusses on Key2Act (formerly Wennsoft) customers with the final three days covering everything Microsoft Dynamics GP.
Winthrop Development Consultants are proud to be one of the sponsors of the K2A Days & GPUC event running this week in Fargo, North Dakota (the home of Microsoft Dynamics GP) and virtually.
The event is hosted by Implementation Specialists and for the first two days focusses on Key2Act (formerly Wennsoft) customers with the final three days covering everything Microsoft Dynamics GP.
Community Summit Conference 2021, hosted by Dynamic Communities (DC) ran in Houston, Texas, USA last week from 12th to 15th October 2021.
I presented a session on Microsoft Dynamics GP development tools. Because I am still unable to leave Australia due to the pandemic border closures, the session was a pre-recorded video presentation.
This is my video presentation of the Top 5 Reasons to upgrade to Microsoft Dynamics GP 18.4 from the Microsoft Dynamics GP General Session at Community Summit 2021 conference in Houston, Texas, USA which was shown on Wednesday 13th October 2021.
A couple of Australian partner consultants have contacted me today and yesterday about an issue with the Microsoft Dynamics GP Version 18.4 release.
After installing with selecting the country of Australia, it will fail to launch GP application generating an “An error occurred while loading or initializing an addin” Error.
Continue reading
Community Summit Conference 2021, hosted by Dynamic Communities (DC), is happening right now in Houston, Texas, USA until from 12th to 15th October 2021.
I am presenting a session on Microsoft Dynamics GP development tools as the first session of the day on Friday. As I am still unable to leave Australia due to the pandemic border closures, the session has been pre-recorded and will be run as a video presentation.
However, I will be online in a Microsoft Teams Meeting for the duration of the session and would love for anyone attending the conference (and those just interested in GP Development) to join me and others in the community for a chat and Q & A session.
The latest version of Microsoft Dynamics GP was released yesterday and it contains many new features and bug fixes. Winthrop Development Consultants has already updated its products for this Microsoft Dynamics GP – October 2021 release. They are now built against the final build and so are no longer beta builds (except for GP Power Tools which has a new build 29 coming soon).
Check out the previous article for more information:
Today’s article comes about because I was asked if GP Power Tools could easily assign a Security Role to all users in all companies in a Microsoft Dynamics GP system.
GP Power Tools does have a copy feature in the Enhanced Security window which can copy all security settings from a selected user/company to all users in the same company or all companies for the same user, but it does not have the option to push a specific Security Role ID across the entire system.
No problem. We can just use the Developer Tools module to create this functionality in an hour or two.
As a follow on from yesterday’s article on how different languages can be used to drive the Microsoft Dynamics GP user interface, this article discusses the need to move away from the old Visual Basic for Applications (VBA) way of thinking. If you missed yesterday’s article, here is the link.
Now that VBA is “End of Life” and many sites are starting to use GP Power Tools – Developer Tools module to replace the VBA business logic with GP Power Tools triggers and scripts. However some developers are still trying to write code as though they were still limited by VBA rather than leveraging the more powerful capabilities of GP Power Tools and Dexterity.
Over the last couple of months I have been seeing a huge uptake on the sale and use of GP Power Tools – Development Tools module as more and more Microsoft Dynamics GP customer sites move their customizations away for the now “End of Life” Visual Basic for Applications (VBA).
This article explains some of the differences and techniques for the common method driving the user interface using code written in VBA, Dexterity and Visual Studio Tools (C# or Visual Basic .Net).
An important part of the amazing Microsoft Dynamics GP community is the independent consultant.
Independent consultants don’t usually sell the Microsoft software or licenses, but they provide deep knowledge about how to setup and use the accounting/ERP software. They often work in conjunction with the customer’s partner of record (POR) to provide a additional level of support.
But many of them are not signed up as a Microsoft partner and don’t have their access to the PartnerSource Business Center or their own GP Registration keys.
Awesome News.
This morning (Perth Time) I had an email from Terry Heley from Microsoft with a link to a pre-release (very early alpha) of the upcoming Microsoft Dynamics GP version 18.4 (October 2021) release. This download is provided to the ISV community to help them prepare for the final code when it is released.
A long time customer recently asked if they could get a second Salesperson ID associated with a customer on the Customer Maintenance (RM_Customer_Maintenance) window using GP Power Tools.
There is already really good guide for adding custom fields to windows and reports published (see article: #GPPT Beginner’s Guide to Adding Custom Fields), but that example does not add a field linked to an existing table and so does not have the standard GP features of a lookup button, a zoom button and on-the-fly adding of records.
IMPORTANT: This example uses functionality only available in GP Power Tools Build 28.9.
A recent post on the GPUG (Dynamic Communities) forums asked How to change the default sort order for Item History. The Item History (IV_Item_History) window in Microsoft Dynamics GP shows period summary data from the IV_SUM_HIST_Period (IV30102) table based on the Item Number, Site ID and date range on ascending period basis.
This means that once you have a data for a number of periods, the latest data is always at the bottom of the window and will require the user to scroll down to the bottom to view it.
Here is another awesome customization created using GP Power Tools. A customer requested additional Item Category fields, so this customization was created to double the number of Item Category fields from six to twelve.
The customization uses Modifier to add the additional fields to the Item Maintenance (IV_Item_Maintenance) window and the Inventory Control Setup (IV_Setup) window. The Report Writer has also been used to add the additional category fields to the Item List By User Category report.
As promised in my previous article, this article contains awesome example GP Power Tools – Developer Tools projects for tracking changes to customer and vendor cards records.
Thanks to Eric Gernan from Amaysim Mobile whom I worked with to create this custom functionality and gave me permission to publish generic versions of the projects.
Back in 2017 I wrote an article which demonstrated how to get GP Power Tools to send an email every time the Credit Limit Field on the Customer Maintenance window was edited by a user and saved.
This article revisits this article by enhancing the functionality with the options to log changes to a text file or a SQL table instead of sending an email.
Dynamic Communities (DC), the team behind GPUG, will be hosting their Community Summit Conference on 12th to 15th October 2021. The agenda with sessions has now been posted online and I will be presenting a session on Microsoft Dynamics GP development tools.
David Musgrave's Winthrop Development Consultants Blog 