I 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.
For 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:
It is time to post the solution to the Cookies, Bananas and Clocks algebra maths puzzle that was posted last month.
If you have not had a go at solving this puzzle and registering your answer on the poll; Stop reading the solution, click on the link above and go do it now. 🙂
Here 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.
I 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.
It is time to post the solution to the Tables, Baskets and Shirts algebra maths puzzle that was posted earlier this month.
If you have not had a go at solving this puzzle and registering your answer on the poll; Stop reading the solution, click on the link above and go do it now. 🙂
I have found yet another numeric picture maths puzzle to inflict upon you. This one makes me think it is time for some food.
Standard warning: It does require a close look at the image to get the correct answer and don’t forget order of operations.
This 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.
I have found another numeric picture maths puzzle to inflict upon you. I do think that the table should have been an ironing board to keep the laundry theme.
Standard warning: It does require a close look at the image to get the correct answer and don’t forget order of operations.
This 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.
I 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.
Happy Star Wars Day 2021 everyone.
This year we have a treat for you. One of the tourism organisations who promote the South West corner of Western Australia has created a fantastic promotional video to celebrate the region with a definite Star Wars flavour.
May the Fourth Be With You …. Always (or at least until midnight).
Over 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.
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.
Today, 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.
Captain’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.
The 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.
With 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.
I 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.
The 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).
