Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Missing detail record ...
Finance | Project Operations, Human Resources, ...
Answered

Missing detail record in payroll transactions

(0) ShareShare
ReportReport
Posted on by JBurgess 70

When viewing Check history, total deductions are more than the sum of deductions when looking at this check from payroll transaction inquiry window. Specifically one deduction code that is included in the summary is not show at all in the transactions.

pastedimage1591119145036v1.png

Total is $105.43

pastedimage1591119276519v2.png

Sum is 85.43

I've run check links and reconcile on the employee. Neither of those fixed this discrepancy. From what I can tell, there is a missing record in the UPR30300 Table for the deduction code. Without adding in records to that table manually, how could I fix this? 

Categories:
Microsoft Dynamics GP
  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: Missing detail record in payroll transactions

    This same issue has happened again for the same client. What could be causing this? Anything to watch out for as far as processing goes? or a way to catch these without them finding them when looking at specific employees?

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: Missing detail record in payroll transactions

    If it is missing from both, it should be fine, thanks!

    Terry

  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: Missing detail record in payroll transactions

    Hey Terry, thanks for the response. It appears that it's missing on the Summary as well. As the Month of May should be $40 and it's showing $20:

    pastedimage1592577550825v1.png

    That being the case, I will suggest that the client does a manual check for the deduction to fix this. Can you think of any reason why this would happen, and more importantly, a way to check for additional situations like this and prevent them?

    Jason

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: Missing detail record in payroll transactions

    This is a good find as typically those two would tie out.

    If you go to Cards | Payroll | Deduction for this employee and click Summary  does the month of May total out for you as you would expect?  This is pulling from the UPR30301 which is the summary table to the UPR30300 where you state it is missing.  This would have popped up on a reconcile report so I'm guessing it is not there?

    If it is missing in both tables, we could do a manual check for the deduction which will then make it right and totals correctly.

    Let me know what you find, thanks

    Terry

    Terry Heley | Sr. Escalation Engineer | Microsoft Dynamics

    701-492-6376 (o) | 701-412-5619 (m) | theley@microsoft.com

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans