• Search Forums
    Advanced Search
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

TSA Audit Report

 3 Replies
 0 Subscribed to this topic
 69 Subscribed to this forum
Sort:
Author
Messages
Mary Porter
New Member
Posts: 0
New Member
10/1/2012 4:31 PM
I'm trying to write an audit report for our Payroll coordinator and I need YTD Gross Wages. I can't find YTD Gross Wages in any table - do I have to sum the wages from either QUARTWAGE or PAYMASTR? And then I need to figure out how to pull wages for only when they made a TSA deduction  - if anyone has done that before I would appreciate knowing the best way to get that out.
Karen Sheridan
Veteran Member
Posts: 142
Veteran Member
New Poster
New Poster
Congrats on posting!
10/1/2012 4:50 PM
Mary,

QuartWage and QuartDed are used by the PR294. PAYDEDUCTN will show the paid deductions and the wage amount and taxable associated with that deduction at that check level.

Karen
Vijay S
Veteran Member
Posts: 174
Veteran Member
New Poster
New Poster
Congrats on posting!
10/2/2012 11:05 AM
I guess you are looking for SUM(WAGE-AMOUNT ) for an employee(do a group by employee for the particular year you are interested), It is stored in both QuartWage and QuartDed. You can write a SQL for the same.
Mary Porter
New Member
Posts: 0
New Member
10/2/2012 6:40 PM
Thank you both. We used those tables and ended up writing lots of little queries to make one big ACCESS query to get all of the data they needed in one report on one line for each employee - we'll have to get Views written before we can write it in Crystal but at least we have something to work with now.