Post#17: Pending Invoice Issues

If you try and create invoice from the PO but do not post, instead you just close the form. The invoice is saved as a pending invoice. This causes some pending invoice quantity in a PO line to appear which will prevent an invoice being posted if you try and create a new PO. There are a number of different scenarios:

Scenario 1: Normal Pending invoice created. 

Navigate into the pending invoices form as shown below in Accounts Payable\Vendor Invoices\Pending Vendor Invoices

post17_img1

Once the form is open you will need to delete the pending invoices of the PO or alternatively edit the pending invoice and post.

post17_img2

Scenario 2: Pending invoice showing in PO header invoice tab but not in Accounts payable pending invoices. 

Now sometimes the PO shows that there are pending quantities but you cannot see it in the the menu point stated above. You will notice this on the PO header (Invoice tab) however there will not be any actual records in the pending invoice menu point for you to delete.

post17_img3

This is due to some orphaned transactions. In this senario you will need delete the lines from for that PO in the VendInvoiceInfoTable table via AOT but only records where ParmJobStatus is set as Waiting. This will solve your issue.

Scenario 3: Pending invoice cannot be displayed because it is in use. 

In some cases where you do not see any pending invoices but instead see a message like below while trying to make an invoice:

post17_img4

No need to worry just try and click the invoice button again on the Purchase order to create an invoice this time the system will show you a list of invoices that need to be recovered. Please recover all the invoices then delete them in the pending invoice list.

Now you should be able to create the invoice. If you still are not able to do click on the “Match Product receipts” button on the invoice posting screen and select the GRNs you want to post invoice for manually.

If these 2 options for scenario 3 do not work use scenario 2 solution.

All of the above should extensively cover all the pending invoice scenarios you might have.

Happy Daxing ppl.

5 thoughts on “Post#17: Pending Invoice Issues

  1. Very useful post. This is the answer to my pending invoices issues. This article is very comprehensive and easy to follow. This is a big help for me. I’ll definitely return to this article.

    Liked by 1 person

    1. Thank you so much for the comment. I am glad it helped you. Please feel free to follow the blog to get the latest new posts and check the archive for many other interesting posts.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s