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

Maka

• 13 de febrero de 2024 11:16

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

Vote

1

• 

  Geoff Booth

  • 14 de febrero de 2024 14:42

  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'
• 

  Maka

  • 15 de febrero de 2024 12:27

  Thanks for reply.

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

  Geoff Booth

  • 16 de febrero de 2024 20:26

  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.

Iniciar sesión para dejar un comentario.