paycheck dates

Sort:
You are not authorized to post a reply.
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member

    We have a custom program that I want to change to minimize data entry. Currently the user has to enter pay period start date, pay period end date, pay check dates ,etc. I want them to enter just the pay period end date and my program should lookup the pay check date. Does anybody know what files paycheck dates? 

    Margie Gyurisin
    Veteran Member
    Posts: 538
    Veteran Member
      I don't believe there is a file with future paycheck dates. Once the payment is closed, it is in PRCHECK and it seems as if one other but off the top of my head I can't remember. In our company, for a regular payroll, the check date is usually 5 days after the pay end but for one affiliate, that changes if a holiday interferes.
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
        You can look at these and see if they help. PROVERTIME
        PROTPAYPRD
        PROTWRKPRD
        Thanks for using the LawsonGuru.com forums!
        John
        jaherb
        Veteran Member
        Posts: 164
        Veteran Member
          There is not a file that contains "pay check dates" as that date could be any day. When I have had to do things like this I have used the PROTPAYPRD table.

          If you wanted to use this table, you could supply your Period End Date on the submission form and then match up on the Period End Date. You could then pull in any "Check Date" between those two dates.

          You could also have your program calculate the begin date from the date on the submission form if you pay periods are consistent. We are paid bi-weekly, so if they entered a Period End Date of 05/09/15. I would then use the API 900-INCREMENT-DATE and go back two weeks to get the period start date. Once you get the start date.... I would validate against this table making sure I had a good period date especially since the date is being manually entered an no guarantee the date is actually an Period End Date.

          In some cases, I have even added logic in the 050- paragraph to validate this date there and display a message on the form if it is not a valid date and stop them from submitting the job.
          You are not authorized to post a reply.