Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Kathy Minnick]

I need to find the table that has a history of deductions for employees.

I need to get a finished report of employee, deduction, sum of deduction for year.

I can’t find the table that has the deduction amount for each paycheck for the year to do a sum on.

Can anyone help me? Please?

Kathy

——————————
Kathy Lees
Human Resources Assistant
Black HIlls Surgical Hospital
Rapid City SD
——————————

[Tom Franz, CPP]

Payroll transactions (including deductions transactions) are stored in the UPR30300 table. Deduction-specific transactions will have a “PYRLRTYP” of 2. The following SQL statement should get you started:

You may want to join the UPR30100 table and restrict to non-voided checks.

Hope this helps!

select EMPLOYID, PAYROLCD, sum(UPRTRXAM)

from UPR30300

where PYRLRTYP = 2

and CHEKDATE >= ‘2016-01-01’

and CHEKDATE <= ‘2016-12-31’

group by EMPLOYID, PAYROLCD

——————————
Tom Franz, CPP
Product Manager
Integrity Data
Lincoln IL
————————————————————————-

[Jeff Martin]

Hi Kathy,

Have you looked at the Reports – Payroll – Employee Lists – List by Deductions report? It does not show the transaction detail but may work if you are only looking for a total for the year.  There are not any options to change the layout but it will give you a sum of each deduction by employee.  The report can be exported to at file if you want to rearrange the layout.  You should include Inactive Employees to make you get all the deductions for the date range that you enter.

Have a happy New Year.

——————————
Jeff Martin
Director of IT
DeRosa Corporation
Wauwatosa WI
————————————————————————-

[Tommy Tastet]

You can use SmartList -> Payroll Historical Transactions -> Check Information Current Year to get all of the deduction details. You can then export to Excel to format, total, etc.     

——————————
Tommy Tastet
President
Diamond Software
Covington LA
————————————————————————-