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
Hi in the event you need a percent, You'll need to divide the FUSUTRXRT by 1000.00. If you want the decimal number, divide the FUSUTXRT by 100000.00
Leslie
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.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156