Reporting off of PR82 Adjustment history with Crystal

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
BrandynB
New Member Send Private Message
Posts: 1
New Member
Need report showing, by employee, who had a PR82 Adjustment (twice for 3/31/10, twice for 6/30/10, twice for 7/03/10).
3/31/10 – PR82 would have been done twice, once removing wages and then to move those wages to new head process level.
Same for 6/30/10 and same for 7/03/10.
Need emp name, emp number, negative wages on 3/31/10 Then same info for positive wages on 3/31. Where can I get this info using Crystal reports?
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
Did you look at a PR260 and run it for adjustments only?
Deleted User
New Member Send Private Message
Posts: 0
New Member
Or PAYMASTR table
Carolyn Lee
Veteran Member Send Private Message
Posts: 53
Veteran Member
sounds like you need to join EMPLOYEE, PAYMASTR, PRTIME, PAYDEDUCTN looking for check_type=j
it'll get you a lot more fields than the pr260. the quickest to whip it up is to join the first 2 tables in the main report and link PRTIME and PAYDEDUCTN separately as subreports