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 Send Private Message
Posts: 121
Veteran Member
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 Send Private Message
Posts: 124
Veteran Member
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