Following 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.
In 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.
When 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.
I 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.
Since forever, the pundits have been preaching the demise of Great Plains Dynamics / Microsoft Dynamics GP.
When I joined Microsoft in 2001, one of the things that influenced my decision was the thinking that Dexterity (the language behind Dynamics GP) was going to die and so I decided that I would be better off inside Microsoft than continue working as an ISV (Independent Software Vendor).
Now sixteen years later in 2017 and I am back working as an ISV, and Dexterity, along with Microsoft Dynamics GP, is still going strong… despite the launch of Dynamics 365.
Time to vote.
This is the fifth in a series of blog posts where I will be highlighting Microsoft Connect product suggestions that need the community’s support. If you agree with the product suggestion, please help get as many votes as you can.
I am pleased to announce that the next build of the Batch Posting Service Toolkit for Microsoft Dynamics GP (BSPT) is now available for download.
The Batch Posting Service Toolkit provides service procedures to retrieve a list of Batch Numbers for a specified Batch Source and to post the batch for a specified Batch Source and Batch Number.
It is designed to be used to post newly integrated batches of transactions real time and can be called via Dexterity, Visual Studio Tools or as a Service Based Architecture (SBA) Web Service (for v14.0 or later).