web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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.
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,331 Super User 2025 Season 2 on at
    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
  • Community member Profile Picture
    Community member 10 on at
    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 95,331 Super User 2025 Season 2 on at
    It might be easier if customized, or if you have access to the development environment......
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,764 Super User 2025 Season 2 on at
    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans