Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

W2 and W3 Information

Posted on by 215

I am training to edit a employee's social security tax amount field in edit w2 window and getting error message" social security tax withholding can't exceed the social security tax withholding limit of $4,485.60. Which amount to be $72,348.38, and way under the limit.  Also when I edited the field for other employees social security tax information the changes does not reflact in W3 form. Please someone can help with this issue. Thank you very much.

 

*This post is locked for comments

  • kwj3 Profile Picture
    kwj3 682 on at
    Re: W2 and W3 Information

    michael -- summary info is not listed in UPR10100.  i did NOT re-create year end -- just did the SQL fix.  perhaps i should run the year end again... customer is able to print w-2's correctly now.. just not the w-3

  • Re: W2 and W3 Information

    Hi Ken,

    I didn't have any trouble with my summary information...Just the W2s themselves.  Remember that there is a cap on the SS W/H so you need to take that into account.  I would be very cautious about updating the summary information.  Check out table UPR10100.

  • kwj3 Profile Picture
    kwj3 682 on at
    Re: W2 and W3 Information

    this fix worked -- but the w-3 summary amounts are still incorrect.  i can't figure out which table to update the summary amount of SS.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: W2 and W3 Information

    Change your system date to 12/31/10

    change your Social Security rate back to 6.2%

    then rerun the year end wage file

    run your W-2s

    change the system date to 01/01/11 and change the Social Security rate back to 4.2%

    .... close GP and reopen to reset the system back to today's date

  • Re: W2 and W3 Information

    Sandip,

    If you recreate your year end wage file after you apply the 2011 tax update, you must first change the Social Security rate back to 6.2% otherwise you will have problems with your W2s

    Thanks,

    Mike

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: W2 and W3 Information

    rmckay875,

    Can we recreate year End wage file after applied 2011 Tax ?

    Thanks

    Sandip

  • Suggested answer
    Re: W2 and W3 Information

    The solution from rmckay875 is probably the best/safest way of fixing things however you will lose any edits that you have done in the Edit W2 window if you go that route.  If you're comfortable with SQL, I have found another work around for this issue:

    USE TWO (or whatever your database name is)

    UPDATE UPR10100

    SET FICASSTR=620000

    WHERE RPTNGYR=2010

    Keep in mind this is NOT supported by Microsoft since you are modifying data through SQL statement rather than through the front end.  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: W2 and W3 Information

    1.  change your system date to 12/31/10

    2.  change the Social Security rate back to 6.2%

    3.  recreated your year end wage file

    4.  print the W-2s to the screen to check the amounts

    I just did this and it worked for me.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: W2 and W3 Information

    I am having the same problem.  I have tried to go back and change the Social Secuirty withholding rate back to 6.2%, but that doesn't help.  PLEASE HELP !!!

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans