<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

What happens when you generate a report using the Management Reporter application in Dynamics GP? Where are your reports going?  

Many people don’t realize that the Management Reporter Library is an integral and unavoidable part of the report viewer. It allows you to organize reports for electronic distribution and navigation. But here's the unavoidable part: all reports, when generated, get stored in the Management Reporter Library… Every. Single. Version.  

Yep, they're all saved—which can be a good or bad thing.

So what's really happening behind the scenes?

Folders
You store reports into folders, very similar to what you can do with report designer. But these folders, rather than being stored on a network file share are housed in the Management Reporter database located on your SQL server. The folder setup is customizable, which allows you to organize those folders into groupings that fit your needs, whether it be by organization, fiscal time frame, financial report types, etc. 

It can also be used as a repository of historical reports. The system is defaulted with a public folder which is created during the installation process. This is the only folder that, without security setup, everyone has access to publish reports and view. Administrator users are the only users with access to everything. Other users (designers, generators and viewers) will need to be given access to the other folders, not only to publish reports but to view reports as well. 

annette1

It's worth noting that by default all new reports are setup to save to the root directory of the library. Which can cause permission issues for users setup as designers and generators. 

By user, you can change the default library location to save for new reports.

To change the default report, go to tools > options.

annette2

This can be also changed in the report definition output and distribution tab once the report has been created.

annette3

Security
Just like your network directory, access to the folders in the Management Reporter database are secured. Designers and generators must be given rights to folders to publish reports. In order for your viewers to access reports they must be given permissions to the folders, or individual reports in those folders. You can pick the actions you’d like your users to be able to perform on those folders. On one end of the spectrum this could be as simple as view only, but on the other you can enable them to create and delete items in folders. This security is added on top of the unit level security that can be set up in the tree.

annette4

Versions
Every time you generate a report it goes somewhere. That somewhere is the Management Reporter Library, which is housed in the management reporter database on the SQL server.

The report library stores these versions of your financial reports. Each time it’s generated and placed in the same folder, a new copy gets stored on top of the old version. (For example, if you generate the report five times, you now have five versions of that report in the library.)

The most recent version of a given report is displayed, but you can view, rename, move and delete previous versions as well. That's good, if you want to access multiple versions. But it can be bad if you're fixing formatting errors and developing reports, you now have all the preliminary versions saved. This is where having an organized folder structure to store and manage reports will be a great help.

annette5

For more on mastering reporting capabilities with Dynamics GP Management Reporter, watch my full webinar.

learn how to manage reporting capabilities in dynamics gp management reporter

Topics

Discuss this post

Recommended posts

Agility is the ability to move quickly – to be nimble in the face of change. Agility has been a particular focus for businesses since the COVID-19 pandemic hit. Those unique circumstances and the devastating aftermath – especially for the supply chain – have only brought the need for greater agility home. In fact, in Deloitte’s 2022 Manufacturing Industry Outlook Report, researchers wrote: “Business agility can be critical for organizations seeking to operate through the turbulence from an unusually quick economic rebound—and to compete in the next growth period … as leaders look not only to defend against disruption but strengthen their offense.” What agility looks like for businesses will depend on that company’s goals, market and customer needs, but Forbes defines agility in business as the ability to make rapid changes before your competitors do – and to ensure that those changes are done the right way. In 2020, businesses had to pivot swiftly. In 2021, companies were treading water, getting comfortable with their new normal. But in 2022, businesses that have fully embraced a cloud-based foundation will have the advantage. Manufacturers and distributors need to be able to anticipate change – not just react. With Microsoft Dynamics 365 cloud solutions, businesses gain the collaboration, ease of access and timely data required for agility in today’s market.
Cloud-based ERP solutions come with a host of benefits: They’re scalable and flexible, and team members can easily access information from anywhere at any time.
To break through siloes, more companies are using process orchestration to link front- and back-end business applications and teams. Cross-functional teams that use data and technology to drive shared business outcomes have become more common, and low-code and no-code tools have quickly grown to fill gaps in applications.
Companies implement or upgrade ERP solutions to the cloud improve workflows, uncover new opportunities for growth, drive process efficiencies and free up employees’ valuable time for other critical tasks. 
The business world has gone to the cloud. But despite the need to stay ahead of disruption, remain innovative and make better decisions with real-time data, you’re stuck with your existing on-premise ERP solution and worried about a shift to the cloud.