Open Forum

Expand all | Collapse all

Voiding Multiple Open Transactions

  • 1.  Voiding Multiple Open Transactions

    Posted Jan 15, 2020 12:23 PM
    I have multiple open transactions for multiple vendors that I need to void. How do I void multiple transactions on multiple vendors at the same time? Can I do this in one big batch?

    ------------------------------
    Vicki Bratton
    The Dental Care Plus Group
    Sharonville OH
    ------------------------------


  • 2.  RE: Voiding Multiple Open Transactions

    TOP CONTRIBUTOR
    Posted Feb 01, 2020 12:26 AM
      |   view attached
    Vicki,

    I've never seen an option for voiding multiple items at once. ​

    The only thing that I can think of is a macro. You'd need to fill in the Vendor ID and the Document Number fields. The document number would be the same.

    Here are the steps the macro would use:
    1. Enter the Vendor ID.
    2. Enter the invoice number (in the From field)
    3. Enter the invoice number (in the To field)
    4. Mark the Void checkbox
    5. Click Process

    Repeat

    I've attached a document on creating a macro.

    ------------------------------
    Charles Allen
    Senior Managing Consultant
    BKD Technologies
    Houston, TX
    ------------------------------

    Attachment(s)



  • 3.  RE: Voiding Multiple Open Transactions

    TOP CONTRIBUTOR
    Posted Feb 03, 2020 10:30 AM
    Edited by John Arnold Feb 03, 2020 10:31 AM
    Hi Vicki,

    I agree with @Charles Allen about using a macro, but would recommend using Replicator instead of Word.  Replicator a macro enabled Excel spread​sheet that I wrote a few years ago after getting frustrated with trying to do the mail merge with Word.   You can learn about it (and download it) from my website  Rnoldz.com.  The file "SYS09 - GP Macros - With great power comes great repeatability" is a PowerPoint slide show that I presented at Summit last year.  There is also a Replicator link at the top of the pages that will take you to the Replicator Page (Creating/Updating data in GP) where you can download the latest version of Replicator.xlsm.

    Good Luck & Have fun!

    If you have any problems or questions, please let me know!

    ------------------------------
    John Arnold
    Senior Software Engineer
    US Digital
    Vancouver WA
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role