You’re offline. This is a read only version of the page.
I have multi-company with several inactive companies. I have templates on reports which select specific companies of the remaining active companies available. The user has rights to work in each of the selected companies used in the template, but still get this System Message 6570. The KnowledgeBase article on this does not help. Any ideas?
Article ID: 871535 - Last Review: January 3, 2015 - Revision: 3.0
Sys Msg 6570 "You do not have access rights" Using a Report Template in an Multi-Company Database
View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
TechKnowledge Content
Potential Cause
This occurs when a user attempts to load a Report Template which has the Selected Companies option enabled in the ROI Company Selection tab and the user does not have VIEW rights for one or more of the selected Companies. See either Resolution 1 or Resolution 2.
Resolutions
Resolution 1 - Create a new Template with the Current Company option enabled under the ROI Selected Companies tab.
Resolution 2 - Set up VIEW rights for the user in all the Selected Companies for this Report Template.
This article was TechKnowledge Document ID: 136042
Applies to
•Microsoft Dynamics SL 2011
•Microsoft Dynamics SL 2011 Service Pack 1
•Microsoft Dynamics SL 6.5
•Microsoft Dynamics SL 6.5 Service Pack 3
•Microsoft Dynamics SL 7.0
•Microsoft Dynamics SL 7.0 Service Pack 2
•Microsoft Dynamics SL 7.0 Service Pack 3
•Microsoft Dynamics SL 7.0 Service Pack 4
*This post is locked for comments
Perfect timing for me...thank you.
For each inactive and/or non-selected companies which the user has no access will also cause this message to popup. So if you have 10 companies and 4 of them the user has access to and the Company Selection tab has the "Report per Company" checked then you will have to click "OK" 6 times before you can execute the report. That is because the user does not have access to the other 6 companies, regardless of them being selected or not. This popup message occurs when loading the template. In this case Resolution 1 does fix the problem. Change the Company Selection tab so that only the "Current Company" is selected or at least un-check the "Report per Company". Then save over top the template with these Company Selection tab settings.
Sorry that this answer comes 4 years late, but when this popup occurred on me this page showed up in my searching. I'm glad you copied the text from the knowledge base since I could not find this when I did a search there. Thank you.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (