web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

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
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    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

  • JBurgess Profile Picture
    JBurgess 74 on at

    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?

  • Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 577 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 309

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans