PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 5/11/2015 2:00 PM by  jaherb
paycheck dates
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Chesca
Programmer/analyst
State
Veteran Member
(1042 points)
Veteran Member
Posts:490


Send Message:

--
5/8/2015 7:16 PM

    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
    Private
    Private
    Veteran Member
    (1434 points)
    Veteran Member
    Posts:538


    Send Message:

    --
    5/8/2015 7:22 PM
    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
    Private
    Private
    Senior Member
    (9893 points)
    Senior Member
    Posts:3315


    Send Message:

    --
    5/10/2015 10:30 PM
    You can look at these and see if they help. PROVERTIME
    PROTPAYPRD
    PROTWRKPRD
    Thanks for using the LawsonGuru.com forums!
    John
    jaherb
    Independent
    Independent
    Veteran Member
    (472 points)
    Veteran Member
    Posts:164


    Send Message:

    --
    5/11/2015 2:00 PM
    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.