Supervisor direct report list

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
khart
Advanced Member Send Private Message
Posts: 25
Advanced Member

  Is there a table or file that contains the list of people who work under a supervisor in Lawson?  I'm trying to use PF to send a list of people working under a supervisor.  Thanks!  Merry Christmas

John Henley
Send Private Message
Posts: 3351
You get it in a round-about way based on EMPLOYEE and HRSUPER
Thanks for using the LawsonGuru.com forums!
John
John Henley
Send Private Message
Posts: 3351

I went back and looked up some of my notes on this, and how I implemented it for one client was to use a recursive SQL procedure that, given an employee number, would report all employees who worked for that employee, down each level of the supervisor hierarchy:

Thanks for using the LawsonGuru.com forums!
John
khart
Advanced Member Send Private Message
Posts: 25
Advanced Member

  Thanks for the tip, i ended up doing something similar to get the results.