Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Convert PR261 to easy to read format

 1 Replies
 2 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
thummel1
Veteran Member
Posts: 121
Veteran Member
2/28/2018 6: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
    Veteran Member
    Posts: 124
    Veteran Member
    3/9/2018 8: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