web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums 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) Share

Report

Report

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)

All responses Img

All responses (4)

Answers Img

Answers (0)

KasparsSemjonovs 4,659 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,053 Super User 2025 Season 2 on at

Like (0)

Report

List Users by Company

It might be easier if customized, or if you have access to the development environment......

Was this reply helpful? Yes No
Community member 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,053 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

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

#1

Nimsara Jayathilaka. 3,864

#2

Rishabh Kanaskar 3,185

#3

Sumit Singh 2,850

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans