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 Microsoft Employee

what table holds state income taxes?

*This post is locked for comments

All responses Img

All responses (10)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: what table holds state income taxes?

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

Terry R Heley Microsoft Employee on at

Like (0)

Report

RE: what table holds state income taxes?

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: what table holds state income taxes?

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.
Terry R Heley Microsoft Employee on at

Like (1)

Report

RE: what table holds state income taxes?

select * from UPR41302, this one
Community Member Microsoft Employee on at

Like (0)

Report

RE: what table holds state income taxes?

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)
Suggested answer

Terry R Heley Microsoft Employee on at

Like (1)

Report

RE: what table holds state income taxes?

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: what table holds state income taxes?

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..?
Suggested answer

Terry R Heley Microsoft Employee on at

Like (1)

Report

RE: what table holds state income taxes?

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
Suggested answer

L Vail 65,271 on at

Like (1)

Report

RE: what table holds state income taxes?

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: what table holds state income taxes?

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?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,309 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans