web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I capture logi...
Microsoft Dynamics GP (Archived)

How can I capture login names in Great Plains 9.0

(0) ShareShare
ReportReport
Posted on by jubith 95

I have 140 concurrent users using GP ver 9.0. 

I need to validate the users logging in to GP with an attendance system running in the office. Any user who has not marked his attendance should not be allowed to log in and use GP.

What exactly I am looking is to capture the login name at the earliest possible point during the login process.

Any help is highly appreciated.

thanks

Jubith Kariyath

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    Re: How can I capture login names in Great Plains 9.0

    Hi Jubith,

    You could set a trigger to the ACTIVITY table in the DYNAMICS DB... a new entry is created each time a user logs into GP and soon as the company is selected and confirmed, the record is created in the ACTIVITY table... with the trigger, you have all the flexibility that you want without having to modify anything on the GP client side (which could be quite complex if you start to use VBA and want to deploy this to all 140 users, unless you're using Citrix, and still the code has to be deployed into the GP client).

    I use this mechanism to send me alert when reaching a certain amount of concurrent user licenses and keep a stats about my entries. With a history table I know this way my average consumption of user licenses every day.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: How can I capture login names in Great Plains 9.0

    Hi Jubith,

    You can customize the login screen to using vba code to validate the users logging. To add the Login screen in vba

    1. Open the login window; click Ctrl+F11 to add the window in visual basic.

    2. Click shift +F11 to add the field to visual basic. Select the user name textbox or any other field you want to add

    3. Click Alt+F11 to open the visual basic editor.

    The login window will be available as WelcometoMicrosoftDynamics in the visual basic. You can write your code for validation on UserID field change and prevent user from login, if he/she is not present in attendance list.

    For further details about using vba in customization refer to posts by Mariano Gomez

    dynamicsgpblogster.blogspot.com/.../workshop-day-2-setting-up-vba-project.html

    Rubal,

    http://dynamicsgphelp.com/

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans