#GPPT Stopping Vendor ID Auto Populating on Payables Transaction Window

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.

#GPPT Beginner’s Guide to Adding Custom Fields – Video Demonstration

Welcome to the eighth and final article in the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

• #GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will put everything in the previous articles together in a video demonstration of the steps.

#GPPT Beginner’s Guide to Adding Custom Fields – Publishing the project

Welcome to the seventh article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

• #GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will adjust security and GP Power Tools settings to publish the customization to all users.

#GPPT Beginner’s Guide to Adding Custom Fields – Modifying the report

Welcome to the sixth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

• #GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will use Report Writer to modify the Detailed Item List report to add a calculated field which in turn calls the custom RW Function created in the previous article.

#GPPT Beginner’s Guide to Adding Custom Fields – Creating the RW function

Welcome to the fifth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

• #GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will use GP Power Tools to create a custom Report Writer (RW) function which will allow our custom URL field to be easily added to reports in the Report Writer.

#GPPT Beginner’s Guide to Adding Custom Fields – Using the data

Welcome to the fourth article in the series of articles that explain in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

• #GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will use GP Power Tools to add the business logic to make the URL field work. We will make the hidden button open the URL in a browser window and add http:// at the beginning of the URL field if it is not added by the user.

#GPPT Beginner’s Guide to Adding Custom Fields – Saving the data

Welcome to the third article in the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

• #GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will use GP Power Tools to add the business logic to save the data from the newly added custom field on the Item Maintenance window.

#GPPT Beginner’s Guide to Adding Custom Fields – Modifying the window

Welcome to the second article in the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

• #GPPT Beginner’s Guide to Adding Custom Fields – Introduction

In this article we will use Modifier to add the custom field to the Item Maintenance window.

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

Welcome to a series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic. The example project will only need six scripts and no external development tools will be required.

The aim of this series is to work through each of the parts of the process and explain with step by step instructions how it works and why various settings are used. The final article also includes a step by step video.

It would be possible to just show the final result, but I want this series to serve as a guide for creating similar customizations in your own system. That said I will provide the final customization files at the end of the series.

#GPUGSummit Developers at GPUG Summit

Hey Developers… Are you attending the GPUG Summit 2017 conference in Nashville, Tennessee in October? If so, this article is to let you know about Microsoft Dynamics GP related Developer content at the conference.

I asked why there was not much content for developers at GPUG Summit and I was told that there are not many developers in attendance. I disagreed and requested a session for Developers, which Bob McAdam promptly organised … thanks Bob. 🙂

How to dynamically modify Extender windows

This blog article has been prompted by the thread below on the Microsoft Dynamics GP community forum:

• Extender DELETE button access

I had responded with some information on the thread, but when I tried to implement the suggestions I made, I found that it was not actually possible and that other methods would be needed.

Identifying where SmartList Column Data comes from

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Recently, I had a support case which asked the following: “When I go to Add the Sales Account Number to the Sales Line Items SmartList, there are three Sales Account Number Columns available. What is the difference between them?”

Quick Tip: Where does that customisation come from?

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots.

Quick Tip: VBA ADO Connection Run-time error ‘3709’

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

It has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while.

Edits To Dynamics Launch File Won’t Save

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

My blog post today isn’t anything earth shattering but something a partner ran into that was unexpected.  Logical – but unexpected nonetheless.

Changing the Phone Number Format

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One of the most common customisations outside of North America is changing the Phone Number Format.  The North American default format of (XXX) XXX-XXXX  Ext. XXXX is not always suitable for other countries.

Why does Microsoft Dynamics GP 10.0 and later use a Data Folder?

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I recently responded on a forum post which asked why the paths for the custom forms and reports dictionaries in the Dynamics.set launch file where pointing to the Data folder. The post also asked why the application did not complain about the fact that the dictionaries listed in the Dynamics.set did not actually exist in the Data folder.

So, I thought it would be a good excuse to answer the questions raised as a blog post.

Quick Tip: Solving “Do you want to Save?” dialog appearing after VBA customization

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Have you ever used Modifier and Visual Basic for Applications (VBA) to add an additional field to a window?  Have you then had the issue when navigating through records on that window, it keeps coming up and asking “Do you want to Save, Discard or Cancel?” or “Do you want to Save, Delete or Cancel?“.

Avoiding VBA Circular References when using a Dynamics GP Lookup

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Honestly, I struggled a bit on the title of this article.

Is this article to show one way to use a Dynamics GP lookup window in your Modifier/VBA customization?  Or is it an article that shows a way to work around the circular reference problem that you can get yourself into when using VBA across projects in Dynamics GP?

Errors when importing Customization Maintenance Packages

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I had a support case that was asking about errors when importing a package via Customization Maintenance (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance).  The partner was unable to find an explanation of the errors on the Internet and so I thought I would explain what the errors mean and provide some best practices to avoid these issues in the future.