#GPPT Adding Multi Factor Authentication to the Microsoft Dynamics GP application

David Meego - Click for blog homepageMicrosoft Dynamics GP has added support for Multi Factor Authentication (MFA) to the emailing functionality inside Dynamics GP to allow it to connect to Microsoft Exchange, now that simple authentication is no longer supported.

However, there is no MFA functionality for logging into the Microsoft Dynamics GP application itself… until now.

Using GP Power Tools Developer Tools module, with a single after login trigger, it is possible to force the request to connect to Microsoft Exchange and close GP if the connection is not authenticated.
Continue reading

#DynamicsCon Announces Winthrop Dexterity Consultants as Title Sponsor for Dynamics GP Track

David Meego - Click for blog homepageYes, you heard correctly. Winthrop Development Consultants is thrilled to be Title Sponsor of the March 2023 DynamicsCon Virtual Conference taking place on 15th and 16th of March 2023.

Make sure you register to attend this free online conference to learn more about Microsoft Dynamics GP and related products and technologies.

Continue reading

#GPPT Automatic Logout Not Identifying Activity and Logging Out

David Meego - Click for blog homepageWe get reports every now and then of a user being logged out of Microsoft Dynamics GP by the GP Power Tools Automatic Logout feature even though they have been active on GP within the timeout period.

This happens because there is no way to track “Inactivity” in Microsoft Dynamics GP, so instead we attempt to track “Activity” by triggering on common events/scripts within GP and resetting the last active time and date.

However, there are times when a user could be active in GP and manages to avoid invoking any of the actions that would be identified as “Activity”. When this happens, they can be logged out incorrectly.

Continue reading

#GPPT Automating Printing and Emailing of Sales Order Processing Documents

David Meego - Click for blog homepageMicrosoft Dynamics GP has the ability to output Sales Order Processing transactions to a printer so the documents can be sent via “snail” mail, or you can send the documents via email. You can even send documents both to email and the printer.

However, two issues have been found which make the functionality less than perfect. This sample project for GP Power Tools resolves these issues and restores the perfection.
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

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 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 Moving on from the Visual Basic for Applications (VBA) Mindset

David Meego - Click for blog homepageAs a follow on from yesterday’s article on how different languages can be used to drive the Microsoft Dynamics GP user interface, this article discusses the need to move away from the old Visual Basic for Applications (VBA) way of thinking. If you missed yesterday’s article, here is the link.

Now that VBA is “End of Life” and many sites are starting to use GP Power Tools – Developer Tools module to replace the VBA business logic with GP Power Tools triggers and scripts. However some developers are still trying to write code as though they were still limited by VBA rather than leveraging the more powerful capabilities of GP Power Tools and Dexterity.

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 Tracking changes to Customer and Vendor Cards

David Meego - Click for blog homepageAs promised in my previous article, this article contains awesome example GP Power Tools – Developer Tools projects for tracking changes to customer and vendor cards records.

Thanks to Eric Gernan from Amaysim Mobile whom I worked with to create this custom functionality and gave me permission to publish generic versions of the projects.

Continue reading

#GPPT Using GP Power Tools to track specific changes Revisited

David Meego - Click for blog homepageBack in 2017 I wrote an article which demonstrated how to get GP Power Tools to send an email every time the Credit Limit Field on the Customer Maintenance window was edited by a user and saved.

This article revisits this article by enhancing the functionality with the options to log changes to a text file or a SQL table instead of sending an email.

Continue reading

#MySummitNA Dynamics GP Development Tools Session

David Meego - Click for blog homepageDynamic Communities (DC), the team behind GPUG, will be hosting their Community Summit Conference on 12th to 15th October 2021. The agenda with sessions has now been posted online and I will be presenting a session on Microsoft Dynamics GP development tools.

Continue reading