Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / List Users by Company
Small and medium business | Business Central, N...
Suggested answer

List Users by Company

(1) ShareShare
ReportReport
Posted on by Community member 10
 
I need a report listing to what company a user has access to in NAV2018. No luck with Google...
I dont have access to SQL or Designer, it must be done using NAV.
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,011 Super User 2024 Season 2 on at
    List Users by Company
    If You have any reporting tool connected to the NAV database, You could try to get data from table Access Control (2000000053). 
    I would save the time by going one by one User card and copying out to excel the given permission sets to them.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,883 Super User 2024 Season 2 on at
    List Users by Company
    It might be easier if customized, or if you have access to the development environment......
  • Community member Profile Picture
    Community member 10 on at
    List Users by Company
    Hi, that's exactly what I've been doing. Fill an Excel based on the info on the User Card, but thats time consuming and prone to errors. It's sad to know it cant be done other way.
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,883 Super User 2024 Season 2 on at
    List Users by Company
    Unfortunately, as far as I know the standard does not have this report.
    You can open the User Card and manually view the companies in the Permission Sets.
    But please note that this does not mean that the user has access to the company. For example, if the user has financial permissions but does not have Role Center permissions, an error will be prompted when opening NAV.
    If Company is blank, it means it has access to all companies.
     
    Hope this helps.
    Thanks.
    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans