Share
ReportHello,
Is there way to get Drillback url for "Sales All-in-one View" window ? I wanted to open this window from external source while GP is open.
Thanks
Bharat
Categories:
You’re offline. This is a read only version of the page.
150
Hello,
Is there way to get Drillback url for "Sales All-in-one View" window ? I wanted to open this window from external source while GP is open.
Thanks
Bharat
Why don't you use VSTools to open this window from your external application?
Using a dexsql.log, when I pull up this 'Transaction By Customers' window, and click Redisplay which fills in data to this window, the script showing in the log file is this:
SELECT RMS.DOCNUMBR, RMS.CHEKNMBR, RMS.RMDTYPAL, TRXDSCRN, DUEDATE, RMS.DOCDATE, ORTRXAMT, CURTRXAM, DISTKNAM, WROFAMNT, DCSTATUS, RMS.CUSTNMBR , BACHNUMB, RMS.BCHSOURC, RMS.TRXSORCE, VOIDSTTS , CURNCYID,0 CURRNIDX, CORRCTN, SIMPLIFD,0 FUNCORTRXAMT FROM RM20101 RMS INNER JOIN RM00401 ON RM00401.DOCNUMBR = RMS.DOCNUMBR AND RM00401.RMDTYPAL = RMS.RMDTYPAL and RM00401.DCSTATUS = 2 union SELECT RMS.DOCNUMBR, RMS.CHEKNMBR, RMS.RMDTYPAL, DOCDESCR, DUEDATE, RMS.DOCDATE, DOCAMNT, ACCTAMNT, DISTKNAM, WROFAMNT, DCSTATUS , RMS.CUSTNMBR, BACHNUMB, RMS.BCHSOURC, TRXSORCE, 0 VOIDSTTS, CURNCYID,0 CURRNIDX, CORRCTN, SIMPLIFD,0 FUNCORTRXAMT FROM RM10301 RMS INNER JOIN RM00401 ON RM00401.DOCNUMBR = RMS.DOCNUMBR AND RM00401.RMDTYPAL = RMS.RMDTYPAL and RM00401.DCSTATUS = 1 union SELECT RMS.DOCNUMBR, RMS.CHEKNMBR, RMS.RMDTYPAL, TRXDSCRN,0 DUEDATE, RMS.DOCDATE, RMS.ORTRXAMT, RMS.CURTRXAM, DISTKNAM, WROFAMNT, DCSTATUS , RMS.CUSTNMBR, BACHNUMB, RMS.BCHSOURC, TRXSORCE, 0 VOIDSTTS, CURNCYID,0 CURRNIDX,0 CORRCTN,0 SIMPLIFD,0 FUNCORTRXAMT FROM RM10201 RMS INNER JOIN RM00401 ON RM00401.DOCNUMBR = RMS.DOCNUMBR AND RM00401.RMDTYPAL = RMS.RMDTYPAL and RM00401.DCSTATUS = 1 and RMS.RMDTYPAL = 9 union SELECT RMS.DOCNUMBR, RMS.CHEKNMBR, RMS.RMDTYPAL, TRXDSCRN, DUEDATE, RMS.DOCDATE, ORTRXAMT, CURTRXAM, DISTKNAM, WROFAMNT, DCSTATUS, RMS.CUSTNMBR, BACHNUMB, RMS.BCHSOURC , RMS.TRXSORCE, VOIDSTTS, CURNCYID,0 CURRNIDX, CORRCTN, SIMPLIFD,0 FUNCORTRXAMT FROM RM30101 RMS INNER JOIN RM00401 ON RM00401.DOCNUMBR = RMS.DOCNUMBR AND RM00401.RMDTYPAL = RMS.RMDTYPAL and RM00401.DCSTATUS = 3 ORDER BY RMS.RMDTYPAL ASC ,RMS.DOCNUMBR ASC
If you run this against your company database, you'll see pretty much the information this window is displaying.
Depending on what you want to see, you could modify this SELECT script and make a SQL View out of it, then use that view to create a report, such as a SmartList report, etc.
A dexsql.log is the easiest way to find out what a window or report is pulling data from and how. Sometimes it is populating temp objects (that begin with ##) with data via a SELECT script like above, other times it may be a stored procedure running, which we discussed previously.
Thanks
I'm pretty sure I've had a question like this before and we weren't able to find any type of URL that you can use.
For the links, such as dgpp:// , we usually store those into a GP table, such as for SSRS or Workflow, but when looking at the Sales All-In-One view, it's mainly using temp objects to pull data, then it uses procedures, such as rmGetSalesQuotes, rmGetSalesOrders, rmGetSalesInvoices, etc., from the company database, to pull that data into the temp objects to display as needed.
There isn't any type of URL that could be used from these views, it just seems to be pulling data and putting it into the window/form in Dynamics GP.
Thanks
I know I've had this question below and there isn't any type of URL used with the All-In-One views that you could use externally to show that information.
Have you looked at using OData or something along those lines? With OData, you can create custom views, publish them to OData via Dynamics GP, then use the URL to show the data in Excel or Power BI, for examples.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (