web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) what table holds state...

Microsoft Dynamics GP (Archived)

what table holds state income taxes?

(0) Share

Report

Report

Posted on by Community Member

what table holds state income taxes?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (10)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

For example, if I made 10,000 this month and I live in Georgia.. how much taxes do I pay and where am I pulling them from?

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (1)

Report

Hi,

State income taxes is located in the UPR30300 table.

PAYROLCD = The State

UPRTRXAM = State income tax withheld

TXBLWAGS = State taxable wages

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

Terry R Heley Microsoft Employee on at

Like (1)

Report

Hi,

Leslie is correct we store paid taxes in the UPR30300 detail by check and in the UPR30301 table summary by month.

Where we pull information to have it calculate, we annualize all our tax calculations, here is my blog around this and links to a KB that walks you through how to calculate federal tax as an example, but you can then apply that to Georgia.

blogs.msdn.microsoft.com/.../how-to-verify-microsoft-dynamics-gp-is-calculating-payroll-taxes-correctly

Georgia's would

subtract dependent exemptions if there is any 3,000

subtract standard deductions Single & HOH 2300.00 - MFS & MFJ2I 1500.00 - MFJ1I - 3000.00

Subtract personal exemptions Single & HOH 2700.00 - MFS & MFJ2I 3700.00 - MFJ1I - 7400.00

Then it will apply the tax tables

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I need to find out how the software knows how much to calculate for each state. It would be similar to a table with something like .05 will be taken out for people in Alabama, .0125 could be for someone in another state.
I am thinking it is in a 40000 table or similar..?

Was this reply helpful? Yes No
Suggested answer

Terry R Heley Microsoft Employee on at

Like (1)

Report

You can see all of this by Tools | Setup | System | Payroll Tax

It is stored in these tables, Dynamics DB

UPR41300

UPR41301

UPR41302

UPR41303

Thanks

Terry

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you.

These are the set up tables. I am looking for the tax table in the system.

Here is what I am looking to get the information: (The tax table referred to here)

Was this reply helpful? Yes No
Terry R Heley Microsoft Employee on at

Like (1)

Report

select * from UPR41302, this one

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Terry,

I still need more help.. the tables have generic names. I don’t know what the fields are referencing. I really need to know where does the state tax schedules stored in payroll. This would help a lot.

Was this reply helpful? Yes No
Suggested answer

Terry R Heley Microsoft Employee on at

Like (0)

Report

Well, by looking through the table it is very cryptic.

Here would be the tax table for HOH in GA.

select * from UPR41302 where TAXCODE='GA' AND TXFLGSTS ='HOH'

You can see this in GP , by going to Tools | Setup | System | Payroll Tax

Pull up GA

Click Filing Status, choose HOH click tables.

Thanks

Terry

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you so much! All this information in this whole thread really helped me solve the problem. I appreciate it!

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Community Member 2

#2

#2

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans