Open Forum

Expand all | Collapse all

table dbo.UPR10105 has 0 records where STATINTX = 2019

  • 1.  table dbo.UPR10105 has 0 records where STATINTX = 2019

    Posted 10 days ago
    Our dbo.UPR10105 database table has no records for the current year.
    We have a Crystal Report that queues against this table, (among others) for every quarter and up until this year; has returned results of the current year. Attempt to queue for the first quarter of 2019 and results from this table are empty. There are no records where RPTNGYR= 2019.

    Was there a change within Great Plains? Did we forget to do something at year end?

    If this table is supposed to have records for the current, what's to be done to re-populate for 2019?
    We're using GP 2018.

    #YearEnd
    Thanks

    ------------------------------
    James Patt
    Programmer
    Western Region OTB Corporation
    Batavia NY
    ------------------------------


  • 2.  RE: table dbo.UPR10105 has 0 records where STATINTX = 2019

    TOP CONTRIBUTOR
    Posted 7 days ago
    Hi @James Patt

    That is the Year-End State tax table and is updated when you run the Year End routines in Payroll.

    I'm not sure why it was populating before...


    ------------------------------

    ------------------------------



  • 3.  RE: table dbo.UPR10105 has 0 records where STATINTX = 2019

    TOP CONTRIBUTOR
    Posted 5 days ago
    Hi James, for quarter end sometimes what people do is run the payroll year end process so they can verify numbers, it does not hurt anything, then you remove it by the next payroll.  Maybe you just have not done that step?

    I have this noted in step 6 of my blog below
    https://community.dynamics.com/gp/b/dynamicsgp/posts/my-941-does-not-match-my-payroll-summary-tell-me-why

    Thanks
    Terry Heley
    Microsoft


    ------------------------------
    Terry Heley
    HR/PR expert
    Microsoft
    West Fargo ND
    ------------------------------



  • 4.  RE: table dbo.UPR10105 has 0 records where STATINTX = 2019

    Posted 4 days ago
    Thanks for the reply which may explain why the UPR10105 was being populated in the first place; we must've been creating the year end wage file.
    Before we go down the path of remembering to create the year-end wage file each quarter, is it possible to access the database table that populates the UPR10105 directly?
    In other words, what table(s) is used to populate the UPR10105?
    thanks

    ------------------------------
    James Patt
    Programmer
    Western Region OTB Corporation
    Batavia NY
    ------------------------------



  • 5.  RE: table dbo.UPR10105 has 0 records where STATINTX = 2019

    TOP CONTRIBUTOR
    Posted 3 days ago
    It is stored in the UPR30301 by month
    UPR30300 by detail/check run which is summed to the UPR30301

    select * from UPR30301 where year1='2019' and pyrlrtyp ='4'

    Thanks
    Terry


    ------------------------------
    Terry Heley
    HR/PR expert
    Microsoft
    West Fargo ND
    ------------------------------



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