web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Generate List of Users...

Microsoft Dynamics GP (Archived)

Generate List of Users per Company in GP 10

(0) Share

Report

Report

Posted on by Community Member

Is there a way to get a list of all users in GP 10 and the companies they have access to exported to a file? I can get all the users using a SQL query, but I also need to have the company break down as well. Thank you

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Mahmoud Saadi 32,738 on at

Like (2)

Report
Copy link

Link copied!

Check this out SQL view to show security roles and tasks in Dynamics GP by Victoria Yudin

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,061 Moderator on at

Like (1)

Report
Copy link

Link copied!

Also, if you own eOne's SmartList builder, you can grab a set a of reports to import into SmartList here from a fellow GP blogger :

waqasb.blogspot.ca/.../dynamics-gp-security-smart-lists.html

This will allow you to generate quickly some reports in GP without relying on SQL views / queries, if you don't have access to those tools.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans