Dynamics GP check history is in the UPR30100 table in the database.
This sql statement summarizes the key information in the check history table, essentially re-creating someone's W-2 information.
select * from
(
select employid, EMPLNAME, sum(grwgprn) as gross, sum(fdwgpyrn) as federalwages,sum(ficamwgp) as medicarewages, sum(ficasswp) as sswages,
sum(fdwdgprn) as federal, sum(ficamwpr) as medicare, sum(fcaswpr) as fica, sum(ntwpyrn) as net ,
sum(grwgprn)-sum(fdwdgprn)- sum(ficamwpr) - sum(fcaswpr)-sum(ttlddtns) -
(sum(totltaxs)-sum(fdwdgprn)-sum(ficamwpr) -sum(fcaswpr))
as netshouldbe, sum(totltaxs) as totaltax,
sum(totltaxs)-sum(fdwdgprn)-sum(ficamwpr) -sum(fcaswpr) as estimatedstatetax, sum(ttlddtns) as totaldeductions
from upr30100
where year(chekdate)=2017 and VOIDED=0
group by employid, EMPLNAME
) as a order by sswages desc