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.
Isn’t YouTube a wonderful time waster. I came across an awesome Star Wars fan film that I just had to share….
Star Wars: Downunder is a 30 minute Star Wars fan film which finally answers the age old question, that has confounded many a film buff before: What would happen if you crossed Star Wars with an Australian beer commercial.
Answer? Star Wars Downunder: an epic tale of the good, the bad and the thirsty. Directed by Michael Cox and written by Bryan Meakin and Michael Cox, Star Wars Downunder, is half an hour of action, special effects and lovable Aussie larakins
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.
After months of work, I am extremely excited to announce that GP Power Tools for Microsoft Dynamics GP (GPPT) Build 22 is now available for download. Please update your systems to get all the new features.
GP Power Tools was previously known as Support Debugging Tool (SDT), which was discontinued in October 2014. If you are still using the previous product, please upgrade to the supported and much better GP Power Tools product.
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.
A while ago, I introduced you to James Veitch. I very talented comedian geek who loves to have fun with spammers. Here is the link for the previous post:
If you have not watched it yet, please do and then watch one in this post.