GP – Page 15 – Winthrop Development Consultants Blog

#MSDynGP Microsoft Announcement April 2023

Apr 6, 2023 Tagged with Application, News 2 Comments

On the 4^th April 2023, Microsoft made an announcement about the future of new Microsoft Dynamics GP sales. While the details of the announcement are primarily behind “partner only” links, I wanted to explain the main points and how the announcement has very little effect for existing Microsoft Dynamics GP customers.

For existing Microsoft Dynamics GP customers nothing has really changed. Microsoft has committed to continuing support and development of Dynamics GP to 2028 and beyond.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Changing and Recalculating SOP Tax Rates

Apr 5, 2023 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT No Comments

Back when Australia introduced its Goods and Services Tax (GST) in July 2000, I designed and developed the Business Activity Statement (BAS) Tax reporting tool which also contained a utility to update tax schedules and recalculate taxes on unposted Sales Order Processing Transactions.

This code was re-used in October 2010 when New Zealand changed its GST tax rate. The code from the BAS reporting tool was copied and placed into Runtime Execute scripts for the Support Debugging Tool (see original article).

This week I was contacted by James Bacon from Green Rubber – Kennedy Ag as he wanted to use the code again to update some transactions when a tax rate had changed. While the code did “mostly” work, this was an opportunity to update the code to improve it and use more features in GP Power Tools.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft

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

Mar 6, 2023 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT 1 Comment

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.

[Edit] Build 33 of GP Power Tools now supports true MFA on login using an Authenticator app with a One Time Password:

#GPPT GP Power Tools Build 33 Sneak Peek Login MFA and SSO for Dynamics GP

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.

Conference, DUG, Dynamics, GP, Microsoft

#DynamicsCon Fun Fact Challenge

Feb 22, 2023 Tagged with Application, Conference, DUG, DynamicsCon No Comments

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!

Conference, Development, DUG, Dynamics, GP, GP Power Tools, Microsoft, Products

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

Feb 21, 2023 Tagged with Application, Conference, Development, DUG, DynamicsCon, GP Power Tools, GPPT No Comments

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.

Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

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

Feb 16, 2023 Tagged with Application, GP Power Tools, GPPT, SQL No Comments

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.

Dynamics, GP, Microsoft, News

#MVPbuzzChat by Christian Buckley with David Musgrave

Feb 15, 2023 Tagged with Application, News No Comments

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.

Business, Dynamics, GP, Microsoft, News

#MSDynGP 2023 Report on the Future of Dynamics GP

Feb 3, 2023 Tagged with Application, News No Comments

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.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft

#GPPT Automating Printing and Emailing of Sales Order Processing Documents

Dec 21, 2022 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT No Comments

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.

Dynamics, GP, GP Power Tools, Microsoft, Products

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

Dec 20, 2022 Tagged with Application, Exception, GP Power Tools, GPPT No Comments

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.