Void Payable transactions still shows up in open table

(0) Share

Report

Posted on by Community Member

I have void a Historical transaction and then, voided the same using void open transactions and able to print it to printer and it looks correct but the transactions still sits in open table. I did an Inquiry using Transaction by Vendor and that transaction shows up as OPEN. Can you please guide to how to resolve it.

Thank you in Advance.

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (1)

L Vail 65,271 on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

MRJI,

I was just reviewing some of the older posts and wondered if this has been solved? I've been doing a lot of work lately with odd happenings in payables. Mostly I'm using SQL because you just can't get there from the user interface. If this is still an issue, please let me know.

Kind regards,

Leslie

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

MRJI,

Any update on this?

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Vail & MRJI,

I have created the same scenario in my environment. Created a payment and applied to a invoice then both are went to history. Then voided the history payment. After voided the historic payment, invoice went to open status. Now I was deleted the distribution account for the open invoice from back end table PM10100. After I have tried to void the open invoice, it was voided without any issue. The reversed distribution also created and document went to history status with voided = 1.

Based on the above scenario, I hope we can void the transaction without distribution account.

I don't know why is this invoice not voided for MRJI?

MRJI,

Better you can delete the invoice from back end. After that create a new invoice like deleted. Then post that invoice. The posting date for invoice should be same as old invoice posting date. Finally void the same.

Query for delete open invoice.

Before running the delete query, verify the table contains single record. To verify run the query(select *from PM20000 where Doctype=1 and vchrnmbr='Enter your invoice Voucher number').

Delete PM20000 where Doctype=1 and vchrnmbr='Enter your invoice Voucher number'

Vail, need your suggested.

Hope this helps!!!

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Hi Soma,

I don't know of anything to do past Check Links and reconcile from the user interface side. I would toss in the distributions to the SQL table, and then void it with the user interface. Make sure all of your document dates are in synch so that your HTB reports aren't thrown off.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Hi Soma,

Can you please tell how to resolve the issue from backend sql?

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Hi Vail & Soma,

You both are correct. Can you suggest me the solution to correct this.

Thank you

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Vail you are correct. Based on my discussion with MRJI. The voided historical transaction is payment and it was voided and available at history table with voided. The returned open invoice from the payment was trying to voided. But this couldn't voided. Because there is not account distribution available for this invoice. So, it can't be voided.

I guess, the account distribution for this invoice was deleted from backend side. Is there any way to correct this issue except backend update?

Your reply is much appreciated.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Mrji,

Hi, I'm reading your and Soma's posts and want to make sure I'm understanding. You had a paid payables transaction and voided the historical transaction using the Void Historical Payables Transactions window. The historical transaction was the payment. This moved the original invoice into the Open table. You then voided the open invoice using the Void Open Payables Transactions window. At this point, both the payment and the invoice should be in history and not included on your current payables trial balance.

Except, it is still on your payables trial balance. So, did the check (payment) void OK, but the Invoice doesn't appear to have voided? It looks like you tried to void it again using the Void Open Payables Transactions window, and it still isn't voided. If you look for the transaction in the payables inquiry window, it shows as being in the open table with no similarly numbered transaction in the history table. The first document you voided (the payment), does it show to be in the history table?

Are my facts right?

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Hi

I ran the query and it return nothing. Any other suggestions?

Thanks

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: Void Payable transactions still shows up in open table

Check the in the below query in SQL against company DB.

SELECT * FROM PM10100 WHERE VCHRNMBR IN (SELECT VCHRNMBR FROM PM20000 WHERE DOCNUMBR='Enter Your Doc Number')

Was this reply helpful? Yes No