Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

Payroll extracts to vendors

Sort:
You are not authorized to post a reply.
Author
Messages
Karen Sheridan
Veteran Member
Posts: 141
Veteran Member
4/10/2012 2:46 PM
    We have several extracts mostly against deductions, example 403(b) deductions.

    We have been using check date on the pay master table to drive the record selection, but we are finding that doesn't pick up an manuals or voids that are also processed during that payroll run.

    There is a date stamp on those records that corresponds to the most recent PR140 run.  So that might be an option.

    But, I thought I'd ask what other companies are doing.  Basically, how to pull all deductions/activity from a payroll run that include manuals and voids.


    Thanks,
    Karen
    BarbR
    Veteran Member
    Posts: 306
    Veteran Member
    4/10/2012 4:54 PM
      We are using the date_stamp on the paymastr table after the payroll is closed.
      Example: Select what-you-want from prod.paydeductn pyd, prod.employee emp, prod.paymastr pay where (pyd.company = emp.company and pyd.employee = emp.employee) and (pyd.company = pay.company and pyd.employee = pay.employee and pyd.check_id = pay.check_id) and pyd.company=1000 and (pay.date_stamp >= 'start date variable' and pay.date_stamp <= 'end date variable')

      The start date is the day after the last payroll close, and the end date is the date of the payroll close - this picks up all activity for the bi-weekly period (HR does manual checks etc. daily but only closes after the bi-weekly payroll).
      You are not authorized to post a reply.