Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Employee Lookup window displays no data for login user

Posted on by 5

Good day, 

I am using Microsoft Dynamics 2015R2. I am currently unable to view the employees in the Employee lookup in GP. I have assigned the poweruser role to user. I am still unable to view employees in the employee lookup window. 

Capture20092020.JPG

What can be the problem ?

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Employee Lookup window displays no data for login user

    Hi Ashley,

    I reread your OP and thought about the fact that you can't see the Employee records even with the POWERUSER security assigned to that user account.. If the same form returns data from the that same window by using the 'sa' user, it really means this is a data security issue at some point.  Can you please make sure the underlying SQL user was granted proper access to DYNGRP in that company database and possibly re-run the DYNGRP GRANT script against this company DB ?

    The script can be found under the GP client folder in the sub-folder 'SQL'

  • AshleyS Profile Picture
    AshleyS 5 on at
    RE: Employee Lookup window displays no data for login user

    Hi Beat,

    I made the changes as suggested and it did not resolve the problem.

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Employee Lookup window displays no data for login user

    Hi Ashley,

    This looks like a permission issue within GP for SmartList resources..

    Access to the HR / Payroll data is normally limited to people having access to HR / Payroll forms & reports in GP, which means they should be covered by the roles like "PAYROLL CLERK* " and many more related to HR.

    Check if those users do have the proper roles assigned in their GP security, and then check if the selected security roles include the SmartList objects for HR & PR

    pastedimage1603830771262v1.png

  • AshleyS Profile Picture
    AshleyS 5 on at
    RE: Employee Lookup window displays no data for login user

    No, This is the US Version being used.

    The Users are not able to view any information in the Smart List for Employees.

    Only the sa user can view the contents of the employees smart list.

  • AshleyS Profile Picture
    AshleyS 5 on at
    RE: Employee Lookup window displays no data for login user

    Good day,

    The version installed is the US version 14.00.0725

    Cannot access the Employees table under smart list listing under payroll.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Employee Lookup window displays no data for login user

    Ashley,

    By any chances do you have the Canadian Payroll module installed in your GP instance ?

    The path to access the employee maintenance in Payroll migth actually be the same, but the underlying resource dictionary is different and the smartlist security for the lookup too..

    Canadian payroll Employee Lookup security:

    pastedimage1600814175832v1.png

    US payroll Employee Maintenance Security : 

    pastedimage1600814221780v2.png

    One way to check is if you can list the Employee of the company in SmartList itself under payroll.. do you see the list populated ?

    pastedimage1600814470137v3.png

  • AshleyS Profile Picture
    AshleyS 5 on at
    RE: Employee Lookup window displays no data for login user

    The paths

    HR & Payroll -> Cards ->  Payroll -> Employee -> Employee Maintenance  -> Employee ID 

    HR & Payroll -> Cards -> Human Resources  -> Employee  -> Employee -> Employee Maintenance  -> Employee ID  

    No 3rd party application is used for security. 

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Employee Lookup window displays no data for login user

    Hi,

    Can you please be more specific ? in which GP form are you using that Employee Lookup ? Can you please provide the path ?

    Lookups are generally driven by SmartList Security.. though with the PowerUser role assigned, this shoudl be irrelevant. Maybe there is something else missing in your GP data or setup..

    Are you using any 3rd-party ISV product that might have altered the GP security ?

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

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans