Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

I want to generate a SUTA Rate Report by employee.

Posted on by 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

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: I want to generate a SUTA Rate Report by employee.

    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

  • Suggested answer
    Chris.Hadden Profile Picture
    Chris.Hadden 726 on at
    RE: I want to generate a SUTA Rate Report by employee.

    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'

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans