#SQL Parsing data out of Note Text Fields

Today, I was asked by a consultant how to parse specific data out of the record note associated with a transaction or master record in Microsoft Dynamics GP using a SQL Server query.

GP uses the SY_Record_Notes_MSTR (SY03900) Record Notes Master table to store a text field of up to 32767 characters linked to master or transaction record using the Note Index (NOTEINDX) field. The next available Note Index is stored in the SY_Company_MSTR (SY01500) Company Master in the system (DYNAMICS) database and is assigned to new records when they are created.

#GPPT Closing External Applications with Automatic Logout

Today I was asked if the GP Power Tools Automatic Logout functionality can be used to automatically logout other external applications, for example: SalesPad For GP from Cavallo.

My initial answer was that it was not possible as the Automatic Logout functionality provided in GP Power Tools is Dexterity based and does not have the ability to affect other applications.

But then I thought about it some more and …

#StarWarsDay: May the Fourth Be With You 2023

Today is Star Wars Day. May the Fourth Be With You. Always…

Or at least until the end of the day.

I found an interesting article from last year which explains the history of Star Wars Day and thought the readers of my blog would enjoy it.

#GPPT Tracking changes to Customer and Vendor Cards Version 3

This is a further update to the previous versions of the change tracking projects for Customer and Vendor cards:

• #GPPT Tracking changes to Customer and Vendor Cards Version 2

Based on the version 2 projects, this update adds tracking to the Vendor and Customer EFT Bank Maintenance windows.

ANZAC Day 2023

Today on 25^th of April in Australia and New Zealand as well as many locations around the world, ANZAC day is being commemorated with dawn services and a day of remembrance. ANZAC day was originally set aside to honour the young men of the Australian and New Zealand Army Corp who served and died in the Great War of 1914-1918. The ANZAC soldiers served in many fields of combat during World War I but are mostly remembered for their actions on the Western Front in France and Gallipoli in Turkey.

Friday Funny: Family Member puzzle

It has been a long time since posting a Friday Funny puzzle, but I found this one recently and thought I would see how you go with it.

Just make sure you think about the information provided.

#MSDynGP Lapsed Microsoft Dynamics GP customers should renew their enhancement plans before April 2025

On the 4^th April 2023 Microsoft made an announcement about the future of licensing for new customer sales of Microsoft Dynamics GP. The details of this announcement, my thoughts on it and links to other related articles are available from:

• #MSDynGP Microsoft Announcement April 2023

On Friday 14^th April 2023, MS Dynamics World and Dynamics User Group held a panel discussion on what the announcement means to the customer base, and it raised the concern that prompted this article.

#GPPT GP Power Tools Training at Community Summit 2023 in Charlotte, NC, USA

I am pleased to announce that as well as the Dexterity Training (during the week before the conference), there will also be GP Power Tools training offered at Academy at Summit in the days before Community Summit in Charlotte, North Carolina, USA.

The training will be presented as a single full day course on Sunday 15^th October 2023, running from 8:00am to 5:00pm with lunch included.

We always have lots of new functionality and enhancements to cover with the release the latest builds of GP Power Tools.

#Dexterity Announcing Dexterity Training before Community Summit 2023 in Charlotte, NC, USA

As is becoming a tradition, I will once again be running the 5-day Dexterity training class in the week before the Community Summit conference in Charlotte, North Carolina, USA in October. Please register for the training now and plan to be in Charlotte for the week before the conference.

Dexterity is the development environment that Microsoft Dynamics GP is built on and the best tool to use for any customization to the user interface of the product. Knowledge of Dexterity is vital for anyone customizing Dynamics GP even when using other development tools such as GP Power Tools – Developer Tools module, Visual Studio Tools (C# or VB .Net) or “End of Life” VBA (Visual Basic for Application).

#MSDynGP Microsoft Announcement April 2023

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.

#GPPT Changing and Recalculating SOP Tax Rates

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.

#MySummitNA Last Call for Community Summit 2023 Session Ideas

The Community Summit 2023 conference will be held in Charlotte, North Carolina, USA on 15^th to 20^th October 2023.

Winthrop Development Consultants will be there to run Dexterity Training in the week before the conference (9^th to 13^th October) and have a booth at the Expo as well as present some sessions.

And that is today’s topic. The call for speakers and session ideas is open until 31^st March, so act now!

Great New Introduction Videos

Winthrop Development Consultants was the proud sponsor of the Microsoft Dynamics GP track at the recent DynamicsCon Virtual March 2023 conference. Part of the conference sponsorship package required us to create a 60 second video advert for Winthrop Development Consultants.

Thanks to Carol Livingston from Dynamics Connections who recommended the great tool Renderforest which was used to eventually create four new videos, including two shortened one-minute versions.

#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.

Fight Cancer by sponsoring the Life Cycle for Canteen OnRoad 2023

I have left this a bit later than I planned, but this is a request for sponsorship to help me fight cancer and its effects on those fighting this horrible disease as well as on their friends and family.

Canteen Australia is an amazing charity that supports youth and young adults who have been affected (directly or indirectly) by cancer. The Life Cycle for Canteen charity bike rides are the largest single source of financial support for Canteen in Western Australia. Since 1998 over $2,500,000 has been raised and donated.

#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.