web

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

News and Announcements icon

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)

Suggested answer

YUN ZHU 98,337 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Community member 10 on at

Like (0)

Report
Copy link

Link copied!

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 98,337 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
KasparsSemjonovs 4,817 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,986 Super User 2026 Season 1

#2

YUN ZHU 1,071 Super User 2026 Season 1

#3

Dhiren Nagar 975 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans