#GPPT Iterating through a Dexterity Scrolling Window

David Meego - Click for blog homepageOver 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.

Continue reading

Java Log4J Vulnerability

David Meego - Click for blog homepageOver 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…

Continue reading

K2A Days and GPUC 2021 Sponsor Video

David Meego - Click for blog homepageWinthrop 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.

Continue reading

K2A Days and GPUC 2021 starts this week

David Meego - Click for blog homepageWinthrop 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.

Continue reading

Microsoft Dynamics GP – October 2021 launch error for Australian Customers

David Meego - Click for blog homepageA 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

#GPPT Updating a Security Role to all Users and Companies in a system

David Meego - Click for blog homepageToday’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.

Continue reading

#MSDynGP Consultants: Are you a Microsoft Partner?

David Meego - Click for blog homepageAn 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.

Continue reading

#MSDynGP Microsoft Dynamics GP v18.4 ISV Pre-release installers now available

David Meego - Click for blog homepageAwesome 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.

Continue reading

#GPPT Adding a Custom Salesperson ID Field with Lookup, Zoom and On-The-Fly Adds

David Meego - Click for blog homepageA 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.

Continue reading

#GPPT Reversing the sort order of the Item History window

David Meego - Click for blog homepageA 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.

Continue reading

#GPPT Adding 6 Additional Item Category Fields

David Meego - Click for blog homepageHere 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.

Continue reading

#GPPT Tracking changes to Customer and Vendor Cards

David Meego - Click for blog homepageAs 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.

Continue reading

#GPPT Using GP Power Tools to track specific changes Revisited

David Meego - Click for blog homepageBack 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.

Continue reading

#MSDynGP Purchase Order Entry windows show costs as zero

David Meego - Click for blog homepageOver the last few weeks I have been asked about the same issue a few times by different customers and partners who were unable to work out what was happening.

So, I thought I would write an article that explains the problem and the solution and hopefully, it will show up when someone does a search when they have this issue.

Continue reading

#MSDynGP It’s official: Microsoft Dynamics GP is here to stay

David Meego - Click for blog homepageOver the last few weeks I have been chatting with Terry Heley on the Microsoft Dynamics GP Support team. She was been working really hard on getting the Lifecycle information for Microsoft Dynamics GP updated to reflect Microsoft’s ongoing commitment to the Dynamics GP product.

Regardless of of the sales hype and disinformation you might hear from other sources who want to spread FUD (Fear, Uncertainty and Doubt), Microsoft Dynamics GP is not going away any time soon and the product lifecycle information has been updated to show this.

Continue reading

#GPPT Modifying Reports based on Temporary Tables

David Meego - Click for blog homepageThe recent Build 28.8 hotfix of GP Power Tools incorporated some Developer Tools module changes to enable so very cool customization options for updating reports based on temporary tables. The big feature enhancement is the ability to store a Table Reference as a Memory parameter.

References in Dexterity are like pointers to a particular resource, so the Table Reference allows access to the particular instance table buffer without needing to pass the table as a parameter to a script.

Continue reading

#GPPT Setting Default Sorts for Inquiry Windows

David Meego - Click for blog homepageToday, I was asked by a partner how simple it would be to default the Sort by fields on the Payables Transaction Inquiry – Vendor window to Document Date in Descending order. This is previously the type of quick tweak that you might have used VBA (Visual Basic for Application) for.

However, now that VBA is “End of Life” and is not supported on the Web Client and some windows platforms, this is a perfect customization to use the GP Power Tools – Developer Tools module for. The entire customization took me about two minutes to complete. In fact, it took much longer to write this article.

Continue reading

Black Boxes and Microsoft Dynamics GP Report Writer Reports

David Meego - Click for blog homepageOver the last week, there has been a Microsoft security update released via Windows Update which is causing graphics on Microsoft Dynamics GP Report Writer reports to show as black boxes.

The Microsoft Dynamics GP support team is aware of the issue and is working to find a resolution. The current work around is to roll back the Windows Updates that caused the issue and pause updates to prevent them from being installed again.

[Edit] 20-Mar-2021: The Windows team have released a fix for this issue, it look’s like it needs to be installed manually. Please see the updates on both the articles from the Dynamics GP Support team and from Beat Bucher (links below).

Continue reading

#Dexterity Remember Multicurrency when Customizing Transaction windows

David Meego - Click for blog homepageI was asked recently to assist with some custom code that had been added to a transaction window in Microsoft Dynamics GP. The customization would work for one user, but not for a different user.

The customization was created using GP Power ToolsDeveloper Tools module, but similar code could have been created using Dexterity, Visual Studio Tools or even VBA (Visual Basic for Applications).

Continue reading