Click here to
Subscribe to
our Newsletter
Winthrop Development Consultants as an ISV (Independent Software Vendor) is fully committed to the Microsoft Dynamics GP product and its ecosystem.
Our products are designed to work only with Microsoft Dynamics GP and have been created based on missing features and functionality that the GP community have asked for.
Following on from the article published on Friday about why Microsoft Dynamics GP uses many 8 upper case character table and column names:
This article consolidates many of the articles written about using MS SQL Server with Dexterity and also publishes original documentation from 1999 on how SQL Server support was added to Dexterity.
A recent post on LinkedIn asked about the reasons that most of the column names in Microsoft Dynamics GP are cryptic abbreviations of 8 upper case characters. My friend and fellow Microsoft MVP, Jen Kuntz (congrats on being re-awarded) responded and in that response tagged me.
I wrote up another comment, and then decided to turn that comment into a blog post….. here it is. 😁
I am really looking forward to joining forces with John Kirsch from sa.global to co-host a free GP Power Tools webinar. The session will be an introduction and demonstration of GP Power Tools, showing how it can solve you pain points and make the lives of GP Users, Administrators, Consultants and Developers simpler and better.
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.
This is a further update to the previous versions of the change tracking projects for Customer and Vendor cards:
Based on the version 2 projects, this update adds tracking to the Vendor and Customer EFT Bank Maintenance windows.
On the 4th 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:
On Friday 14th 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.
On the 4th 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.
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.
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:
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.