Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Pay Period Dates

 4 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
TommyT
Veteran Member
Posts: 58
Veteran Member
4/23/2010 7:59 PM
    I need to come up with the first pay date following a variable date. Does anyone know what table the pay period beginning and ending dates are stored in?
    Shane Jones
    Veteran Member
    Posts: 460
    Veteran Member
    4/24/2010 1:33 AM
      PAYMASTR... This would have both the check date and period end dates. However, this would be the history of pay and not future pay dates. (You would need to calculate the period begin dates.)

      ** Additional note/follow up: we do not do adjustments any date payroll wants we date them so that I could look for any paycheck falling on a Friday. If it is a Friday check then it is a regular payroll. (we only have bi-weekly payroll - crystal and java have day of week formulas/functions.)
      Shane Jones
      Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
      Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
      ** Teach others to fish...
      TommyT
      Veteran Member
      Posts: 58
      Veteran Member
      4/24/2010 7:38 PM
        But couldnt a manual check throw that off? Isnt there a setup table with the beginning and ending dates?
        stephanie
        Veteran Member
        Posts: 330
        Veteran Member
        4/26/2010 9:07 AM
          Try PROTPAYPRD or PROTWRKPRD
          Robert
          Veteran Member
          Posts: 82
          Veteran Member
          4/27/2010 4:15 PM
            Tommy:

            I just went through this. I used the Date & Time Processing 4GL APIs in combination with run dates and override dates to identify beginning and ending date buckets.