May the Fourth Be With You …. Always.
Happy Star Wars Day everyone. Today, I have a treat for you, it dates back to 2017 so you might have seen it before. It is the culmination of five years work by the team from Palette-Swap Ninja who have taken the classic Beatles album “Sgt. Pepper’s Lonely Hearts Club Band” and merged it with the original Star Wars movie “Episode IV: A New Hope” to create the best fan made musical parody of Star Wars ever.
After three week’s work, I am thrilled to be releasing a second version of the Free SQL Search Lookups Example. Based on feedback from a number of users, the code for this example has been significantly improved and extended.
Please see the GP Power Tools Samples page for additional examples that you can download and use for free.
To give you an idea of how much it has changed, the old exported dbg.xml file was 321KB and the new one is 929KB. Read on to learn about all the changes made ….
Continue reading
This is a completely off topic post for me. It is not Microsoft Dynamics GP, Robotics or even puzzle related.
We recently moved house (twice) and during the shift from the original home to the final home, our Xbox One gaming console remained boxed up while we lived in temporary accommodation. When we unpacked the console after the second move it failed to power on. ☹️
A while back there was a forum post on the Community Forum asking how to stop the Vendor ID from automatically populating with the previously entered Vendor ID when entering Payables Transactions.
This functionality can be useful when entering multiple transactions from a single vendor, but can also cause data entry errors if entering a transaction from a different vendor and the ‘Vendor ID’ is not changed.
At first glance I thought it would simply be caused by the ‘Vendor ID’ field on the window having the object property of SavedOnRestart=True. However, that was not the case.
The latest installation DynamicsCon virtual conference started yesterday. The conference is running from 15th to 17th March 2022.
While I am not presenting a session this time around, I will be hosting the Dynamics GP Watch Party Breakout Room on Wednesday and Thursday from 10am to 12pm ET on both days.
Back in October when Microsoft Dynamics GP 18.4 (October 2021) was first released, a problem was identified that affected Australian customers. This was discussed in the article:
This previous crashing issue was caused by a version mismatch on the Visual Studio Tools Addin DLL that provides the ABN (Australian Business Number) Lookup via a webservice to the ABR (Australian Business Register).
Continue reading
With the release of Microsoft Windows 11, the hardware requirements for supported PCs took a jump from previous versions of Windows.
In particular, the requirement for Trusted Platform Module (TPM) 2.0 and a modern 64 bit CPU have caused a number of machines to not be eligible/supported to run Windows 11.
In my previous article: #MSDynGP Microsoft Dynamics GP and SMTP Email Failing, I mentioned that it was possible to check and/or change settings for your Exchange Online client.
There are a number of settings which can only be changed using PowerShell as they don’t have any user interface options available. However, many of the articles that provide the details on the settings never say how to actually get PowerShell working to use the settings.
This is where this article comes in …..
Over the last month or so many users have been reporting intermittent issues with sending emails failing with SMTP (Simple Mail Transfer Protocol) authentication failures.
The issue occurs when using Microsoft’s Exchange Online (part of the Microsoft 365 suite) as the email service. It is caused by Microsoft’s policies to improve authentication security for the Exchange Online service.
We have recently released a new hotfix build for Batch Posting Service Toolkit which fixes a recently discovered issue with Inventory Transactions posted using Service Based Architecture (SBA) not showing in the Historical Inventory Trial Balance (HITB) reports.
It is recommended that all sites running Batch Posting Service Toolkit install the latest code on all workstation and servers where it is currently installed.
We had another interesting support case recently where administrator users were getting slow login performance after installing a Winthrop Development Consultants product. When a standard user logged in they did not experience any delays.
The additional delay was around 90 to 120 seconds, after which everything would appear to work as normal.
This week we had a customer contact us after they changed the Proxy Settings which are part of the Registration System in all Winthrop Development Consultants products. After the change Microsoft Dynamics GP would crash on startup, probably because the settings were incorrect.
These settings should not normally be used as the Winthrop Development Consultants registration system (which uses Quick License Manager from Soraco Technologies) can normally work with the same internet connection as needed for standard web browsing.
In my previous article I discussed a method I have developed for Iterating through a Dexterity Scrolling Window.
This technique is something that has been requested many times as working with scrolling windows from the user interface side has always been extremely difficult. Especially when trying to reference it as a VBA (Visual Basic for Applications) or VS Tools (Visual Studio Tools) “Grid”.
This article provides a real life example implemented using GP Power Tools (build 28 or later).
Over a year ago, October 2020 to be exact, I mentioned on a forum post that I have finally worked out how to cycle through a scrolling window using Dexterity code.
Being able to perform an action for each line in a scrolling window has been something that Microsoft Dynamics GP developers have been trying to do since VBA was added to version 4.0 of GP and Visual Studio Tools was added to version 9.0 of GP.
I promised I would blog about this technique … so read on for the details.
The next installment of DynamicsCon conference is scheduled for 15th to 17th March 2022. The session submission period is over and now we enter the session voting period until 19th January 2022.
During this voting period all registered attendees have 12 votes to apply to sessions as they wish, then the votes will be tallied and the final session lists published. See this explanation for more details of the process.
This is just a quick post to wish everyone a Merry Christmas and a Happy New Year.
The last couple of years have been hard times for all and I am looking forward to better times to come.
Over the last few days I have received a number of requests for clarification of the status of Winthrop Development Consultants’ products and whether they are at risk from the Java Log4J vulnerability that has been in the news recently.
The short answer is no.
For those who would like a bit more information read on…
Back in August 2006, while at Microsoft, I started development on a Dexterity based tool designed to use programmatic control Dexterity logging and table based triggers to capture three logs leading up to a non reproducible data error occurring in the tables. This was build 1 of the MBS Support Debugging Tool.
In September 2008, the renamed Support Debugging Tool (SDT) build 9 was released to the GP partner and customer community for them to use and help support their Microsoft Dynamics GP systems. For the next 6 years, I continued to work on the SDT pet project (builds 10 to 19) in my own time as it was not officially part of my role at Microsoft.
Winthrop Development Consultants are proud to be one of the sponsors of the K2A Days & GPUC event running in Fargo, North Dakota, USA (the home of Microsoft Dynamics GP) this week.
The event is hosted by Implementation Specialists and for the first two days focusses on Key2Act (formerly Wennsoft) customers with the final three days covering everything Microsoft Dynamics GP.
Winthrop Development Consultants are proud to be one of the sponsors of the K2A Days & GPUC event running this week in Fargo, North Dakota (the home of Microsoft Dynamics GP) and virtually.
The event is hosted by Implementation Specialists and for the first two days focusses on Key2Act (formerly Wennsoft) customers with the final three days covering everything Microsoft Dynamics GP.
David Musgrave's Winthrop Development Consultants Blog 