Skip to main content
Microsoft Dynamics GP forum
Suggested answer

OT calculation - Pay factor in Employee Pay Codes showing 5 decimals in SQL table (UPR00400) instead of 2 decimals.

editSubscribe (0) ShareShare
ReportReport
Posted on by 70

Pay factor is set up as 1.50 in pay code setup and on the employee specifically. However when looking in the UPR00400 table this pay factor is showing as 1.50069. There is no option to use more than 2 decimals when entering, so how is GP adding this additional fraction in? This is causing the calculation of overtime, which should be 1.50 to be incorrect. Has anyone seen this behavior before? I can manually correct this, but that is not a good practice for any new employees going forward.

Jason Burgess

Attachments
  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: OT calculation - Pay factor in Employee Pay Codes showing 5 decimals in SQL table (UPR00400) instead of 2 decimals.

    Hi Jason, 

    You have me curious as well as to what would be causing this.  I am not able to recreate this at all and I don't see any cases in our case history reporting this as an issue ever either.  If they want to dig into the root cause, we could assist with that and run logs on the issue to figure it out but we would have to do that through a support case as that obviously would not be possible to do through a forums post.  

    At least you have a workaround for the time being.  

    Thanks,

    Isaac Olson

    Microsoft Support

  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: OT calculation - Pay factor in Employee Pay Codes showing 5 decimals in SQL table (UPR00400) instead of 2 decimals.

    Issac, once again, thank you for taking the time to look at this.

    As for the questions you asked. It appears that this is only happening when using quick assignment. There are no 3rd party products that I can see that would interfere with this at all, as only greenshades is used as far as 3rd party products go. They were also able to set up an additional OT code and the same behavior is happening with that one.

    I've advised they not use quick assignment, but I'm curious what the root cause and fix would be.

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: OT calculation - Pay factor in Employee Pay Codes showing 5 decimals in SQL table (UPR00400) instead of 2 decimals.

    Hi Jason,

    No problem.  I ran a DEXSQL.log of the process of assigning an overtime code to my employee and other than the UPR00100 table for the employee master, and the Workers Comp table UPR40700,  I didn't see anything else besides the 2 tables that I had mentioned previously that would come into play with this.  My recommendation would be as follows to narrow down the issue.

    1. Does the issue only occur if you use Quick Assignment?  If you manually assigned the overtime pay code to a new employee do you see the same issue?

    2.  Do you have any Third Party Products or add-ons or products installed that could come into play here?

    3.  Can the issue be reproduced if you create a new Overtime pay code?  This would help eliminate whether their might be an issue with the data on your specific overtime code versus an overall setup issue in your company.  

    It might be best to set up a test company with a copy of the live company for this testing.

    "How to set up a test company that has a copy of live company data ":

     support.microsoft.com/.../871973

    If none of these suggestions end up helping you narrow down where the issue is, it might be best to open a support case where we can do some more hands on digging into this issue with you to figure out why is different in this company versus other instances of GP.  

    I hope this helps!

    Isaac Olson

    Microsoft Support

  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: OT calculation - Pay factor in Employee Pay Codes showing 5 decimals in SQL table (UPR00400) instead of 2 decimals.

    Isaac, thanks for your insight here.

    I had already run the update you described on the UPR00400 table which corrected the immediate issue.

    However, when reviewing the UPR40600 table the PAYFACTR value is set to 1.50000 like I would expect. I'm not seeing any that are set to the incorrect value of 1.50069.

    After putting in two new employees and saving (using quick assigment) the incorrect value is pulled.

    I'm not sure how this incorrect number is being populated!

    Thanks again for taking the time to review and answer!

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: OT calculation - Pay factor in Employee Pay Codes showing 5 decimals in SQL table (UPR00400) instead of 2 decimals.

    Hello,

    I would agree with you that this very unusual.  My guess would be that the main setup was imported for this Overtime code and the UPR40600 table has the odd PAYFACTR.  Every time that this pay code is set up on a new employee if they pulled the setup from the company it would then pull the 1.50069 amount.  

    select PAYFACTR,* from UPR00400 where PAYFACTR <> 0

    select PAYFACTR,* from UPR40600 where PAYFACTR <> 0

    If it is incorrectly showing in either table, you should be able to just update it in SQL and not have the issue going forward.  

    update UPR00400 set PAYFACTR = '1.5' where PAYFACTR = '1.50069'

    update UPR40600 set PAYFACTR = '1.5' where PAYFACTR = '1.50069'

    I cannot think of any possible front end way to data into the condition that you are seeing.

    I hope this helps!

    Isaac Olson

    Microsoft Support

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans