So Yesterday was Pi Day, or was it?


David Meego - Click for blog homepageWhile working hard yesterday I came across a post shared on the Book of Face by my friend Denni Conner. It showed the mathematic constant of π (Pi) played as a song and was an interesting approach to try and memorize the sequence of numbers.

The post said it was Pi Day because the date was 3.14 and that the celebrated time was 1:59 PM as that gave the number sequence 3.14159 which is Pi to 5 decimal places and the most that “normal” people can remember. If you can remember more digits that is great, but you are in a minority.

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

Delete or Remove Range Errors on ‘SY_Current_Activity’ table after GP 2015 R2


David Meego - Click for blog homepageMicrosoft Dynamics GP 2015 R2 added lots of new features and enhancements and fixed a number of bugs too. However, it also introduced a change that is now causing errors in some ISV’s (Independent Software Vendor) products.

I first came across this issue when preparing to release GP Power Tools build 22 and was testing the Database Validation feature on my Microsoft Dynamics GP 2016 install.

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

RW: Using the rw_TableLineString() and rw_TableLineCurrency() Report Writer functions


David Meego - Click for blog homepageWhen Microsoft Dynamics GP 9.0 was released, it included six new global functions specifically added to make life easier for ISVs (Independent Software Vendors).

These six placeholder functions were added so that Dexterity developers could trigger against them and use the functions to get their custom data on to reports without needing to create alternate reports.

Continue reading

Dexterity: Why won’t my Security operations show in Test Mode?


David Meego - Click for blog homepageI was recently assisting a fellow Dexterity developer to create scripts to automatically create all the Security Tasks and Security Roles for their ISV (Independent Software Vendor) add-on product for Microsoft Dynamics GP.

While they were checking their code in Dexterity Test mode, the security settings for their product never showed up. This was weird as the data appeared to be in the tables and worked when in Runtime mode.

Continue reading