Void Historical Payment Transaction Issue

  • Void Historical Payment Transaction Issue

    Posted by Ben Micek on August 14, 2024 at 12:21 pm

    I have a payment transaction posted which lacks a document number which generally is the check number field. In this case the field is blank and it was an electronic payment. We have been entering ACH with the GP voucher number in this field such as ACH026850. This is the problem. The transaction continues to appears on the AP Trial Balance report as outstanding/unpaid. I am not able to Void this historical transaction because nothing displays to select from because of the blank document number field. Any suggestions are welcome.

    I would like to simply open up this posted record and add the document # information. The rest of the transaction is posted properly. Reporting is being affected. (If I could void a transaction using the GP Payment number that would be helpful but not possible.)

    Thank you

    Windi Epperson replied 4 months, 1 week ago 2 Members · 1 Reply
  • 1 Reply
  • Windi Epperson

    Member
    August 15, 2024 at 11:22 am
    Up
    0
    Down
    ::

    Hey Ben,

    This probably won’t work, but here’s where you can try to add the document number. In Purchasing Transactions go to Edit Transaction Information. Pick the vendor then Doc Type of Payment. Since you don’t have a payment number, do a look up and see if by any chance it will let you ‘select’ the blank record that you see. If so, add the doc number and save.

    I suspect it won’t let you pick the blank record though, so as option 2 I would make a backup of your database and run reconciles on that vendor. This might or might not add a doc number if by chance the doc number does exist in another supporting table. Slim chance this will work but also worth a shot.

    Beyond that you’ll have to have your partner go into sql and either add a doc number or delete the payment record.

    Good luck,

    Windi

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!