#GPPT Adding Multi Factor Authentication to the Microsoft Dynamics GP application

Microsoft Dynamics GP has added support for Multi Factor Authentication (MFA) to the emailing functionality inside Dynamics GP to allow it to connect to Microsoft Exchange, now that simple authentication is no longer supported.

However, there is no MFA functionality for logging into the Microsoft Dynamics GP application itself… until now.

Using GP Power Tools Developer Tools module, with a single after login trigger, it is possible to force the request to connect to Microsoft Exchange and close GP if the connection is not authenticated.

#DynamicsCon Fun Fact Challenge

Winthrop Development Consultants is the proud Title Sponsor of #DynamicsConVIRTUAL happening March 15^th and 16^th.

Join our Fun Fact Challenge for a chance to win a $100 USD Amazon gift card!

#DynamicsCon Announces Winthrop Dexterity Consultants as Title Sponsor for Dynamics GP Track

Yes, you heard correctly. Winthrop Development Consultants is thrilled to be Title Sponsor of the March 2023 DynamicsCon Virtual Conference taking place on 15^th and 16^th of March 2023.

Make sure you register to attend this free online conference to learn more about Microsoft Dynamics GP and related products and technologies.

#GPPT Running SQL Scripts for All Companies, such as a smarter GRANT script

This article has two purposes. The first is to highlight a very useful script published by Michael Krasivsky from The Resource Group back in 2016. The second is to explain how easy it is to use the GP Power Tools SQL Execute Setup window to execute scripts against multiple databases.

Microsoft Dynamics GP provides access to all the SQL Resources (Tables, Views, Stored Procedures, etc.) using the DYNGRP SQL role. For this technique to work correctly, all GP users need to be assigned to the DYNGRP role and all SQL objects need access “Granted” to the same DYNGRP role.

#MVPbuzzChat by Christian Buckley with David Musgrave

Back in mid-January, I had fantastic long chat with Christian Buckley from buckleyPLANET about my journey to becoming a Microsoft MVP (Most Valuable Professional), my time with Microsoft, my work since starting Winthrop Development Consultants and my hobbies with music, Lego and robots.

We actually spoke for quite a while before the recording started and it was really enjoyable to compare notes with Christian as some elements of our respective career paths were very similar.

#MSDynGP 2023 Report on the Future of Dynamics GP

I received a very interesting email yesterday. AccountingWare, the people behind the ActivReporter reporting tool for GP, created a report on the future of Dynamics GP based on the results of a survey of 164 Microsoft Dynamics GP customers.

This report supports anecdotal evidence that most of the Microsoft Dynamics GP customer base is happy staying with Dynamics GP for the foreseeable future.

#GPPT Automating Printing and Emailing of Sales Order Processing Documents

Microsoft Dynamics GP has the ability to output Sales Order Processing transactions to a printer so the documents can be sent via “snail” mail, or you can send the documents via email. You can even send documents both to email and the printer.

However, two issues have been found which make the functionality less than perfect. This sample project for GP Power Tools resolves these issues and restores the perfection.

#GPPT Installing GP Power Tools Build 29 or later can break older Windows Applications

A recent support case was reported where a site updated to GP Power Tools Build 29 and after the installation a separate Windows Application stopped working.

Initially, the only way the customer was able to get this application working again was to rebuild the workstation by re-imaging back to a clean Windows installation. After a bit of troubleshooting, we were able to identify the cause of the issue.

#GPPT Ensuring Custom Triggers Cannot Be Disabled

If you are using GP Power Tools in your Microsoft Dynamics GP system and have the Developer Tools module registered you can use the custom trigger in this article to ensure that GP Power Tools triggers cannot be disabled using the Customization Status window.

This will protect mission critical customizations written using GP Power Tools with triggers from being disabled manually.

#GPPT Why Does The Report Writer Screen Close Automatically?

With the release of build 29 of GP Power Tools, a feature was added that will automatically close the Report Writer Screen Output window after a period of time.

As customers have been upgrading their systems to the latest GP Power Tools build they have been noticing that the Report Writer Screen Output closes by itself.

This article explains how to change the timeout setting and why this new feature is so important.

#MSDynGP Microsoft Dynamics GP Crashing on Launch

I recently had a partner contact me when they were doing an upgrade and Microsoft Dynamics GP was crashing upon launching the application. As Winthrop products were installed, we were looking initially to see if the problem was caused by GP Power Tools or Visual Studio Integration Toolkit.

Short Answer: Removing the Winthrop products did not fix the problem …

#MSDynGP Winthrop Products and Microsoft Dynamics GP 18.5 Year End 2022

Last week, Terry Heley from Microsoft announced that the Microsoft Dynamics GP 18.5 Year End 2022 service pack has been released.

• Microsoft Dynamics GP U.S. Year-End Update 2022 RELEASED!!

Since then, we have been asked numerous times if the Winthrop products are compatible with this new 18.05.1596 release. The short answer is yes.

#MSDynGP Microsoft, Stop Scaring Microsoft Dynamics GP Customers

You might have heard about the “announcement” made by Mike Morton (Vice President, Dynamics 365 Business Central and SMB, Microsoft) during the Microsoft Dynamics GP General Session and his subsequent retraction and clarification.

I decided to write this article to provide my thoughts on what happened and the bigger issues it raises.

#MySummitNA Clarification of Microsoft Dynamics GP Lifecycle

Mike Morton (Vice President, Dynamics 365 Business Central at Microsoft) has clarified the Microsoft Dynamics GP Lifecycle after his comments at the GP General Session during the Community Summit 2022 conference.

Dynamics GP’s lifecycle is still 2028 and beyond and does include new features as well as tax, compliance and security updates. Since GP is a mature and stable product, don’t expect large new features or new modules. The large ISV community will continue to develop additional functionality to make GP a viable system for many years to come.

Microsoft Dynamics GP 18.5 – October 2022 has released

The latest version of Microsoft Dynamics GP was released today, and it contains a number of new features and bug fixes. Winthrop Development Consultants has already updated its products for this Microsoft Dynamics GP 18.5 – October 2022 release. They are now built against the final build and so are no longer beta builds.

Check out the previous article for more information:

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

#SummitNA Winthrop Development Consultants at Community Summit Orlando 2022

This Friday, I will start my flights to the USA to get to Community Summit 2022 in Orlando. I will be flying to Singapore first and then getting on the world’s longest flight: Singapore Airlines from Singapore to New York with a flight time of 18 hours and 25 minutes.

For the first week I will be staying at the Caribe Royale hotel while I am running a 5-day Dexterity Fundamentals Bootcamp training course. Then during the Community Summit 2022 Conference being held on October 10-13, 2022, I will be at the Gaylord Palms Resort, Kissimmee, Orlando, Florida, USA.

My friend, Tim Wappat from the UK, will be helping me out at the Winthrop Development Consultants booth in the Expo Hall. Please come see us at Booth 829. Read on for more information on the two training classes and six sessions I am presenting.

#SummitNA Don’t miss out on the Training Opportunities at Community Summit 2022

David Musgrave MVP is coming to Community Summit 2022 in Orlando and will be running two training courses for GP users, administrators, consultants and developers.

The first is a 5 day Dexterity bootcamp, before the conference, which will teach you how to get started with Dexterity, the development tool used to create Microsoft Dynamics GP.

The second is a single day class on GP Power Tools, covering all modules of the product.

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

Fantastic News.

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.5 (October 2022) release. This download is provided to the ISV community to help them prepare for the final code when it is released.

#GPPT Automating Applying of Payables and Receivables Documents

This is another one of those articles that I have been planning to write for a long time. A while ago I created some prototype scripts with GP Power Tools to show how it would be possible to “drive” the user interface to automate applying of both Payables and Receivables documents.

I have had a few people contact me about this functionality, usually because my friend and fellow MVP, Steve Endow, has told them about these scripts.

#GPPT Using the Clipboard to copy from Excel into Microsoft Dynamics GP

Today, we are covering an exciting new sample customization that is now possible due to Clipboard and Parsing Data Helper Functions added to recently released Build 29 of GP Power Tools.

The customization shows how any data in a Microsoft Excel spreadsheet can be copied via the Clipboard into any window of Microsoft Dynamics GP.