Prev
Next
Forums Financial Management Lawson S3 Financials

Associate an Employee with APDISTRIB table?

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Bidur
New Member
Posts: 2
New Member
9/28/2010 6:31 PM
    I am trying to figure out how to relate an Employee with APDISTRIB Table or AP Transactions.
    Any input will be appreciated!

    Thanks.
    Bidur
    New Member
    Posts: 2
    New Member
    9/28/2010 7:59 PM
      I think this works:

      SELECT VENDOR FROM APVENMAST WHERE VEN_CLASS = 'EMP'

      Then join APVENMAST.VENDOR = EMPLOYEE.EMPLOYEE
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      9/29/2010 2:10 PM
        You can do this by joining the prdistrib with the gltrans and then the gltrans to the apdistrib. The employee id is a field on the prdistrib and the payroll distributions for an employee flow into prdistrib.