Winthrop Development Consultants Blog

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

#GPPT Obscuring Bank Account Numbers in Microsoft Dynamics GP

May 25, 2022 Tagged with Application, GP Power Tools, GPPT No Comments

This article covers the latest “Must Have” free sample project for the GP Power Tools – Developer Tools module (requires Build 28 or later).

Back in 2012, I created code to obscure customer credit card details (see more information below). Using the same concepts, I have now created a project to obscure Bank Account Numbers for Checkbooks, Customers, Vendors and Employees.

Whether you have a requirement (see NACHA Security Requirements article) or not, best practice would be to make sure that Bank Account Numbers in your system are not human readable while stored in the database.

Fun

Happy Star Wars Day: Princess Leia’s Stolen Death Star Plans

May 4, 2022 Tagged with Fun 1 Comment

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.

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

#GPPT Free SQL Search across Multiple Fields Lookup Example Version 2

Apr 13, 2022 Tagged with Application, GP Power Tools, GPPT 1 Comment

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. It even now has an optional Automatic Selection mode for when there is only one record returned.

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

Microsoft, Public Service Announcement, Xbox

I Fixed my Xbox One Gaming Console

Mar 29, 2022 Tagged with General, Xbox 2 Comments

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. ☹️

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

#GPPT Stopping Vendor ID Auto Populating on Payables Transaction Window

Mar 24, 2022 Tagged with Application, GP Power Tools, GPPT, Modifier No Comments

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.

Conference, News

#DynamicsCon I will be hosting the Dynamics GP Watch Party Breakout Room on Wednesday and Thursday

Mar 16, 2022 Tagged with Conference, DynamicsCon, News No Comments

The latest installation DynamicsCon virtual conference started yesterday. The conference is running from 15^th to 17^th 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.

Dynamics, GP, Microsoft, News

#MSDynGP Microsoft Dynamics GP 18.4 hotfix breaks features for Australian Customers

Mar 10, 2022 Tagged with Application, Exception No Comments

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:

Microsoft Dynamics GP – October 2021 launch error for Australian Customers

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

Microsoft, News, Windows

Installing Windows 11 on an unsupported PC

Mar 7, 2022 Tagged with Windows 11 No Comments

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.

Dynamics, GP, Microsoft, News, PowerShell

Changing Exchange Online Settings with PowerShell

Feb 4, 2022 Tagged with Application, News, PowerShell 6 Comments

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

Dynamics, GP, Microsoft, News

#MSDynGP Microsoft Dynamics GP and SMTP Email Failing

Feb 2, 2022 Tagged with Application, News No Comments

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.