Notifications
Announcements
No record found.
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 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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
