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

Notifications

Announcements

No record found.

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)
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,095 Most Valuable Professional on at

    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

  • Suggested answer
    DexDev Profile Picture
    100 on at

    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.

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,095 Most Valuable Professional on at

    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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans