#Dexterity Script Editor Undocumented Features: Snippets and Auto Close

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

Continue reading

#SummitNA Winthrop Development Consultants at Community Summit Orlando 2022

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

Continue reading

#SummitNA Don’t miss out on the Training Opportunities at Community Summit 2022

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

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

Winthrop Development Consultants Newsletter – August 2022

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

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

#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

#Dexterity Announcing Dexterity Training before Community Summit 2022 in Orlando, FL, USA

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

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

#GPPT Iterating through a Dexterity Scrolling Window

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

Continue reading

#MySummitNA Materials from my Dynamics GP Development Tools Session

David Meego - Click for blog homepageCommunity Summit Conference 2021, hosted by Dynamic Communities (DC) ran in Houston, Texas, USA last week from 12th to 15th October 2021.

I presented a session on Microsoft Dynamics GP development tools. Because I am still unable to leave Australia due to the pandemic border closures, the session was a pre-recorded video presentation.

Continue reading

#MySummitNA Don’t miss my Dynamics GP Development Tools Session

David Meego - Click for blog homepageCommunity Summit Conference 2021, hosted by Dynamic Communities (DC), is happening right now in Houston, Texas, USA until from 12th to 15th October 2021.

I am presenting a session on Microsoft Dynamics GP development tools as the first session of the day on Friday. As I am still unable to leave Australia due to the pandemic border closures, the session has been pre-recorded and will be run as a video presentation.

However, I will be online in a Microsoft Teams Meeting for the duration of the session and would love for anyone attending the conference (and those just interested in GP Development) to join me and others in the community for a chat and Q & A session.

Continue reading

#GPPT Updating a Security Role to all Users and Companies in a system

David Meego - Click for blog homepageToday’s article comes about because I was asked if GP Power Tools could easily assign a Security Role to all users in all companies in a Microsoft Dynamics GP system.

GP Power Tools does have a copy feature in the Enhanced Security window which can copy all security settings from a selected user/company to all users in the same company or all companies for the same user, but it does not have the option to push a specific Security Role ID across the entire system.

No problem. We can just use the Developer Tools module to create this functionality in an hour or two.

Continue reading

#MSDynGP Development: Driving the User Interface of Microsoft Dynamics GP using Code

David Meego - Click for blog homepageOver the last couple of months I have been seeing a huge uptake on the sale and use of GP Power Tools – Development Tools module as more and more Microsoft Dynamics GP customer sites move their customizations away for the now “End of Life” Visual Basic for Applications (VBA).

This article explains some of the differences and techniques for the common method driving the user interface using code written in VBA, Dexterity and Visual Studio Tools (C# or Visual Basic .Net).

Continue reading

#GPPT Adding a Custom Salesperson ID Field with Lookup, Zoom and On-The-Fly Adds

David Meego - Click for blog homepageA long time customer recently asked if they could get a second Salesperson ID associated with a customer on the Customer Maintenance (RM_Customer_Maintenance) window using GP Power Tools.

There is already really good guide for adding custom fields to windows and reports published (see article: #GPPT Beginner’s Guide to Adding Custom Fields), but that example does not add a field linked to an existing table and so does not have the standard GP features of a lookup button, a zoom button and on-the-fly adding of records.

IMPORTANT: This example uses functionality only available in GP Power Tools Build 28.9.

Continue reading