How to avoid inactive users to show up in listbox at service call that refer to employees

Maka

Hello,

I'm looking for how to hide inactive employees from list in service call below "Handled By".

I have chosen under Toolbox Configuration-Human Resources-Use Hide from List System, but this does not work.

I get anyway inactive employees in the list

Comments

3 comments

Date Votes
  • Comment author
    Geoff Booth

    Try:

    • Open the Employee Master Data window (under Human Resources)
    • Turn on the view user-defined fields (Ctrl-Shift-U) if they are not visible
    • Find the Hide From List field and set each user you want to hide to 'Yes'
    0
  • Comment author
    Maka

    Thanks for reply.

    I have also chosen that, but it only works on sales orders and outgoing invoices, but not on service calls unfortunately.

    0
  • Comment author
    Geoff Booth

    It looks like that is pulling from the Users table (OUSR).

    Likely simply add a standard Formatted Search to that field based on a user query such as:  SELECT T0.[USERID], T0.[U_NAME] FROM OUSR T0 WHERE T0.[Locked] = 'N' ORDER BY T0.[U_NAME]

    Modify your Where clause as required

    User simply clicks the magnifying glass instead of the drop down selector.

    0

Please sign in to leave a comment.