I am off to #ReigniteGP 2017 in Gauteng, South Africa


David Meego - Click for blog homepageLast night I boarded an airplane from Perth, Western Australia heading to Johannesburg, South Africa.

When this article is published, I will be somewhere flying over the Indian Ocean with a couple more hours before landing.

I am going to the ReigniteGP 2017 conference in Gauteng, Johannesburg and will spend a week with the South African Microsoft Dynamics GP community.

Continue reading

#FabrikamDay How to quickly update the sample data to 2027


David Meego - Click for blog homepageIn case you missed it, yesterday was Fabrikam Day for the Microsoft Dynamics GP community. This was the 12th April 2017, the date that the sample company’s, Fabrikam, data is based around.

For more information about Fabrikam Day and the sample company have a look at my article from yesterday:

Continue reading

#ReigniteGP 2017 from 22 and 23 May 2017 in Gauteng, South Africa


David Meego - Click for blog homepageThanks to Pieter Cornelius (for inviting me) and the team from Braintree, I will be going to the ReigniteGP 2017 conference in Gauteng, South Africa near Johannesburg.

This first of a kind event in South Africa will bring together Microsoft Dynamics GP end-users, technical resources and partners in instructional sessions, and showcases, focusing on all versions of Dynamics GP.

Continue reading

Identifying Triggers registered against a Table


David Meego - Click for blog homepageLast week, I wrote about a situation which was causing issues with the Database Validation feature of GP Power Tools. Triggers on the ACTIVITY table that fired when records are deleted that attempt to clean up data in the company that the record is related to.

The problem is that if the current user does not have access to this company or company database does not exist or is not online, errors are generated and the code fails. This is discussed in my blog:

Continue reading

#GPPT GP Power Tools Build 22 Hotfix Released


David Meego - Click for blog homepageHi everyone out there in GP land.

Thanks for the very positive feedback I am receiving for GP Power Tools Build 22. It seems like the new features and enhancements are being appreciated by the Microsoft Dynamics GP community.

Make sure you try out Deny Based Security and Window Position Memory as these are features every Dynamics GP customer can use.

Continue reading

#GPPT Adding data from any SQL table to SOP Documents


David Meego - Click for blog homepageFollowing on from my recent article, #GPPT Adding Vendor Item Number to SOP Documents, I thought it would be worth showing how we can use GP Power Tools custom Report Writer functions with a SQL Query to obtain any data available from any table on the SQL Server.

To make this happen we are going to combine the Runtime Execute Setup custom RW function code with a SQL script created in SQL Execute Setup. Note that these techniques, which have been available since June 2009, are completely Web Client compatible which makes them even more valuable now.

Continue reading

#GPPT Adding Vendor Item Number to SOP Documents


David Meego - Click for blog homepageIn my previous post, RW: Using the rw_TableLineString() and rw_TableLineCurrency() Report Writer functions, I mentioned the six report writer functions which can be used by developers to get custom data onto reports.

GP Power Tools takes advantage of these functions to allow the creation of custom Report Writer functions. In fact, this custom report writer function feature has been available since the release of the Support Debugging Tool build 11 in June 2009.

Continue reading