You’re offline. This is a read only version of the page.
In the GP Web Client, if you have Word Templates Enabled, it defaults ALL reports to TEMPLATE in the report destination window. I want to do a simple customization that will check to see the Template Configuration Setup tables each time the Report Destination window is loaded in GP and set the Report Type to Standard or Template based on whether the Word Template is set as the Default. It would look something like below. Its just the basic logic(obviously the syntax is not good but you get the picture) but the query is good. My question is: Could I do this in Dexterity? Do I have to be a partner to have access to the Code on the various Events on the Report Destination Window? What are my options keeping in mind that this is a Dynamics GP 2013 R2 Web Client scenario and VBA is not an option.
Declare TempID
TempID = TemplateIDFrom ReportDestinationWindow
Select * from DYNAMICS.dbo.SY20000 a
inner join DYNAMICS.dbo.SY20020 b on a.TemplateID = b.TemplateID
where CMPANYID = 3 and a.TemplateID = TempID and IsDefault = 1
IF EndOfFile then
Set ReprtType = Standard
Else
Set ReportType = Template
End If
Thanks!
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
2
