Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

how to void a cash receipt batch

Posted on by Microsoft Employee

This morning I posted a batch of cash receipts to the wrong cash account.

I want to void the batch and start over.

By searching for how to do this I've found "solutions", but it looks like those people are using different versions of GP than me.  We have GP 2015.

Help?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to void a cash receipt batch

    Hi Leslie, thanks for your reply.  I've got the two following issues:

    1. I have voided the cash receipt and yes the invoices are receivable again. However, when I generate the Equiry -> Financial -> Detail report of my trade debtors and bank accounts, the voided amounts still appear. How do I remove them as it makes the balance of these accounts incorrect?

    2.  I have two invoices that appear in my Aged Trial Balance. The payment that was originally applied to them has now been voided. However, when I try to apply a new payment to the invoices, I am unable to do so. When I go into Cash Receipts Entry -> Appy: they don't appear. When I go into the invoices to see how they have been paid, they are still linked to the voided amounts whereby I am unable to remove it. Could you please advise how to overcome this?

    I am very new to the program so any assistance will be greatly appreciated!

    Thanks

    Isabelle

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: how to void a cash receipt batch

    Hi,

    If you voided a cash receipt, that makes the invoice a receivable again. Therefore, it will show up on the Trial balance. If you want it off of the Trial balance, you'll need to also void the invoice.

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to void a cash receipt batch

    Hi! I have been able to void the transaction as per the above, but the voided transactions still appear in Trade Debtors and Bank accounts. How do I remove this?

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: how to void a cash receipt batch

    Hi AlabamaPamela,

    I just wanted to see if you have any additional questions on this issue.

    Just let us know as we are always happy to help!

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: how to void a cash receipt batch

    Hi AlabamaPamela,

    Unfortunately, there is no way to void out the entire batch. As Matt mentioned you would need to void out each individually. In regards to your second question about changing the void status in SQL. As Matt had also mentioned it would not back out the transactions that were posted to the Bank Rec tables and the General Ledger.

    The supported method is to void from the front end of Dynamics GP as Matt mentioned.

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: how to void a cash receipt batch

    No, I don't think you'd want to go that route.  It wouldn't update the checkbook properly or the GL, and I'm sure there would be other tables that would need to be effected as well.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to void a cash receipt batch

    Matt, is it possible to just update the Void flag in the database ?  Search on the batch id and for all those transactions just update the void field?  Is this possible?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to void a cash receipt batch

    Thanks, that's what I did.  I was hoping to void the batch, though.

    I appreciate all the help here as I learn.

  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: how to void a cash receipt batch

    There isn't really a way to void a whole batch.  You need to use the Receivables Posted Transactions Maintenance window (Sales >> Transactions >> Posted Transactions) and void them individually.  If there are alot of transactions in the batch, you could look in to using a macro with mail merge in order to void them all (blogs.msdn.microsoft.com/.../how-to-use-word-mail-merge-and-macros-to-import-data).  However, if you aren't too familiar with it, it could take more time to set up and get it working correctly than it would to void all the transactions manually.

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

Product updates

Dynamics 365 release plans