• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.