Open Forum

Expand all | Collapse all

Can a Voided Check and Invoice be Reversed?

  • 1.  Can a Voided Check and Invoice be Reversed?

    TOP CONTRIBUTOR
    Posted 29 days ago
    ​​As we are reviewing our 1099 transactions it was found that a 2018 check was voided in 2019 instead of 2018. So, the 2018 1099 amount for one of our vendors is incorrect. I'm not aware of a way to reverse a voided check or invoice. Any ideas? We would also like to change the void date for the invoice. We are on GP2016R2.

    If a SQL script is the only way, please provide the script.

    Thanks

    #Accounting


    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------


  • 2.  RE: Can a Voided Check and Invoice be Reversed?

    TOP CONTRIBUTOR
    Posted 29 days ago
    HI @Joni Finnell


    If it were me, I'd recreate the original invoice and payment and re--do it all from start to finish.  In this way you are sure that it is correct in all tables.

    Just be careful of the dates - but a complete re-do is how I'd fix this one.

    ------------------------------
    Kindest Regards,
    Jo deRuiter , MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    GPUG Academy Instructor
    Dynamics GP Credentialing Council-Vice Chair
    770-906-4504 (Cell)

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



  • 3.  RE: Can a Voided Check and Invoice be Reversed?

    GOLD CONTRIBUTOR
    Posted 29 days ago
    You cannot reverse a void. I believe you have to use a journal entry to correct, but I'm not familiar with the exact process.

    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power and Water
    Muscatine IA
    ------------------------------



  • 4.  RE: Can a Voided Check and Invoice be Reversed?

    TOP CONTRIBUTOR
    Posted 27 days ago
    ​Hi Joni,

    Let me see if I understand. You issued and later voided a check. However, due to the timing difference, the void is in 2019 instead of 2018. This will affect the ledger, and your 1099s. Otherwise the vendor balance is correct. Here is what I would do.

    Issue a reversing GL entry to record the void in 2018 and reverse in 2019. This corrects the timing issue in the ledger. For the 1099 totals, you can adjust the amount that prints, by going to "Purchasing >> Cards >> 1099 Details" and adjusting the amount there, reducing the 2018 total by the amount of the void. You also will probably have the void as a negative amount in 2019, so you would want to fix that.

    Hope that helps.

    ------------------------------
    Mark Wiley
    Dynamics Credentialed Professional
    Senior Consultant
    DXC Technology
    Akron, OH
    ------------------------------



  • 5.  RE: Can a Voided Check and Invoice be Reversed?

    TOP CONTRIBUTOR
    Posted 23 days ago

    Why not just edit the total 1099 amounts instead?



    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------



  • 6.  RE: Can a Voided Check and Invoice be Reversed?

    TOP CONTRIBUTOR
    Posted 23 days ago
    Thanks for your responses everyone.

    I reached out to our GP Partner to fix all of it through SQL. Even the GL part.​ \0/

    A shout out to @Dan Specht at Velosio. He has some mad SQL skills.


    ​​

    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------