Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payroll tax setup for ...
Microsoft Dynamics GP (Archived)

Payroll tax setup for GP 9.0

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all, I am trying to get the payroll tax tables up and running on GP 9 but I wasn't sure where I could obtain the tables to import into GP 9.  Long story short, we had an IT person leave and then GP crashed.  I was able to install a new installation and everything is up and running, most of the data we were able to populate.  But I don't have the payroll tax tables.  How could I go about obtaining them so I can import them to GP 9?  Or is there some work-around?

Many thanks in advance for your help

A;ex

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payroll tax setup for GP 9.0

    Hi Richard, after some troubleshooting, I went ahead and did something similar to what you suggested.  Ultimately it worked and now I am able to manually enter info into the payroll tax tables.  I appreciate your help with this and wanted to provide an update to all that I did get this issue resolved.  Many thanks to all

    Alex

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payroll tax setup for GP 9.0

    Hi Richard, thanks a lot for this suggestion.  If I am unable to locate a tax table file from any of the servers I will definitely do what you suggested.  If all else fails I can try what you described and at least try to get it up and running via manually creating the table structures for SQL.

    Thanks again for your help with this.

    Alex

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Payroll tax setup for GP 9.0

    I would go to Tools->Setup->System->Payroll Tax and then Tools->Integrate->Table Import. This will tell you the table names involved. Then go to Tools->Resource Descriptions->Tables to find the SQL table names. You could then go into SSMS and look at these tables to find the structures and then create tab delimited files to use using Table Import.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payroll tax setup for GP 9.0

    Thanks Richard. We have NYS/NYC, NJ and Fed of course.  That's the thing, however.  When I go to enter manually it says code not found.  I was trying to do just that, since we weren't able to get the table import file, I figured just go in and do it manually, but that's where I am having the problem.  I went to the selection options you listed but it will not allow me to enter the actual tables since it indicates no tax codes are set up.  Is there another place that I would be able to create these codes so that I can then go in and populate the tables themselves?  It seems my issue is more that the codes don't appear to be set up rather than the actual tax tables.

    Alex

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Payroll tax setup for GP 9.0

    How many tax jurisdictions to you have to worry about? You can always manually manipulate the tables using Tools->Setup->System->Payroll Tax. Having the tax tables is just part of the issue. You have ACA and modified 1099's to worry about as well as other things.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payroll tax setup for GP 9.0

    Ok thank you Bill, your help is greatly appreciated.  Unfortunately when I joined I found out they had not maintained their product support so going to the current tax tables isn't really an option for me.  I will go ahead and post the exact GP version and maybe someone would be able to assist.

    Again, many thanks for your assistance with this

    Alex

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Payroll tax setup for GP 9.0

    Unfortunately with Microsoft Dynamics GP 9.0 has been out of service for some time.  Now I know that in Canada there have been Tax Tables published for that version in a number of years, I am not so sure about the rest of the US or elsewhere.

    If you provide the community with the exact version number from your Microsoft Dynamics >> About screen, someone may have a copy of a tax table that might work for you.

    Do you know if you are current with your Microsoft Dynamics Annual Maintenance?  If so, I would suggest that you might want to consider planning - sooner than later - a migration to a version of the software for which you can get current tax tables.

    Staying current on the Maintenance program is critical for Payroll users as that this how you ensure that you are always able to get the right data you need to operate your company successfully.

    Hope this helps - and community, if I am wrong - please post corrections.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans