AP Invoice Balance - Reverse a reversal

(0) Share

Report

Posted on by Community Member

Hi All,

So one of our users entered an invoice through AP Invoice Journal, then reversed it and then reversed the reversal. This should not be a standard business practice but it happened. In this situation the reversal should settle with its reversal and the invoice should be available again with a balance. Please see the following screenshot, the invoice does not have a balance (which is wrong). On the Vendor balance the amount shows, but when we run the aging and Trial balance there is an exact difference for the invoice.

Production Environment

I've run the same scenario in our test environment and it runs as it should.

Test Environment

Please help!! would greatly appreciate the guidance.

Regards,

Mohsin Kamal

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

Hi Mohsin,

Can you check if there are more vendor transactions for this vendor? Have you also tried to look at the settlement history if the invoice and the reversal were settled with the same or probably another voucher?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

There are other transactions for the vendor but they are all settled and there are no transactions in the Settlement.

Please see the following screen shot.

Also, I've tested reversing the last transaction on the screenshot for Production and it reverses the balance and the vendor balance is Zero. The question stands, what and why this happened, the user is unable to recall the steps. Our Admin is working on getting the reports up and running in test so I can verify if aging matches Trial balance. I will confirm.

Thanks,

Mohsin Kamal

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Also, Just in case if someone is wondering . No GL accounts have been switched during this period.

Regards,

Mohsin Kamal

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

Hi Mohsin,

If you go to the vendor list page or form and then open the form 'Edit closed transactions' you can unsettle transactions. Try to see if for the transactions in question a second (related) transaction or more are selected when you select each one of them apart. It might give some information about the settlement history as well. If one of the transactions has no additional records selected automatically, the information on the vendor transaction was not updated correctly. If you select the debit transaction and get both credits, then there is also something incorrect on one of these transactions, but also the settlement history.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

I looked at "Edit Closed Transactions / Closed transaction Editing" and it only shows the invoice that is settled with a check/payment.

I can confirm, after reversing transaction "GLRV000183" (please see above screenshots) the balance on vendor card cleared and the Vendor aging and trial balance matched.

I'm unable to replicate this scenario and we are unable to pinpoint why and what caused this issue at the first place.

Regards,

Mohsin Kamal

Was this reply helpful? Yes No