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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Need logged in Username
Microsoft Dynamics GP (Archived)

Need logged in Username

(0) ShareShare
ReportReport
Posted on by Community Member

Hi there, I am new to Dynamics GP. Is there a way to get the logged in username from Dynamics GP. FYI, I am using Dynamics GP 2010 and Custom report using crystal report. Need to somehow include the username to track whoever generated it. What could be the best approach. Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at

    GP does not have an integration to Active Directory which is what most reporting tools are tied to.

    Within Crystal Reports, you have a "Special Fields" area where you can pull current Active Directory user information to display on the report.

    Based on this, you could either Formula Field in Crystal Reports for this (an IF THEN ELSE for your users) or you could create a table for mapping the GP User ID to an Active Directory User ID for this information.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    That has always been a very controversial topic regarding the GP Login and Active Directory. As some experts consider that a requirement while other could see this as no added value.

    The answer relies above in Mr. Mike's post, there is currently no integration between the GP Login and Active Directory. I have came across this product, by Fast Path, which Sync GP Passwords with Active Directory and provide the desired "single sing on" target.

    Hope this helps,

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    There's also the infamous 'remember username and password' option in Dynamics GP2010!

    Leslie

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Sanju,

    I'm not sure if you want the Active Directory username or the GP Username.

    I'm not a Crystal expert but if the GP Username would work and you are using SQL queries for your reports data sources then you should be able to use the suser_name() function in the SQL query to return the user who is running the report.

    Additionally, you could add a cross reference table to link the SQL username (which GP uses) to the AD username if you needed.

    Hope this helps.

    Adam

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    In crystal report you can use special fields. 

     

     

    http://scn.sap.com/thread/2100601

     

    Cheers!

    Sanjay

  • Community Member Profile Picture
    Community Member on at

    Thanks for the answer. I got it figured by using Dynamics Global.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans