Open Forum

Expand all | Collapse all

SQL Script for Annual Local Tax Data

  • 1.  SQL Script for Annual Local Tax Data

    TOP CONTRIBUTOR
    Posted 10 days ago
    Edited by Joni Finnell 9 days ago
    Good afternoon everyone!

    I am looking for a script that will provide annual local tax withholding and taxable wages by month for each local. Currently, I am consolidating reports by month, which isn't ideal. I'm trying to improve my year end process. 8-) I have a script by employee for one month. But I haven't found one by local tax code. Does anyone have a script they would like to share?

    Here is an example of what I hope you can provide:

    Sample

    Thanks!!

    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: SQL Script for Annual Local Tax Data

    Posted 7 days ago
    I would look at table upr30301 to start with.  Select based local tax codes type and year and then group by code.

    ------------------------------
    Doug Karel
    Business Systems Consultant - GP
    The TM Group, Inc.
    Farmington Hills MI
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role