Share
ReportNeed one report to show all EE's earnings, Deductions, Taxes EE and ER taxes too. Ok if it doesn't have ER Taxes.
You’re offline. This is a read only version of the page.
5
Need one report to show all EE's earnings, Deductions, Taxes EE and ER taxes too. Ok if it doesn't have ER Taxes.
Hello Terry,
I was able to do some further research and you would need to also use the following tables to pull the codes for Earnings, Taxes and Benefit
Benefits:
HCMBENEFIT
HCMBENEFITPLAN
Taxes
PAYROLLTAXCODE
Earnings:
PAYROLLEARNINGCODE
There are two fields in the PAYROLLPAYSTATEMENTLINE that you can use to determine if a Benefit is Employee or Employee and to determine if a Tax is EE or ER. They are ISEMPLOYER for benefits and ISEMPLOYERTAX. Hope this helps.
Brad
Hello Terry,
I understand that you are looking for a report that shows all the payroll codes summary. There is no report that exists like this currently, the best option would be to create your own report. You could use the following tables to start building your report.
PAYROLLPAYSTATEMENT
PAYROLLPAYSTATEMENTLINE
This would give you the Gross and Net for each pay statement and the payroll code break down, You could do some sort of sum on this report to get what you are looking for. All these items come from different reports in the system.
Thanks,
Brad
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,017
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
All responses (
Answers (
