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’, '', '', '', '', '', '', '')
What do you need to stay on Microsoft Dynamics GP
Microsoft Dynamics GP Latest Updates
Team expansion to support Dynamics 365 CRM, new Microsoft promotions, and more in the Dexpro March Newsletter.
Learn from the pitfalls of patching and over-customization in Dynamics 365 Business Central. Discover the consequences of choosing the wrong partner and diving into customization without a proper understanding of system architecture. Find out how Dexpro Dynamics offers tailored solutions, guiding you through successful ERP implementations and avoiding costly mistakes. Contact us today to build a solid foundation for your business.
Transition from Dynamics GP to D365 Business Central, compare cloud scenarios, and more in the Dexpro February Newsletter.
Discover the ultimate guide to cloud migration for Dynamics GP. Whether you're considering migrating to Azure or making the leap to Dynamics 365 BC, our comprehensive comparison provides invaluable insights to help you make an informed choice. From cost considerations to functionality and scalability, we cover it all, ensuring you're equipped with the knowledge needed to optimize your ERP solution.
Q1 Planning for your ERP system, the cost of moving Dynamics GP to Azure, and more in the Dexpro January Newsletter.
Explore the cost considerations and steps involved in moving Dynamics GP to Microsoft Azure for enhanced flexibility and efficiency. Learn how to optimize Azure licensing, save on memory usage, and strategically plan the transition to minimize overall expenses.
Prepare for Year-End and Processing 1099s in Dynamics GP, ISV Best Prices of the Year, and more in the Dexpro December Newsletter.
Discover the outcome when a company's Dynamics GP system became burdened with expired third-party tools, unrecorded customizations, disorganized configurations, and a poorly designed chart of accounts. These challenges were rooted in problems from the initial system implementation.
