Purchase order invoicing error and get the Msg. "Unable to Invoice due to update quantity is greater than remaining quantity Order Line"

(0) Share

Report

Posted on by PrasitP.

152

I found the problem when our accounting posting AP Invoice and then get the message :
"Unable to Invoice due to update quantity is greater than remaining quantity Order Line"
as the screen below.

I try to check around the problem and found many things are abnormal...
1. This purchase number:PORQ161100355 was received but the quantity in "Deliver remainder" was not deducted.
1780.Untitled_2D00_1.jpg

2. Inventory transaction of this PORQ161100355 still be "Ordered" , Normally after do Product Receipt it will update to be "received". At the same time the Inventory on hand have no any record.
7127.Untitled_2D00_2.jpg

3. Normally after we do Product Receipt then in the Ledger we can check the data of Ledger voucher but for this case the data is empty.

I think these are the cause of invoicing error message : "Unable to Invoice due to update quantity is greater than remaining quantity Order Line"

I appreciate all of you for help and advise.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

AXSHAH 528 on at

Like (0)

Report

RE: Purchase order invoicing error and get the Msg. "Unable to Invoice due to update quantity is greater than remaining quantity Order Line"

Hi,

Check this item Underdeliver & Overdelivery values under Released product in multiple fast tabs:Purchase, Sell & Manage Inventory must be zero as shown below:

Was this reply helpful? Yes No
PrasitP. 152 on at

Like (0)

Report

RE: Purchase order invoicing error and get the Msg. "Unable to Invoice due to update quantity is greater than remaining quantity Order Line"

Hi AXSHAH,

Thank you for you reply. As I checked two fields for this item is zero, but the message still happen.

Could anyone help or advise for this issue. Thank you in advance.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Purchase order invoicing error and get the Msg. "Unable to Invoice due to update quantity is greater than remaining quantity Order Line"

Hi Prasit,

Normally we will get the above error , when the Invoice qty is greater than the ordered qty (PO line qty).

Check the invoice qty , if greater than 2 as per screen shot provided by you or not.

We will define Over delivery or under deliver percentage on PO line , in case , if we do Receive or invoice more qty or lesser qty than ordered qty.

If its zero , it will not allow to receive or invoice more qty or lesser qty than ordered qty.

Remove Delivery reminder on PO line(make it zero), and Try to perform product receipt if possible. Then generate invoice with qty 2 . You will not get any error

Was this reply helpful? Yes No
Prashant Singh 8,802 on at

Like (0)

Report

RE: Purchase order invoicing error and get the Msg. "Unable to Invoice due to update quantity is greater than remaining quantity Order Line"

Dear PrasitP.,

When ever you have multiple receive and multiple invoice in this case you may face this issue. Please do the invoice product receipt wise. In this such situation will not be created.

Invoice qty should not be more than delivery reminder if you are modifying the product receipt qty.

If product receipt is not updating financial you need to check you parameter setup of AP and item model group.

When ever you do product receipt system system updated the delivery reminder qty. If system is not doing so, you can clear the cache and restart the AOS server. You will get it updated.

Regards,

Prashant Kumar

Was this reply helpful? Yes No
PrasitP. 152 on at

Like (0)

Report

RE: Purchase order invoicing error and get the Msg. "Unable to Invoice due to update quantity is greater than remaining quantity Order Line"

Dear All,

Thank you for all of your advice, After investigate the problem then I got the solution for this issue but I'm not sure this is the best solution.

1. I update the data in table:PURCHLINE: PURCHSTATUS to be "2" (2=Received)

2. Delete the record in tabale:VENDPACKINGSLIPTRANS and VENDPACKINGSLIPJOUR by PACKINGSLIPID

3. Start the process of Product receipt again.

After checked the data is ok.

Regards,

PrasitP.

Was this reply helpful? Yes No