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
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
    Posts: 475
    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
      Posts: 3353
      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
        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.