#MSDynGP Purchase Order Entry windows show costs as zero

David Meego - Click for blog homepageOver the last few weeks I have been asked about the same issue a few times by different customers and partners who were unable to work out what was happening.

So, I thought I would write an article that explains the problem and the solution and hopefully, it will show up when someone does a search when they have this issue.

Continue reading

#GPPT Setting up GP Power Tools in a Development Environment

David Meego - Click for blog homepageI was recently asked by my good friend and fellow MVP, Jen Kuntz, about how to best get GP Power Tools running in a Development Environment.

GP Power Tools (GPPT) stores all of its settings and data in tables in the System Database on SQL Server, however, it writes all of its logs and saved files to a shared logging folder. When moving GP to a development environment, you would probably want to change this logging folder to a different location.

Continue reading

#DynamicsCon Vote for Session: Microsoft Dynamics GP Development – Choosing the Right Tool

David Meego - Click for blog homepageThe next installment of DynamicsCon conference is scheduled for 20th to 23rd September 2021. The session submission period is over and now we enter the session voting period until 28th July.

During this voting period all registered attendees have 12 votes to apply to sessions as they wish, then the votes will be tallied and the final session lists published. See this explanation for more details of the process.

Continue reading

#DynamicsCon Vote for Session: What Does It Take To Add MVP After Your Name?

David Meego - Click for blog homepageThe next installment of DynamicsCon conference is scheduled for 20th to 23rd September 2021. The session submission period is over and now we enter the session voting period until 28th July.

During this voting period all registered attendees have 12 votes to apply to sessions as they wish, then the votes will be tallied and the final session lists published. See this explanation for more details of the process.

Continue reading

#MSDynGP It’s official: Microsoft Dynamics GP is here to stay

David Meego - Click for blog homepageOver the last few weeks I have been chatting with Terry Heley on the Microsoft Dynamics GP Support team. She was been working really hard on getting the Lifecycle information for Microsoft Dynamics GP updated to reflect Microsoft’s ongoing commitment to the Dynamics GP product.

Regardless of of the sales hype and disinformation you might hear from other sources who want to spread FUD (Fear, Uncertainty and Doubt), Microsoft Dynamics GP is not going away any time soon and the product lifecycle information has been updated to show this.

Continue reading

#GPPT Modifying Reports based on Temporary Tables

David Meego - Click for blog homepageThe recent Build 28.8 hotfix of GP Power Tools incorporated some Developer Tools module changes to enable so very cool customization options for updating reports based on temporary tables. The big feature enhancement is the ability to store a Table Reference as a Memory parameter.

References in Dexterity are like pointers to a particular resource, so the Table Reference allows access to the particular instance table buffer without needing to pass the table as a parameter to a script.

Continue reading

#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