Share
ReportI want to generate a report detailing the SUTA rate, and State, being applied for each employee. What tables / fields are used to store this information?
*This post is locked for comments
You’re offline. This is a read only version of the page.
340
I want to generate a report detailing the SUTA rate, and State, being applied for each employee. What tables / fields are used to store this information?
*This post is locked for comments
Here is a great SUTA blog by Terry: https://community.dynamics.com/gp/b/dynamicsgp/archive/2017/01/24/everything-and-anything-you-wanted-to-know-about-suta-in-microsoft-dynamics-gp
I believe the below SQL should do the trick for you if you are just looking at setup. You would need to look at payroll transaction history to see what has actually been applied.
This joined the Pay Codes SUTA state, instead of the SUTA state listed on Employee Maint card in case they differed at all.
FUSUTXRT gives you the rate, and FUSUWLMT is the current wage limit.
Select UPR00400.EMPLOYID, UPR00400.PAYRCORD, UPR00400.PAYUNIT, UPR00400.SUTASTAT, UPR40100.FUTASUTA, UPR40100.DSCRIPTN, UPR40100.FUSUTXRT, UPR40100.FUSUWLMT, UPR40100.Stat_Tax_ID
From UPR00400 INNER JOIN UPR40100 ON UPR00400.SUTASTAT = UPR40100.FUTASUTA
Where UPR00400.INACTIVE= '0'
AND UPR00400.SBJTSUTA = '1'
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (