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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Modifying fields available on Form Lookups (Employee Lookup has SSN as additional sort).

(1) ShareShare
ReportReport
Posted on by 114

Good Afternoon, 

How can I remove an additional sort field in a lookup?

A client just came to me showing an employee lookup field (Item Engineering Data form--> Design Authority) where one of the additional sorts shows Social Security Number. 

Fortunately, for this client, they just moved from Dynamics GP payroll to another Payroll solution so we were able to change all the employee SSN numbers to nines. Though I couldn't find a way to remove SSN as an additional sort on the Employee Lookup.

The client that brought it to my attention was on an older version of GP, but I checked the most recent version and still see the SSN information on non payroll forms. 

Suggestions?

Categories:
I have the same question (0)
  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,065 Most Valuable Professional on at
    RE: Modifying fields available on Form Lookups (Employee Lookup has SSN as additional sort).

    Hi Sonny

    Using GP Power Tools with a trigger on window open I have changed the button drop list menu item to a separator line and prevents it from being selected.

    It changes the View Button and the Additional Sort Button.

    I have emailed the project to you.

    We might need to do additional work to either disable Custom Sort or hide the Social Security Number and Spouse SNN fields from the custom sort.

    Regards

    David

  • Suggested answer
    DexDev Profile Picture
    100 on at
    RE: Modifying fields available on Form Lookups (Employee Lookup has SSN as additional sort).

    You can not remove additional sort field functionality, but with the help of customization you can block sorting on Social Security Number. But if your client is not using GP Payroll then they shouldn't be using this sort functionality.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,065 Most Valuable Professional on at
    RE: Modifying fields available on Form Lookups (Employee Lookup has SSN as additional sort).

    Using GP Power Tools, I have methods of hiding or encrypting fields on windows so the data cannot be seen.

    We can also obscure the data when it is "at rest" in the tables.

    https://winthropdc.wordpress.com/2022/05/25/gppt-obscuring-bank-account-numbers-in-microsoft-dynamics-gp/

    To hide the option from the menus we can just use a trigger to hide or disable the menu.

    Regards

    David

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

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 764 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 619 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 603 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans