Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Delete Partial Pay Run

(0) ShareShare
ReportReport
Posted on by

A client informed me that a pay run a few months ago was found to be incomplete as many reports have partial information.  I reviewed and came to discover that the batch was interrupted.  I was thinking about deleting the entire pay run by audit trail in SQL and redoing it.  Any body have a script already made up to delete all touched tables in PR & GL?

Thanks

Ed

*This post is locked for comments

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Delete Partial Pay Run

    My suggestion would be to examine each payroll transaction and then enter a negative manual check transaction to offset each transaction. Trying to find every deduction, benefit, pay code,  etc may leave them worse off then they are now. Not all employees may be missing the same transactions so you will need to do this on a one by one basis.

  • Community Member Profile Picture
    on at
    RE: Delete Partial Pay Run

    BR tables too.

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

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans