PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/09/2018 3:22 PM by  Jason Beard
Convert PR261 to easy to read format
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(195 points)
Veteran Member
Posts:107


Send Message:

--
02/28/2018 1:49 PM
    Has anyone had the need to replicate the PR261 report but in LBI, with the goal of being to be able to read it in a simple format, export to Excel, and run any necessary calculations against the fields for auditing purposes? Our payroll department uses this report to ensure the taxable wages are appearing correctly, but the format is not ideal for auditing purposes. Payroll has requested a format that would display one row per employee, with each deduction code appearing in it's own column with the value underneath.

    My thoughts are if anyone has created anything like this that I could peek at the SQL code or view a Crystal template? Thanks for your assistance!
    Jason Beard
    Private
    Private
    Veteran Member
    (300 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    03/09/2018 3:22 PM
    I've not done it... but the key tables you are going to be interested in are PAYMASTR,PRTIME,PAYDEDUCTN
    Paymastr is the "driver file" for an individual payment
    Prtime contains the earnings records (details on the earning codes are in PRPAYCODE
    Paydeductn contains the deductions (detains on the deduction codes are in DEDCODE

    You can link between the 3 with company, employee,check_id

    Hope this helps.
    Jason Beard
    617-548-5568
    jabeard3@gmail.com
    You are not authorized to post a reply.