Prev
Next
Forums Lawson S3 Financials

Associate an Employee with APDISTRIB table?

Sort:
You are not authorized to post a reply.
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.
        You are not authorized to post a reply.