Looking for a table to get most recently completed payroll date

 3 Replies
 0 Subscribed to this topic
 69 Subscribed to this forum
Sort:
Author
Messages
Jan
New Member
Posts: 0
New Member

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
Posts: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
SELECT MAX(CHECK_DATE) FROM PAYMASTR WHERE STATUS = 9
Thanks for using the LawsonGuru.com forums!
John
Carolyn Lee
Veteran Member
Posts: 53
Veteran Member
MAX(DATE_STAMP) from paymastr for status=9 will get you the last date of when the PR197 closed payroll.