Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

TSA Audit Report

Sort:
You are not authorized to post a reply.
Author
Messages
Mary Porter
Veteran Member
Posts: 337
Veteran 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: 141
    Veteran Member
    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
      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
        Veteran Member
        Posts: 337
        Veteran 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.
          You are not authorized to post a reply.