Share this:

Like this:

21 Responses to “Payroll Tables”

Hi Victoria,
I generate an overtime report for my employer each pay period from the payroll history reports. This report only has the employee ID numbers. I would like for the employee names to print out in stead or in addition to. I think I need to modify this report by creating a calculated field with the correct table number for names or create a smartlist report for it. Either way I need to know which table has the employee names. Can you advise me? Thank you,
Brenda

Hello Victoria ,
I am trying to write to table UPR10302 and I am getting duplicate key error on COMPTRNM. Is there a way to increment and stay consistent with DEX_ROW_ID field. Thanks for all of your knowledge.
-Randy

Sorry I misunderstood your question. COMPTRNM is the next payroll transaction number. The next number GP wants to use is stored in the UPR40200 table in field NXCTRNUM. So you should use what’s in there and increment it once used.

However, this brings up a possibly bigger question – why are you trying to manually insert data into a transaction table? That’s usually not advised and will cause all sorts of trouble if you’re not doing proper data validation and not updating all necessary related tables at the same time.

thank you very much for the info.
To you bigger question I am writing an interface from iSeries/as400 into GP. I know I am doing this totally backwards but I created payroll records in GP search for the tables that was updated i then sent a similar record from iSeries into GP and corrected errors and included new tables along they way until i get it sync with the GP record. The tables i am currently using are UPR10301 & UPR10302 I am new to GP and your blogs has help me tremendously .

Victoria:
I have a scenario where there can be a check for an employee that is obligated to make payments to a court or government body. In some instances, these amounts should completely consume the check amount. However if there are multiple obligations, the rounding errors sometimes leave a check for a few pennies. We don’t want to issues these checks due to the small amount and due to the fact that their obligation should amount to the whole check amount. Do you have a suggestion on the best way to handle this scenario?
Thank you in advance for your answer, and for all you do for the GP community. I know that when I see your name on a comment, I always have confidence that the answer is spot-on!
Thanks
Dave

Thanks for your kind words! Unfortunately, I don’t work with the payroll module much and have not run into this before, so I am not sure what the best way to handle it would be. If you have not already, I would recommend posting your question on the Dynamics GP Community Forum, there are a number of folks who frequently answer questions there that know Payroll very well and may be able to help you better.

I am working with a client who has multiple test companies set up in GP 2010 and they are now ready to go live. I tried to change the name of one of the companies to remove the test name so the message went away and it tells me that I cannot because I have too many employees. They have never set up payroll at all. I deleted a table UPR41600 which I read should have re-set the employee count but it did not fix it. Would you have any suggestions?

Victoria, Is there a script I could use in SQL Studio, where I could identify all the tables that have a check number field (CHECKNMBR)?? I’m sure it would be handy for other searches, too. Thanks for your time!