#GPPT GP Power Tools “Causes” and Fixes a Performance Issue

David Meego - Click for blog homepageToday, I started the morning with a support call with a US customer and partner regarding what appeared to be a performance issue caused by GP Power Tools.

Once we used GP Power Tools to troubleshoot and identify the root cause of the issue, it was easy to see why they incorrectly thought the problem was caused by GP Power Tools.

Read on to understand what happened and how to make sure it does not happen on your systems ….

Continue reading

#GPPT Validating Australia Business Numbers (ABN)

David Meego - Click for blog homepageThis article and sample GP Power Tools project comes about after hearing about a disturbing situation that has resulted in an unsuspecting Australian business receiving a surprise $100,000 tax bill.

The sample project code provided at the bottom of this article was created to help ensure that Australian Microsoft Dynamics GP sites don’t get caught out in the same way.

Continue reading

Friday Funny: Creating The Worst Programming Language Ever – Mark Rendle

David Meego - Click for blog homepageIt has been a while since I have posted a Friday Funny, so here is my latest fun find for you.

Fellow Microsoft MVP Mark Rendle presented this great session at the NDC Conference in Oslo, Norway in 2021 about his personal quest to design the worst programming language ever!

After watching the video with laughter, shock and horror I had to share it with you.

Continue reading

#GPPT Importing CSV Data using GP Power Tools

David Meego - Click for blog homepageI have been asked many times about integrating data using GP Power Tools. While this is not what GP Power Tools – Developer Tools module was originally designed to do, it can be used to integrate data (for both adding and updating records).

The main reason for writing this article and creating the updated project was because a friend asking for a quick method for updating Item List Price information because their suppliers are providing new pricing information on a weekly (or less) basis.

The IMPORT_EXAMPLE Project take an original example script and massively improves on its capabilities to make it really simple method to integrate data for Accounts, Customers, Vendors and Items from a CSV (Comma Separated Values) text file. The file can be edited with Excel or your favourite text editor.

Continue reading

#MSDynGP New NACHA Data Security Requirements coming up on 30-Jun-2022

David Meego - Click for blog homepageYou might be aware of the new Security requirements for Bank Account Numbers which applies to ACH Originators and Third-Parties with more than 2 million ACH payments annually and becomes effective on 30-Jun-2022.

NACHA, the governing body for ACH transactions in the United States, is rolling out updated security requirements which are actually best practice whether you meet the transaction level targets or not.

Read on for how you handle the requirements on your Microsoft Dynamics GP system.

Continue reading

#GPPT Obscuring Bank Account Numbers in Microsoft Dynamics GP

David Meego - Click for blog homepageThis 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.

Continue reading

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

David Meego - Click for blog homepageMay 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.

Continue reading

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

David Meego - Click for blog homepageAfter 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 ….
Continue reading

I Fixed my Xbox One Gaming Console

David Meego - Click for blog homepageThis 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. ☹️

Continue reading

#GPPT Stopping Vendor ID Auto Populating on Payables Transaction Window

David Meego - Click for blog homepageA 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.

Continue reading

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

David Meego - Click for blog homepageThe 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.

Continue reading

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

David Meego - Click for blog homepageBack 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

Changing Exchange Online Settings with PowerShell

David Meego - Click for blog homepageIn 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 …..

Continue reading

#MSDynGP Microsoft Dynamics GP and SMTP Email Failing

David Meego - Click for blog homepageOver 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.

Continue reading

#BPST Batch Posting Service Toolkit Build 11.4 hotfix released

David Meego - Click for blog homepageWe 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.

Continue reading

Slow Login Performance After Installation

David Meego - Click for blog homepageWe 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.

Continue reading

Resetting Incorrect Registration Proxy Settings

David Meego - Click for blog homepageThis 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.

Continue reading

#GPPT Iterating through a Dexterity Scrolling Window Sample

David Meego - Click for blog homepageIn 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).

Continue reading