Who's On?

	Membership:
	Latest: HireIQ
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5264

	People Online:
	Visitors: 300
	Members: 0
	Total: 300

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

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

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 Send Private Message

Posts: 124

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.