Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Installation and Administration
  New Posts New Posts RSS Feed - User ID's
  FAQ FAQ  Forum Search   Register Register  Login Login


User ID's

 Post Reply Post Reply
Author
Message
tbrothers View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: July 18 2008
Location: Virginia Beach
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote tbrothers Quote  Post ReplyReply Direct Link To This Post Topic: User ID's
    Posted: September 02 2008 at 9:26am

Hi,

Our GP guy just left our company and now I need to pull a list of GP user names and ID's.  Can someone tell me how?  Which table to query?

Thanks,
Terry
Regards,
Terry
Back to Top
Sponsored Links


Back to Top
SelectStar View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: June 10 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote SelectStar Quote  Post ReplyReply Direct Link To This Post Posted: September 02 2008 at 1:12pm
In the DYNAMICS database, table SY01400 is the one you are looking for.
 
To find the name of the physical tables by yourself, you can always open GP and in the menu go (assuming GP 10.0) to Microsoft Dynamics GP --> Tools --> Resource Descriptions --> Tables. From this windows, you should be able to get the physical name of any GP tables you might need.

 

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com