Microsoft Dynamics GP – October 2020 has released

David Meego - Click for blog homepageThe latest version of Microsoft Dynamics GP was released yesterday and it contains with 20 new features and 50 bug fixes. Winthrop Development Consultants has already updated its products for this Microsoft Dynamics GP – October 2020 release. They are now built against the final build and so are no longer beta builds.

Check out the previous article for more information:

Continue reading

#GPPT GP Power Tools Build 28.2 hotfix released

David Meego - Click for blog homepageAfter the release of Build 28 of GP Power Tools, we have been getting some amazing feedback from customers and partners who are pushing the GP Power Tools to its limits and exploring all the cool things they can do.

We have decided to release hotfix build 28.2 which includes some enhancements and fixes based on the feedback.

Continue reading

Benefits Presentation Updated for GP Power Tools Build 28

David Meego - Click for blog homepageWe are pleased to announce that the Benefits Presentation for Winthrop Development Consultants products has been updated to match the recently released builds of GP Power Tools (GPPT), Batch Posting Service Toolkit (BPST) and Visual Studio Integration Toolkit (VSIT).

Continue reading

Winthrop Products for Microsoft Dynamics GP 18.3 (ISV Drop) Available

David Meego - Click for blog homepageLast Friday Terry Heley from the Microsoft Dynamics GP support and services team in Fargo, North Dakota emailed out a download of the upcoming Microsoft Dynamics GP release to the ISV (Independent Software Developer) community.

This “ISV Drop” is an early build which allows developers to start preparing to support the next version of Microsoft Dynamics GP. It give the GP developer community time to set up their development tools and environments for the new version.

Continue reading

#GPPT Free Automatic Lookup Example

David Meego - Click for blog homepageWith the completion of development and release of Build 28 of GP Power Tools, now is the time to publish more examples for the Developer Tools module. Please see the GP Power Tools Samples page for additional examples that you can download and use for free.

This example is simple and can speed up data entry in Microsoft Dynamics GP. It does require GP Power Tools (GPPT) installed and the Developer Tools module registered. If you don’t have GP Power Tools installed or the Developer Tools module registered, feel free to install and start a free 30 day trial period, so you can test out this and the many other samples.

Continue reading

#GPPT Free SQL Search across Multiple Fields Lookup Example

David Meego - Click for blog homepageWith the completion of development and release of Build 28 of GP Power Tools, there is now time to publish some of the great examples for the Developer Tools module. Please see the GP Power Tools Samples page for additional examples that you can download and use for free.

This example is amazing and every site with Microsoft Dynamics GP will want it installed. It does require the current Build 28.1 or later installed and the Developer Tools module of GP Power Tools (GPPT) registered. If you don’t have GP Power Tools installed or the Developer Tools module registered, feel free to install and start a free 30 day trial period, so you can test out this and the many other samples.

Continue reading

#GPPT GP Power Tools build 28.1 released

David Meego - Click for blog homepageWinthrop Development Consultants is extremely excited to announce Build 28 of GP Power Tools (GPPT) for Microsoft Dynamics GP was released on 11-Aug-2020.

This build is the biggest ever, incorporating massive enhancements to almost every existing feature as well as adding a host of new features to all modules of GP Power Tools. There have also been many updates and fixes to improve performance and usability throughout the product.

This blog lists some of the major new features and enhancements.  It is a long list, so go grab a cuppa/beverage and make yourself comfortable. To give you an idea of how much has been added, the user guide manual has grown from 425 pages in build 27 to 592 pages in build 28!

Continue reading

#GPPT Where can I find GP Power Tools Documentation

David Meego - Click for blog homepageGP Power Tools incorporates a feedback survey which it will prompt an administrator user 30 days after a new installation or 2 days after an updated installation.

The history behind the survey goes back to the Support Debugging Tool days. The SDT did not have any registration system and downloads were not being tracked, so it was an attempt to get usage data and product feedback to help justify the continued development of the tool.

Anyhow, one of the questions asks for a score between 1 and 9 for Documentation and a number of respondents have given a low score over the years.

Continue reading

#GPPT Automating or Customizing the Report Destination Window

David Meego - Click for blog homepageAs promised, following on from the previous article: #Dexterity Automating or Customizing the Report Destination Window, this article shows how you can achieve the automating of the Report Destination dialogs using GP Power Tools – Development Tools module, including the dialogs in the Dexterity Runtime Engine.

Continue reading

In case you missed it: Dynamics GP ISV Virtual Round Up!

David Meego - Click for blog homepageLast month, nine well known Microsoft Dynamics GP ISVs (Independent Software Vendors) held the first Dynamics GP ISV Virtual Round Up.

The Round Up consisted of nine one hour presentations spread over two days and was offered free to the Microsoft Dynamics GP Community for both Partners and Customers.

Continue reading

#GPPT Why does Automatic Logout fail to work?

David Meego - Click for blog homepageBuild 26 of GP Power Tools introduced a new Automatic Logout feature for Microsoft Dynamics GP. This functionality was further enhanced in Build 27 and again in the upcoming Build 28 release.

While there are other solutions which can log out inactive users, the implementation in GP Power Tools has many enhancements and features not available in other offerings.

However, there are also times when Automatic Logout has been reported not to work. Read on to understand what is happening….

Continue reading

#GPPT GP Power Tools Build 28 Sneak Peek

David Meego - Click for blog homepageIn the last few blog articles I have mentioned that I am working hard on development of the next release of GP Power Tools Build 28.

Here is sneak peek at some of the features coming in the next build. There are already a number of sites using beta releases of Build 28 in their live environments making sure that everything is working perfectly.

Continue reading

You are invited to the Dynamics GP ISV Virtual Round Up!

David Meego - Click for blog homepageIn May, nine well known Microsoft Dynamics GP ISVs (Independent Software Vendors) will helping the GP Community to keep learning during this time of pandemic and working from home.

We are hosting a free virtual conference with two half days of presentations called the Dynamics GP ISV Virtual Round Up.

Continue reading

#GPPT Converting .Net Execute Scripts from C# to VB.Net

David Meego - Click for blog homepageFollowing on from the previous articles: #GPPT Speeding Up Referencing Modifier Added Fields and staying Web Client compatible and #GPPT Referencing Modifier Added Fields in the Web Client using .Net Execute, this article looks how we can use VB.Net rather than C# as the scripting language in the .Net Execute scripts.

Both VB.Net and C# use the .Net Common Language Runtime (CLR) and it is usually possible to write exactly the same code in either language. So we will duplicate our existing C# scripts and convert them to VB.Net, then we will duplicate the triggers to call the new scripts.

Continue reading

#GPPT Speeding Up Referencing Modifier Added Fields and staying Web Client compatible

David Meego - Click for blog homepageUsing the method discussed in the article #GPPT Referencing Modifier Added Fields in the Web Client using .Net Execute it was possible able to get past some of the limitations mentioned in the article Dynamics.Application Object not available on Web Client.

However, running the .Net (C# or VB.Net) code is slightly slower than running the Dexterity (sanScript) code. This article explains a method of how to improve Desktop Client performance while staying compatible with the Web Client.

Continue reading

#GPPT Referencing Modifier Added Fields in the Web Client using .Net Execute

David Meego - Click for blog homepageYou probably saw the recent article: Dynamics.Application Object not available on Web Client where I described an issue that was recently discovered and meant that the “Continuum” based triggers and scripts used to reference Modifier Added Fields in GP Power Tools – Developer Tools module were unable to work in the Web Client.

I mentioned a workaround that would function with the current GP Power Tools code when running on the Web Client (and Desktop Client). This article will show how you can use scripts in the .Net Execute Setup window to reference Modifier Added Fields.

Continue reading

#GPPT Disabling Manual Entry of SOP Number Field

David Meego - Click for blog homepageRecently on the GPUG Open Forum, Jeff Roe asked if it was possible to disable manual entry by users into the SOP Number field on the Sales Transaction Entry (SOP_Entry) window.

I suggested using GP Power Tools – Developer Tools module to create a quick trigger to lock or disable the field. As Jeff is already a GP Power Tools user and has the Developer Tools module registered, I created the required code and posted it on the forum thread. Here is a slightly more detailed version of the forum response.

Continue reading

#GPPT Reporting for Minnesota’s Wage Theft Law

David Meego - Click for blog homepageThis article is comes about thanks to my friend, Melissa Brown, who approached me for a solution to a reporting requirement she had for a customer due to new legislation brought in by the US state of Minnesota.

The requirement was not possible to solve with the Dynamics Report Writer alone as it involved an array in a table which prevented a static relationship from working to retrieve the data needed.

Continue reading

#GPPT Dexterity Samples for Datatype Conversions

David Meego - Click for blog homepageThe previous article: #GPPT Parsing Returned SQL Data into Rows and Columns had some examples of how to convert string representations of various datatypes back to their native datatypes.

With GP Power Tools, it is a common technique to store additional data in the DUOS (Dynamic User Object Store) table (SY90000). However, the DUOS uses a 132 character string field to store the data and so datatype conversions in both directions will be needed.

Continue reading

#GPPT Parsing Returned SQL Data into Rows and Columns

David Meego - Click for blog homepageWhen writing customizations using GP Power Tools as your development tool, there may be times where you need to return a SQL query as a data set to your Trigger Setup script or Runtime Execute Setup script.

It is possible to display a data set to the end user in a SQL Results window using the MBS_SQL_Results helper function. If you have “Goto” actions defined, the MBS_SQL_Results_Goto helper function will display the data and enable the SQL Goto functionality.

But what if we don’t want the data displayed to the user and just need to use the data in your code.

Continue reading