#GPPT Purchase Order Processing Lock Cost Part 3

David Meego - Click for blog homepageThis article completes the creation of a GP Power Tools customization to prevent POP Receivings from updating the Originating Invoice Cost field on the Item Vendors Maintenance window.

Please make sure you have read the previous articles before continuing:

In the previous articles we used GP Power Tools to identify the table and field we want to work with as well as the script responsible for making the change to the field during the receivings posting process and then used triggers to restore the previous value of the field when posting receivings transactions.

Continue reading

#GPPT Purchase Order Processing Lock Cost Part 2

David Meego - Click for blog homepageThis article continues the creation of a GP Power Tools customization to prevent POP Receivings from updating the Originating Invoice Cost field on the Item Vendors Maintenance window.

Please make sure you have read the previous article before continuing:

In the previous article we used GP Power Tools to identify the table and field we want to work with as well as the script responsible for making the change to the field during the receivings posting process.

Continue reading

#GPPT Purchase Order Processing Lock Cost Part 1

David Meego - Click for blog homepageI was recently working with a GP Power Tools customer who wanted to solve an issue with how the Purchase Order Processing (POP) module on their Microsoft Dynamics GP system functions.

They have international suppliers who specify the cost for their inventory items on a regular basis by sending through a price list document. Due to long lead times and shipping delays caused by the pandemic, cost pricing might change while the items are still in transit.

The issue is that when receiving a purchase order, the Originating Invoice Cost field on the Item Vendors Maintenance window is updated from the last received transaction, overwriting the current cost price provided by the supplier. The result is that subsequent purchase orders created have the incorrect cost value from the receivings transaction instead of from the supplier’s price list.

Continue reading

#GPPT GP Power Tools Build 28.7 hotfix released

David Meego - Click for blog homepageOver the last few months I have been really busy with some non work issues (such as preparing to sell my house), but have also been making some really awesome enhancements and fixes to the Administrator Tools, Developer Tools and Database Tools modules of GP Power Tools and this hotfix makes them all available to the community.

It is highly recommended that all sites running GP Power Tools install the latest code on all workstation and servers where Microsoft Dynamics GP is installed.

Continue reading

#GPPT Setting Default Sorts for Inquiry Windows

David Meego - Click for blog homepageToday, I was asked by a partner how simple it would be to default the Sort by fields on the Payables Transaction Inquiry – Vendor window to Document Date in Descending order. This is previously the type of quick tweak that you might have used VBA (Visual Basic for Application) for.

However, now that VBA is “End of Life” and is not supported on the Web Client and some windows platforms, this is a perfect customization to use the GP Power Tools – Developer Tools module for. The entire customization took me about two minutes to complete. In fact, it took much longer to write this article.

Continue reading

#DynamicsCon March 2021 Presentation Videos Published

David Meego - Click for blog homepageThe Dynamics User Group have published the videos of the presentations from the recent DynamicsCon March 2021 event.

It was fun taking part in the conference and I really appreciated the opportunity to present for you. Thank you to the GP Community for voting for a session on GP Power Tools at the conference.

Continue reading

#GPPT: Resolved: Registration fails followed by Microsoft Dynamics GP has stopped working

David Meego - Click for blog homepageWith the release of the GP Power Tools build 28.6 hotfix, a couple of sites have reported that GP Power Tools says it is not registered and then causes Microsoft Dynamics GP to crash if you attempt to open the registration window.

[Edit] This issue is resolved permanently with the GP Power Tools build 28.7 hotfix.

The cause of the issue has been identified and a simple solution is available. We are working with the 3rd party developers involved to prevent the situation occurring in future.

Continue reading

#Dexterity Remember Multicurrency when Customizing Transaction windows

David Meego - Click for blog homepageI was asked recently to assist with some custom code that had been added to a transaction window in Microsoft Dynamics GP. The customization would work for one user, but not for a different user.

The customization was created using GP Power ToolsDeveloper Tools module, but similar code could have been created using Dexterity, Visual Studio Tools or even VBA (Visual Basic for Applications).

Continue reading

Don’t use Administrative Shares in your Dynamics GP Launch File

David Meego - Click for blog homepageI am writing this article after a good friend, who is a Microsoft Dynamics GP administrator, was having some unexplained issues in his test environment.

The issue was originally identified because GP Power ToolsProduct Version Validation feature started reporting a dictionary version mismatch for a couple of Dexterity customization dictionaries. What made it really weird was that it only happened for the test windows’ user and and not for his administrator user account.

Continue reading

#VSIT Visual Studio Integration Toolkit Build 16.2 hotfix released

David Meego - Click for blog homepageA number of fixes and enhancements have been made to Visual Studio Integration Toolkit, so along with the release of the latest GP Power Tools 28.5 hotfix, we are releasing a hotfix for Visual Studio Integration Toolkit.

It is recommended that all sites running Visual Studio Integration Toolkit install the latest code on all workstation and servers where it is currently installed.

Continue reading

#BPST Batch Posting Service Toolkit Build 11.2 hotfix released

David Meego - Click for blog homepageA number of fixes and enhancements have been made to Batch Posting Service Toolkit, so along with the release of the latest GP Power Tools 28.5 hotfix, we are releasing a hotfix for Batch Posting Service Toolkit.

It is recommended that all sites running Batch Posting Service Toolkit install the latest code on all workstation and servers where it is currently installed.

Continue reading

#GPPT GP Power Tools Build 28.5 hotfix released

David Meego - Click for blog homepageDue to many requests to be able to control the screen output window of report writer in Microsoft Dynamics GP 18.3, we are releasing a new hotfix which has this feature along with a number of other enhancements and fixes.

It is highly recommended that all sites running GP Power Tools install the latest code on all workstation and servers where Microsoft Dynamics GP is installed.

Continue reading

#GPPT GP Power Tools Build 28.4 hotfix released

David Meego - Click for blog homepageWe have had a couple more minor issues discovered with GP Power Tools, so we have released a new hotfix build last week to resolve them.

These issues will not affect all users, but it is still recommended that all sites running GP Power Tools install the latest code on all workstation and servers where Microsoft Dynamics GP is installed.

Continue reading

#GPPT Using HMTL to format Password Reset Emails

David Meego - Click for blog homepageOne of the really useful features of the Database Tools module of GP Power Tools is the ability to send Password Reset Emails to users when their passwords are reset.

These emails can be sent when updating the password manually via the User Setup window or automatically when using the Database Validation or SQL Login Maintenance windows of GP Power Tools.

Note: Build 28.3 or later is required for the functionality discussed in this article to work.

Continue reading

#GPPT Defaulting Customer ID and Vendor ID fields for new records

David Meego - Click for blog homepageThis week I received two similar requests and so I thought I would publish a couple of sample customizations which achieve the desired goals.

If you want to have a standard templates when adding Customer IDs and Vendor IDs, these two samples will provide that functionality with just a few triggers using the GP Power Tools – Developer Tools module.

Continue reading

#VBA Solving VBA (Visual Basic for Applications) Compatibility Issues

David Meego - Click for blog homepageIn recent times many Microsoft Dynamics GP sites have been having issues with VBA (Visual Basic for Applications). Especially with Microsoft Office Updates breaking functionality and incompatibilities with later Windows Server releases.

There have been compatibility issues reported with sending emails via Outlook and more recently issues with VBA on Windows Server 2019.

Continue reading

#GPPT Setting up GP Power Tools

David Meego - Click for blog homepageSo you have GP Power Tools installed on your system, how do you make sure that you are getting the most out of your subscription?

Firstly, make sure that GP Power Tools (GPPT) is installed on all workstations and servers. Everywhere the Microsoft Dynamics GP application is installed should have GP Power Tools installed.

Secondly, make sure you are running the latest build of GP Power Tools. Each build is released for the last five versions of Microsoft Dynamics GP and adds lots of new features, enhancements and fixes. Stay current to ensure you get what your subscription entitles you to. See this article for rolling out or updating GP Power Tools.

Continue reading

#GPPT Processes are currently being run Dialog when logging into Microsoft Dynamics GP

David Meego - Click for blog homepageAfter the release of build 28 of GP Power Tools, we have had a couple of reports from customer sites where users are receiving a “Processes are currently being run …” dialog when logging into Microsoft Dynamics GP.

Read on to understand what the cause is and how this can be resolved.

Continue reading

#GPPT GP Power Tools Build 28.3 hotfix released

David Meego - Click for blog homepageLast night, a GP Power Tools user reported that they were getting an error message after installing the build 28.2 hotfix release of GP Power Tools.

No matter how much testing you do, there is always some combination of factors that cause an unexpected result. Anyway, within 24 hours we have a new hotfix build available.

Continue reading