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

#GPPT Stopping Vendor ID Auto Populating on Payables Transaction Window

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

Continue reading

Changing Exchange Online Settings with PowerShell

David Meego - Click for blog homepageIn my previous article: #MSDynGP Microsoft Dynamics GP and SMTP Email Failing, I mentioned that it was possible to check and/or change settings for your Exchange Online client.

There are a number of settings which can only be changed using PowerShell as they don’t have any user interface options available. However, many of the articles that provide the details on the settings never say how to actually get PowerShell working to use the settings.

This is where this article comes in …..

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

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

#GPPT Reversing the sort order of the Item History window

David Meego - Click for blog homepageA recent post on the GPUG (Dynamic Communities) forums asked How to change the default sort order for Item History. The Item History (IV_Item_History) window in Microsoft Dynamics GP shows period summary data from the IV_SUM_HIST_Period (IV30102) table based on the Item Number, Site ID and date range on ascending period basis.

This means that once you have a data for a number of periods, the latest data is always at the bottom of the window and will require the user to scroll down to the bottom to view it.

Continue reading

#GPPT Adding 6 Additional Item Category Fields

David Meego - Click for blog homepageHere is another awesome customization created using GP Power Tools. A customer requested additional Item Category fields, so this customization was created to double the number of Item Category fields from six to twelve.

The customization uses Modifier to add the additional fields to the Item Maintenance (IV_Item_Maintenance) window and the Inventory Control Setup (IV_Setup) window. The Report Writer has also been used to add the additional category fields to the Item List By User Category report.

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

#GPPT Building Self Service SQL Scripts

David Meego - Click for blog homepageThis example shows the different methods that can be used with GP Power Tools to create Self Service SQL Scripts which can be made available to all users or just specific users.

The actual SQL Script used for this demonstration is a simple select query on the Customer Master (RM00101) RM_Customer_MSTR table, but can be replaced by any SQL statements to achieve any manipulation of the data desired.

Continue reading