web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Federal &State Tax...
Microsoft Dynamics GP (Archived)

Federal &State Tax QTD / YTD Information

(0) ShareShare
ReportReport
Posted on by dwpalmer 130

Hello All,

I am trying to work on an export to streamline some of our tax reporting. I am having a little trouble locating some of the information in the database. I cannot find where the employee's state tax QTD or YTD information is stored. Does anyone know where I can find these?

Thanks

David

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    For your state taxable wages, you need to look at the UPR30301 table. It's listed there by month. There isn't anywhere in the system where it's QTD, etc. I think that's just calculated at runtime, but I don't have the code so I don't know for sure.

    Kind regards,

    Leslie

  • dwpalmer Profile Picture
    dwpalmer 130 on at

    By month works! I can extract the quaters from there. Thanks Leslie!!

  • L Vail Profile Picture
    L Vail 65,271 on at

    Fabulous,

    I didn't address Federal Tax, that information is in the Payroll Tax Liability History table - UPR30200. Again, you'll have to do the math to get the QTD, etc. information.

    Kind regards,

    Leslie

  • dwpalmer Profile Picture
    dwpalmer 130 on at

    Any idea what the MTDWAGES_ Stands for? The state and local columns are pretty self explanitory.

    David

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    It's how much they've booked in wages for the particular month.

    Is it not lining up with your data?

    kind regards,

    leslie

  • dwpalmer Profile Picture
    dwpalmer 130 on at

    No I think it is. I amm just looking at the data I need for the detailed wage report.

  • L Vail Profile Picture
    L Vail 65,271 on at

    What do you need to include in your report that you're not finding? Also, what does 'wage' mean to the recipients of this report?

    Kind regards,

    leslie

  • dwpalmer Profile Picture
    dwpalmer 130 on at

    If you would like I could send you the file specs that might clear up some of the confusion.

    Thank you so much for the help Leslie!!!

  • dwpalmer Profile Picture
    dwpalmer 130 on at

    Leslie,

    The UPR30301 work great for all the state reporting I needed. I just have one last field I am looking for and could use some guidance on it. I am looking for what the tax service we use describes as:

    "Unemployment Subject Wages"


    Their description:

    "Total of subject (to unemployment) wages earned by the employee during the quater as defined by the reporting state (also referred to as "total" or "gross" wages.)

    Thank you so much for your help!!!

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    This one is a little trickier in that the actual number is computed at runtime. What you can find is the whether the wages are 'subject to' SUTA, but since you can change the maximum settings at any time, the wages actually included in that minimum aren't stored in the database. Look in the UPR30300 where the PAYROLCD is the state in question. You won't have set up this PAYROLCD, the system uses that code itself.

    Kind regards,

    Leslie

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans