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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (