A pending invoice cannot be displayed

(0) Share

Report

Posted on by Community Member

Hi,

When generating a PO invoice will get this error message that "A pending invoice cannot be displayed"

"A pending invoice cannot be displayed because it is in use. If nobody else is working with the invoice, you can delete the unconfirmed changes to the invoice, and then you can modify the invoice. Use the Invoice history and matching details form or the Approval journal history and matching details form to delete the unconfirmed changes."

Please advise,

Athan

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (1)

Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

As annoying as that is, it happens quite a lot in R2 and early R3. The whole pending invoice thing works differently in R3 CU10, and I'm hoping this problem goes away.

You can go into Accounts payable, Common, Vendor invoices, Pending vendor invoices, select the one that has the issue, and delete it there and start over.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Brandon,

Thanks for a quick respond.

Yes, I already tried that but we still get that error message and the "Lines" for the item number, item name, quantity... are blank.

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

You could have more than 1 record for the same PO in the list. Are you sure you've deleted them all?

It's also possible to have a record in VendInvoiceInfoTable that maybe doesn't show up in the list. It's the ParmId in that table that makes the vendor invoice "in use" according to the error message.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes its all been deleted but the error message keep showing

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

I have run into this on occasion- You need to find the table VendInvoiceInfoLine and in the table find OrgiPurchId find your PO number. Then delete that record. Next step is to find the table VendInvoiceInfoTable and then in that table find PurchId, find your PO number and delete that record as well. This should clear up the issue

Ron

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ron,

I will try your advise and I will get back when it works.

Thanks Ron and Brandon

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ron;

your advise work with me .

thanks alot

Was this reply helpful? Yes No
Ramji M H 105 on at

Like (0)

Report

Hi Ron,

Your tip work for me.

Kind Regards,

Ramji M H

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Brandon

I am also facing the same issue, but i am not able to delete the pending invoice PO. Delete Button became invisible for particular this PO. for remaining PO Delete button is working fine

i selected PO from this path-> Accounts payable, Common, Vendor invoices, Pending vendor invoices, selected the one that has the issue,Please help me out

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, There is a verified answer from Ron - That should fix (note: the delete action is on table not on form)

Was this reply helpful? Yes No