How to Quickly Access MR Financial Reports with the Dynamics GP Web Client
July 20, 2020
Management Reporter Web Viewer
Many Microsoft Dynamics GP users would benefit from opening specific financial reports from their home screen.
Management Reporter version CU14 and up comes with web viewer functionality.
This means that once report is generated the link to this report can be copied and distributed to users.
Click copy Link in Management Reporter Viewer.
The link will look like this:
http://servername:4712/Report.svc/report/64f321cb-24ba-45c1-9bf6-f601660b44d3/00000000-0000-0000-0000-000000000000
This is a powerful solution as it allows users to rerun those reports for specific period selected from the bottom ribbon under report options. It allows to rerun report for specific report tree unit.
The links goes to last generated version of this report. So, if last user generates this report in report designer for only one of the units all of the links will no longer offer full tree selection. To avoid this issue change the following settings for all reports:
Now we will add this link to GP navigation pane shortcuts:
For Web Client users there were issues with shortcuts so I add those links to quick links area of home page. In my client’s case they used web client and many users needed links to many reports. It can be a lot of work to copy those links for each user. So I used the following script:
//* To Review current Quicklinks for specifc user */
select * from SY08140 where userid ='Chris'
//* To Review current Quicklinks for specifc user */
delete SY08140 where userid ='Chris'
INSERT INTO DYNAMICS..SY08140 VALUES ('Chris', 1, 2, 0, 0, 0, 'Balance Sheet', ‘http://servername:4712/Report.svc/report/64f321cb-24ba-45c1-9bf6-f601660b44d3/00000000-0000-0000-0000-000000000000’, '', '', '', '', '', '', '')
INSERT INTO DYNAMICS..SY08140 VALUES ('Chris', 2, 2, 0, 0, 0, 'Income Statement', ‘http://servername:4712/Report.svc/report/87a321cb-24ba-45c1-9bf6-f601660b44d3/00000000-0000-0000-0000-000000000000’, '', '', '', '', '', '', '')
INSERT INTO DYNAMICS..SY08140 VALUES ('Chris', 3, 2, 0, 0, 0, 'Statement of Cash Flows', ‘http://servername:4712/Report.svc/report/754f321cb-24ba-45c1-9bf6-f601660b44d3/00000000-0000-0000-0000-000000000000’, '', '', '', '', '', '', '')
INSERT INTO DYNAMICS..SY08140 VALUES ('Chris', 4, 2, 0, 0, 0, 'Balance Sheet-Rolling Quarter', ‘http://servername:4712/Report.svc/report/64f341cb-34ba-45c1-9bf6-f601660b44d3/00000000-0000-0000-0000-000000000000’, '', '', '', '', '', '', '')
See why manufacturers running Business Central are adding Dynamics 365 CRM instead of Salesforce, thanks to better pricing and hands-on support from Dexpro.
Staying on Dynamics GP feels safe, but does it save you money? See the real costs and timeline advantages for moving to Business Central.
See how a healthcare technology company replaced HubSpot with Dynamics 365 Sales to centralize customer data, streamline sales, and improve visibility.
See how a global asset manager moved from Salesforce to Dynamics 365 Sales to reduce costs, improve efficiency, and modernize customer engagement.
Read ERP Software Blog’s interview with Dexpro Dynamics CEO Marlena Stark on honest sales, personal service and choosing the right ERP partner.
"Dexpro Dynamics simplified a complex Business Central and Dynamics 365 Sales setup for a medical device manufacturer, untangling two systems into one that finally works."
See how ongoing Dynamics GP support helps a manufacturing company maintain stability, reduce risk, and confidently plan its next technology move.
See how Dexpro Dynamics simplified Hely & Weber’s Business Central setup, removed integration bottlenecks, and cut future infrastructure costs by over 90%.
Learn how CEIA-USA keeps Microsoft Dynamics GP running smoothly while evaluating a future move to Dynamics 365 Business Central.
Why you should not settle for endless sales calls with people who will never touch your system. The value of meeting the architects and implementers who will build your future.
