#MSDynGP Winthrop Products and Microsoft Dynamics GP 18.5 Year End 2022

David Meego - Click for blog homepageLast week, Terry Heley from Microsoft announced that the Microsoft Dynamics GP 18.5 Year End 2022 service pack has been released.

Since then, we have been asked numerous times if the Winthrop products are compatible with this new 18.05.1596 release. The short answer is yes.

Continue reading

#MSDynGP Microsoft, Stop Scaring Microsoft Dynamics GP Customers

David Meego - Click for blog homepageYou might have heard about the “announcement” made by Mike Morton (Vice President, Dynamics 365 Business Central and SMB, Microsoft) during the Microsoft Dynamics GP General Session and his subsequent retraction and clarification.

I decided to write this article to provide my thoughts on what happened and the bigger issues it raises.
Continue reading

#MySummitNA Clarification of Microsoft Dynamics GP Lifecycle

David Meego - Click for blog homepageMike Morton (Vice President, Dynamics 365 Business Central at Microsoft) has clarified the Microsoft Dynamics GP Lifecycle after his comments at the GP General Session during the Community Summit 2022 conference.

Dynamics GP’s lifecycle is still 2028 and beyond and does include new features as well as tax, compliance and security updates. Since GP is a mature and stable product, don’t expect large new features or new modules. The large ISV community will continue to develop additional functionality to make GP a viable system for many years to come. Continue reading

#MSDynGP Microsoft Dynamics GP v18.5 ISV Pre-release installers now available

David Meego - Click for blog homepageFantastic News.

This morning (Perth Time) I had an email from Terry Heley from Microsoft with a link to a pre-release (ISV Drop) of the upcoming Microsoft Dynamics GP version 18.5 (October 2022) release. This download is provided to the ISV community to help them prepare for the final code when it is released.

Continue reading

#GPPT Automating Applying of Payables and Receivables Documents

David Meego - Click for blog homepageThis is another one of those articles that I have been planning to write for a long time. A while ago I created some prototype scripts with GP Power Tools to show how it would be possible to “drive” the user interface to automate applying of both Payables and Receivables documents.

I have had a few people contact me about this functionality, usually because my friend and fellow MVP, Steve Endow, has told them about these scripts.

Continue reading

#GPPT Using the Clipboard to copy from Excel into Microsoft Dynamics GP

David Meego - Click for blog homepageToday, we are covering an exciting new sample customization that is now possible due to Clipboard and Parsing Data Helper Functions added to recently released Build 29 of GP Power Tools.

The customization shows how any data in a Microsoft Excel spreadsheet can be copied via the Clipboard into any window of Microsoft Dynamics GP.

Continue reading

#GPPT Linking to Document Management Systems

David Meego - Click for blog homepageThis sample is something that I have already helped customers achieve with GP Power Tools in the past but it had not been posted as a sample on the blog. The ability to link with a document management system by opening a URL with data from any window in Microsoft Dynamics GP is really easy to do.

This sample project allows scanned payables invoices to be opened in a web browser from the Payables Transaction Inquiry – Vendor and Payables Transaction Inquiry – Document windows as well as the Payables Transaction Entry Zoom window.

Continue reading

#GPPT Automating or Customizing the Report Destination Window Revisited

David Meego - Click for blog homepageToday we are revisiting the article #GPPT Automating or Customizing the Report Destination Window. In this article we show how Build 29 of GP Power Tools can improve on the methods used previously.

When automating Microsoft Dynamics GP, if a Report Destination modal dialog window opens, it needs to be dismissed so that the rest of the automation code can continue. This article contains a demonstration project that shows how to dismiss the 3 different dialogs used.

Continue reading

#MSDynGP ISV Talks with Dynamics Connections

David Meego - Click for blog homepageAs part of my marketing strategy for the last six months, I have been working with Dynamics Connections to promote my products to the Microsoft Dynamics GP partner channel.

GP Power Tools is a very easy product to sell. You just need to show the Benefits Presentation to a customer and they will want it on their system. So the aim is to get the partners to show this short presentation to their customers.

I have found that using Carol Livingston and the team at Dynamics Connections has been a worthwhile investment with an increased awareness of our products amongst the partners after her presentations.

Continue reading

#GPPT Creating Additional .Net Dialog Windows using Scripts

David Meego - Click for blog homepageOne of the current limitations for GP Power Tools is that it cannot create new Dexterity windows. Usually, it is possible to avoid this requirement by:

  • Using Modifier to add extra fields to an existing window;
  • Using the SQL Results window to display data with SQL Gotos to perform actions on that data;
  • Using Dexterity modal dialogs (ask() and getstring() for example) to get information needed;
  • Using Modifier even adding a complete “sub window” onto an existing window (example below).

This article provides another method leveraging the .Net Framework functionality to create a dynamic form using code.

Continue reading

#GPPT Tracking changes to Item Cards Version 2

David Meego - Click for blog homepageAfter the publishing of the GP Power Tools projects for tracking changes to Customer and Vendor Cards, there are been requests for the same functionality for Item Cards.

Starting with the framework updated in the version 2 of the Customer and Vendor tracking projects:

I have created the same functionality for Item Cards. It is labelled as Version 2 so it stays in sync with the other trackers. Even though this is actually the first release, it is based on the Version 2 code.

Continue reading

#GPPT Tracking changes to Customer and Vendor Cards Version 2

David Meego - Click for blog homepageThis is an update to the previous version of the change tracking projects for Customer and Vendor cards:

Based on the original projects, they have been enhanced to add some more fields into the default fields tracked, add support for array fields, and add support for tracking Modifier Added fields.

Continue reading

#MySummitNA Great News: I am coming to Community Summit 2022 in Orlando

David Meego - Click for blog homepageAfter two years of uncertainty, I am finally heading back to the United States for the Community Summit conference in Orlando, Florida, USA in 10th to 13th of October 2022.

I will be running Dexterity and GP Power Tools training, presenting a number of conference sessions and manning an Expo booth.

Continue reading

#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

#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

#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