#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

Black Boxes and Microsoft Dynamics GP Report Writer Reports

David Meego - Click for blog homepageOver the last week, there has been a Microsoft security update released via Windows Update which is causing graphics on Microsoft Dynamics GP Report Writer reports to show as black boxes.

The Microsoft Dynamics GP support team is aware of the issue and is working to find a resolution. The current work around is to roll back the Windows Updates that caused the issue and pause updates to prevent them from being installed again.

[Edit] 20-Mar-2021: The Windows team have released a fix for this issue, it look’s like it needs to be installed manually. Please see the updates on both the articles from the Dynamics GP Support team and from Beat Bucher (links below).

Continue reading

#DUG Dynamics User Group, DynamicsCon and Microsoft Dynamics GP

David Meego - Click for blog homepageThe Dynamics User Group, the team behind DynamicsCon, are making a huge effort to bring the Microsoft Dynamics GP community into their fold.

Not only is there Dynamics GP content in the DynamicsCon conference coming up on March 16-21 2021, including a session presented by yours truly on GP Power Tools, but now there is a Dynamics GP section and GP forums active on their site.

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

Last Chance: Vote for the GP session submissions for the DynamicsCon virtual conference

David Meego - Click for blog homepageVoting for the session submissions for the DynamicsCon virtual Conference closes om Friday 22nd January 2021 at 11:59 PM (US EST).

Please register for the conference and cast your 18 votes against the sessions you want to see presented. Not that I am biased, but please consider voting for some (or all) of the sessions I submitted.

Continue reading