Development – Page 11 – Winthrop Development Consultants Blog

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Automating or Customizing the Report Destination Window Revisited

Aug 15, 2022 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT No Comments

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.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server, Visual Studio

#GPPT Protecting Mission Critical Custom Code

Aug 5, 2022 No Comments

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.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Creating Additional .Net Dialog Windows using Scripts

Jul 19, 2022 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT 1 Comment

One of the current limitations for GP Power Tools is that it cannot create new Dexterity windows.

[Edit] GP Power Tools can now create Custom Forms, so this is no longer a limitation:

#GPPT Implementing Custom Forms using GP Power Tools

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.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Item Cards Version 2

Jul 16, 2022 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

After the publishing of the GP Power Tools projects for tracking changes to Customer and Vendor Cards, there have 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:

#GPPT Tracking changes to Customer and Vendor Cards Version 2

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.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Customer and Vendor Cards Version 2

Jul 15, 2022 Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL No Comments

This is an update to the previous version of the change tracking projects for Customer and Vendor cards:

#GPPT Tracking changes to 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.

Conference, Development, Dexterity, Dynamics, GP, GPUG, Microsoft, Training

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

Jul 11, 2022 Tagged with Community Summit 2022, Conference, Dexterity, GPUG, Training No Comments

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

Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training

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

Jul 8, 2022 Tagged with Application, Community Summit 2022, Conference, Dexterity, GP Power Tools, GPPT, GPUG, Training No Comments

After two years of uncertainty, I am finally heading back to the United States for the Community Summit conference in Orlando, Florida, USA in 10^th to 13^th of October 2022.

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

Development, Fun

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

Jun 10, 2022 Tagged with Development, Friday Funny, Fun No Comments

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.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Importing CSV Data using GP Power Tools

Jun 9, 2022 Tagged with Application, GP Power Tools, GPPT, Integration No Comments

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 but must be saved as an 8-bit ASCII file using the ANSI or UTF-8 option.

Dynamics, GP, Microsoft, News, Public Service Announcement, SQL Server

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

May 26, 2022 Tagged with Application, News, SQL No Comments

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.