Sage 100

 View Only
  • 1.  Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-12-2021 12:53
    Does anyone have steps to reverse an Accounts Payable Invoice that was paid by a Credit Card Vendor? The customer Created the AP Invoice for a Credit Card Vendor and selected multiple invoices to be transferred. One of the many invoices was selected by mistake. They did not catch that the wrong invoice was selected until after the Credit Card Vendor's invoice was paid.

    Now they need to reverse the payment for the invoice that was for the Credit Card Vendor. Then select the wrong Invoice that shouldn't have been paid yet and transfer the balance back to the invoice. Making the invoice payable again. Then select the correct invoice and transfer it to the Credit Card Vendor Invoice so it shows as paid. Then pay the Credit Card Invoice to complete the process. 

    Not sure how to do that with the credit card transfer process being involved.

    ------------------------------
    Todd Martin
    MBA Business Software (https://www.mbabsi.com)
    ------------------------------


  • 2.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-12-2021 13:28
    Are they eventually going to pay the bad boy invoice via CC?????  If so, just leave it in the CC vendor open invoice table.  Pay the CC vendor next month for it.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-12-2021 13:41
    I think they do plan to pay it. I am not sure if it is going to be paid by the same Credit Card Vendor though. I would have to check. They wanted to reverse it so that it didn't show as being paid as part of that invoice to the credit card vendor.

    ------------------------------
    Todd Martin
    MBA Business Software (https://www.mbabsi.com)
    ------------------------------



  • 4.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-12-2021 14:03
    If it is paid by another CC, then pull it from CC A to CC B.  I tried voiding the transaction via manual check entry and couldn't get any traction.  Sometimes the answer is just no!

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 5.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor
    Best Answer

    Posted 01-13-2021 08:33
    Just turn "Credit Card Vendor" on for the original non-credit card vendor & pull it back in that direction.
    I actually have my clients turn that on for every single vendor. They can move invoices to other vendors when done in error or even renumber an invoice by pulling a bad invoice number into a good one on the same vendor. 

    Its just a move of the invoice from one to another.

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------



  • 6.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-13-2021 12:29
    @Dana Young,
    That sounds great. They already Paid and updated the check that this invoice was on so I first reversed the check payment and now the Invoice is available to pay again. I need to only remove one line from the invoice They were paying a statement and had 10 or so invoices transferred to the one invoice to be paid. Do you transfer to the other CC vendor at that point for the amount of the invoice that was wrong? If I do, I lose the transfer details from the original Invoice showing the original Invoice, date and vendor name. I don't see how I can get this info to be correct as I do not see how I can actually reverse the Check on the original Invoice. If I put the check number starting with C it doesn't prompt for a check reversal.

    It also means that the invoice that the amount transfers to will not have the correct info as well. But the amounts look like they all change like they should.



    ------------------------------
    Todd Martin
    MBA Business Software (https://www.mbabsi.com)
    ------------------------------



  • 7.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-13-2021 12:33
    So go back to the original vendor's invoice. "Adjust" that invoice & pull that amount back into it that was originally sent to the CC vendor. This will put the balance back on that original invoice.

    Now its back to how it was before they messed it up.
    You can pay it from here or move it to another CC vendor if you want the audit trail.

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------



  • 8.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-13-2021 14:12
    I hope that your customers aren't processing 1099s out of AP, because the Vendor credit card transfer was designed to post the 1099 amount to the original vendor for the invoice, even after transferring it for credit card reasons.  That's a big part of why Sage added this feature, to keep the 1099 totals with the original vendor.  Just using that utility for all vendors as a generic fix all will mess up their 1099 totals in a bad way eventually.

    ------------------------------
    Jim Petrie
    Consultant
    DSD Business Systems
    ------------------------------



  • 9.  RE: Reverse a Accounts Payable Invoice that was paid by a Credit Card Vendor

    Posted 01-13-2021 16:16
    Thanks @Dana Young That was exactly what I needed to figure this out.​

    ------------------------------
    Todd Martin
    MBA Business Software (https://www.mbabsi.com)
    ------------------------------