Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Bank Reconciliation - Voided Transaction

Posted on by 140

I am unable to balance my bank reconciliation properly because I receive the following error "You can't mark the checkbox for this transaction because it has been voided."

We had a payment that was incorrectly voided in the wrong period (12/18/2015 instead of 12/18/2014). Now this transaction is left open on the bank rec because the void is not recorded until the next year. Is it possible to change the void date or to remove the transaction from this bank rec module? This transaction will not clear for another year if left as is.

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Bank Reconciliation - Voided Transaction

    You can correct it by backend process. The bank reconcile transactions are available in CM20200 table and CM20400(from this distribution table verify the voided flag updated or not). And you also need to correct the voided posted date of appropriate module history tables as well.

    Better you can contact your SQL expert/GP partner to correct this issue. Before doing this make a backup of your company database.

    Hope this helps!!!

  • Suggested answer
    RE: Bank Reconciliation - Voided Transaction

    Hi,

    On the Reconcile Bank Statements window Change the cutoff date to the date of the wrong posted date i.e. 12/18/2015 as per Joesph and press transactions.  In this voided transactions will be excluded.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bank Reconciliation - Voided Transaction

    I am having the same issue - have you found a resolution? Thanks!

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans