• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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?
Deleted User
New Member Send Private Message
Posts: 0
New Member
4/26/2010 9:07 AM
Try PROTPAYPRD or PROTWRKPRD
Robert
Veteran Member Send Private Message
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.