Click here to
Subscribe to
our Newsletter
I was approached recently about an issue that a customer was having with the ServiceUpdateVendor Service Procedure being called as a Service Based Architecture (SBA) web service.
The web service call had worked perfectly on the system before upgrading to Microsoft Dynamics GP 18.5. Once they had upgraded, it was failing with an error.
Here is how GP Power Tools fixed the issue.
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.
Community Summit 2023 in Charlotte, North Carolina, USA is fast approaching. David Musgrave from Winthrop Development Consultants will be running two extremely valuable training courses and now it is time to register.
The conference will be held on the 15th to 20th October 2023. There will be pre-conference training in the week before, from 9th to 13th October 2023, as well as Academy days on the first two days of the conference itself.
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.
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).