A recent Microsoft Dynamics GP forum post reminded me to create an article about a couple of cool, undocumented features available for the Dexterity Script Editor.
The request was for an easy method of inserting a script header comment block into new scripts. I have seen some developers modify/hack the DEX.DIC with Dexterity to produce similar custom functionality, but there is built in functionality you can enable instead.
This Friday, I will start my flights to the USA to get to Community Summit 2022 in Orlando. I will be flying to Singapore first and then getting on the world’s longest flight: Singapore Airlines from Singapore to New York with a flight time of 18 hours and 25 minutes.
For the first week I will be staying at the Caribe Royale hotel while I am running a 5-day Dexterity Fundamentals Bootcamp training course. Then during the Community Summit 2022 Conference being held on October 10-13, 2022, I will be at the Gaylord Palms Resort, Kissimmee, Orlando, Florida, USA.
My friend, Tim Wappat from the UK, will be helping me out at the Winthrop Development Consultants booth in the Expo Hall. Please come see us at Booth 829. Read on for more information on the two training classes and six sessions I am presenting.
David Musgrave MVP is coming to Community Summit 2022 in Orlando and will be running two training courses for GP users, administrators, consultants and developers.
The first is a 5 day Dexterity bootcamp, before the conference, which will teach you how to get started with Dexterity, the development tool used to create Microsoft Dynamics GP.
The second is a single day class on GP Power Tools, covering all modules of the product.
This 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.
It has been a long time between Newsletters, but that does not mean nothing’s been happening. On the contrary, we have been really busy working hard to improve our software products with the aim of making your lives better.
This newsletter contains important information about price changes, and new releases of all our software (including a critical security update). Please forward this newsletter to anyone in your organization who would find this information useful. They can subscribe to future newsletters using the link below:
Today, 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.
This 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.
Today 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.
GP Power Tools is a subscription based product. This means it needs current, valid Registration Keys to stay operational.
If you have written Mission Critical Custom Code using GP Power Tools – Developer Tools module, you will want to ensure that those triggers and scripts stay active at all times and if the registration fails for any reason that you are notified immediately.
One 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.
After 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.
This 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.
I have had quite a few requests for Dexterity Training recently. So once I decided to go to Community Summit in Orlando, Florida, USA in October, I planned to run a 5 day Dexterity Fundamentals Bootcamp in the week beforehand. Please register your interest as soon as possible to ensure the course goes ahead.
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).
After 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.
It 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.
I 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.
You 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.
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.
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 ….
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.