Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / No distributions for V...
Finance | Project Operations, Human Resources, ...
Suggested answer

No distributions for Voided Payroll Check

(0) ShareShare
ReportReport
Posted on by JBurgess 70

I have a client that voided a check today, but can't print out a check posting register. From what it looks like to me, the distributions table was never updated. For this employee I went to check history to verify the void had been done, but when selecting the distributions button, nothing is displayed. The header records appear to be intact, it looks like just the distributions are missing.

pastedimage1598644733779v1.png

I've already run reconcile and check links on the payroll transactions and distributions, but nothing was corrected.

Is there a way for me to be able to get the distributions into the correct table so they are available here and to reprint a check posting journal?

Categories:
Microsoft Dynamics GP
  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: No distributions for Voided Payroll Check

    Hello,

    You can write insert statements in SQL to get the records inserted into the UPR30401 table, using the original records as a guide.  Or you can restore a backup to a TEST company and void the check again and insert those records back over to the table in the live company using DTS or SQL scripting.   If you need help with any of that, reach out to your Microsoft Partner for assistance.  

    Thanks,

    Cheryl

    Microsoft Support

  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: No distributions for Voided Payroll Check

    Thanks Cheryl, I did confirm that the original check has distributions. Do you recommend any particular way to insert those records to the distributions table? Are there any options to clean up the void transactions, and essentially "redo" the void?

  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: No distributions for Voided Payroll Check

    Hi JBurgess,

    The screenprint was helpful.  The check looks like it was voided (UPRVC audit trail code) so that is good, and you are just missing the distributions.   Look at the original check to verify if there were distributions associated with it, as if there was not, then it's a wash and you really don't have to do anything.   If there are distribution records on the original, then you could use those as a guide to manually key a journal entry in GL to back them out.  The only way to get distributions to show on the voided check would be to insert them into the UPR30401 table in SQL..

    Hope that helps, 

    Cheryl W

    Microsoft Dynamics GP Support

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 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