Personalized Community is here!
Quickly customize your community to find the content you seek.
Now Available in Community - New TechTalk Videos for 2021
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I am struggling while configuring security permissions for financial reports in Financial Report Designer in Dynamics 365 for Finance and Operations. I know there used to be Report Library permissions back in Management Reporter however seems like this has been taken by Microsoft in the new Financial Report Designer. The questions is how can we configure security permissions at the user level for each report? For example, a company has 10 financial reports. At the moment, the user with security access to Financial Reports can see all of these 10 reports. What I am looking after is to configure security permission such that the user should NOT see all of them.
I know that there are some security permissions at the user level but they can't control user's access to individual reports.
Please advise. Thanks!
Hi Muhammad Anas Khan,
Security is managed through D365FO not through the financial report designer anymore.
There is one exception that relates to the data people can see.
This is called unit security and works via reporting trees.
You can find some information here:
If you want to restrict access to data for some people then there might be quite some setup to do though.
Hi Muhammad ,
The financial reporting functions are available to users who have the appropriate privileges and duties assigned to them through their security roles. The following Link list these privileges and duties, together with the associated roles.
I am familiar with role-based security which can be used to configure security access in D365FO. However what I am aiming for is something else. As soon as we give "Maintain financial reports" duty to a user, the user has access to all the financial reports. The question is how can I hide some of the highlighted reports below for a particular user? Back in AX 2012 this could be achieved using Report Library permissions within Management Reporter. I need to know how can it be done in D365FO. Can we use XDS for this purpose?
Yes you can use XDS for that.
I am wondering if any one has successfully used XDS to resolve this requirement?
I have the same challenge where I want to provide self service reporting to business unit managers. I can easily restrict access using a reporting tree so that business unit managers only see data for their business unit. However there are certain reports that they do not need access to.
To achieve this I have tried putting the reports I want the business unit managers to see in one folder and used a query in XDS to limit access to this folder and this works but only if you assign the privilege of view financial reports. If you assign the generate reports privilege the users can access the report designer where they can't change any reports but they can see all the reports and generate them.
So what this means is a lot of effort to set-up and maintain security via XDS query to allow users to only view copies of reports that have previously been run for them, which defeats the purpose of self service reporting. Unless any one knows of a better solution?
Thanks in advance for any suggestion
Please check this for a solution. Hope this would help you.
Thank you for this I will check it against my set-up and see if this resolves the issue. I will let you know the outcome.
Thanks for this example you provided it works with one annoying exception. What I noticed is that the user that I have applied the restriction to, can still click on edit and launch the report designer from here they can see all folders, they can also generate reports in other folders but the good news is they see no data in these reports. However it would be really good if I the users could be blocked from launching the report designer altogether i.e not even see the new or Edit options from the financial reports form. Do you know whether this is possible?
View financial reports privilege > Review financial performance duty should only be given to the user.
Generate financial reports privilege > Generate financial reports duty should be taken away
Hope this would help you.
I will try this out and let you know.
I just tried adjusting the role as you suggested and yes this removes access to the report designer. The problem is as I suspected the user now cannot generate reports. So if I understand correctly it is not currently possible in D365 Finance to give a user access to generate financial reports and block their access to the report designer? Which is unfortunate because that is what I am trying to achieve.
Unless you have another solution?
Since you need to give generate permission but restrict them to open report designer to edit any reports, try setting Deny to the FinancialReportingEdit action menu item. I suggest you to create duplicate privilege and then modify the duplicated one and test.
yes that makes perfect sense and sounds like it should work. I will test this theory and let you know.
thank you so much for this suggestion I have set it up and tested it and it works perfectly. My test user can view and generate reports but the New and Edit options are not available so the user can not access the report designer. Success!
You're welcome! Please mark the response as a solution so that others could also find the solution right away.
Business Applications communities