Supervisor direct report list

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
khart
Advanced Member
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
    Posts: 3353
      You get it in a round-about way based on EMPLOYEE and HRSUPER
      Thanks for using the LawsonGuru.com forums!
      John
      John Henley
      Posts: 3353

        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
        Posts: 25
        Advanced Member

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