Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
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 74

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 74 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 74 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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans