#GPPT GP Power Tools Build 28.8 hotfix released

David Meego - Click for blog homepageI had not planned on another hotfix for build 28 of GP Power Tools, but I had some fantastic enhancements that I wanted to get into the product and released to the users so they can use the improved development capabilities and functionality.

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

Friday Funny: What’s the solution to 12 / 2 (5 – 2)?

David Meego - Click for blog homepageFor this week’s Friday Funny we are going to see how people interpret the Order of Operations rules that they should have been taught at school. Most people know a mnemonic to help remember the basic rules, the actual mnemonic depends on whether you say Brackets or Parentheses, whether you say Indices, Exponents or Orders, and whether you put Multiplication or Division next.

Regardless of which terminology and mnemonic you use, they do not cover all situations as the following example demonstrates:

Continue reading

#GPPT Best Practices for Programmatically Updating Fields on Windows

David Meego - Click for blog homepageHere is another simple customization I thought it would be worth publishing because it allows us to discuss some best practices and also show some cool techniques.

I received an email from a user who wanted to use GP Power Tools to replace some VBA (Visual Basic for Applications) code using GP Power Tools. They wanted to update a SOP (Sales Order Processing) Sales Transaction Entry User Defined Field based automatically but the code they had developed was not working.

Continue reading

#GPPT Forcing Exclusive Use of Microsoft Dynamics GP Windows

David Meego - Click for blog homepageI was recently informed of an issue that a Microsoft Dynamics GP customer site was facing where having more than one user in a particular window at the same time was causing issues.

While the issue has been logged with Microsoft Support, the fix will not be available for a while, so I was asked how easy would it be to force the window to only work exclusively for a single user at a time using GP Power Tools.

The answer…. very easy …. initially.

Continue reading

#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

Friday Funny: Marques Brownlee – The Best Mac I’ve Reviewed

David Meego - Click for blog homepage

Yesterday was the First of April and I have been so busy working on preparing my house for sale (we will be moving later this year) that I did not get an April Fool’s blog article out.

So this Friday Funny will have to do. Marques Brownlee (aka MKBHD) is a YouTube tech reviewer who often reviews phones and computers. Unlike my other favourite channel, Linus Tech Tips, Marques is very Apple focused.

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

Friday Funny: Enterprise Automation circa 1993 (Stardate 46880.9)

David Meego - Click for blog homepageCaptain’s Log: Stardate 74698.4. The automated and mysterious algorithm that controls the video recommendations for the interconnected web for information on my home planet of Earth, resurfaced a very amusing production for the promotion and purpose of selling a computerised Enterprise automation system.

The system is primitive for today’s standards, where I could just ask the computer to perform a level 1 diagnostic, but was very advanced for the era it was created in. In the interest of sharing galactic knowledge with all sentient species, especially those who have already achieved warp speed travel and are eligible to join the Federation of Planets, I will include the broadcast below.

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

Friday Funny: Tom Scott – The Worst Typo I Ever Made

David Meego - Click for blog homepageI came across this great video by one of my favourite YouTubers, Tom Scott, recently and thought I would share it with you. Tom’s videos are well researched, interesting and presented with a good sense of humour.

This one is specifically about an incident where he made a typo while working on a SQL database and his advice about how everything went wrong and how to ensure it does not in future is worth listening to.

Continue reading

#DynamicCon 2021 Virtual Conference starts today

David Meego - Click for blog homepageThe DynamicsCon 2021 Virtual Conference starts today (it is already Tuesday for me in Perth, Australia). The free three day conference runs from Tuesday 16th March to Thursday 18th March 2021 (USEST).

Make sure you are registered for the conference and also planning to attend my “Leveraging GP Power Tools as a Consultant” session on Thursday 18th March at 11:00 am (USEST).

Continue reading