• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Looking for a table to get most recently completed payroll date

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
2/10/2009 7:35 PM

I'm looking for a Lawson table that will tell me the date of the most recent completed payroll.  In the Lawson ERD, I've seen a reference to a PRMONITOR table which looks like what I want, but I can't find that in my 8.03 system.  I'm connecting to the Lawson database via an MS Access ODBC connection.

I'm pretty sure I have wide open access to all the 8.03 tables so I'm curious why I can't find the PRMONITOR table.

Any ideas on why I can't find it?  Or, alternatively, are there any other tables I can query against to find the date of the most recently completed payroll?

thanks

Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
2/10/2009 7:54 PM
I do see PRMONITOR on 8.1 apps - but no date field. Just a bunch of flags to show PR140 has been run etc.

How about

max(per_end_date) from PAYMASTR

or

relate PAYMASTR to PRSYSTEM using last_chk_ID and getting the per_end_Date
John Henley
Send Private Message
Posts: 3351
2/10/2009 7:58 PM
SELECT MAX(CHECK_DATE) FROM PAYMASTR WHERE STATUS = 9
Thanks for using the LawsonGuru.com forums!
John
Carolyn Lee
Veteran Member Send Private Message
Posts: 53
Veteran Member
2/10/2009 9:03 PM
MAX(DATE_STAMP) from paymastr for status=9 will get you the last date of when the PR197 closed payroll.