Invoice Vendor (create lines from..) - Error - Total matched qty > movement qty

Description

Error message "Total matched qty > movement qty" is issued under the following situation:

Purchase Order OrderQty=100
Partial MR(1) Qty=50
Partial Invoice Vendor(1) 30/11/17 => Create Lines From...=>Select MR qty=50
Partial Invoice Vendor(2) 01/12/17 => Create Lines From...=>Select PO=>System derives remaining qty=50 (the second partial invoice is recorded BEFORE the second partial MR)

Field "Receipt Line" (m_inoutline_id) in the vendor invoice(2)-Line is populated with MR(1)-Line(1), which is incorrect. The field "Receipt Line" should not be populated in this line because the second partial MR has not been recorded yet. There should only be a matched PO document (not a matched invoice document) for the second invoice line at this stage. As a result of this incorrect receipt line assignment (field is read-only), error message "Total matched qty > movement qty" is issued and the 2nd invoice document can't be completed.

Interestingly, it seems this issue only occurs when the 2 partial quantities are the same, in this example 50 and 50. I did not encounter this problem when simulating a PO with qty=100, MR(1) qty=30, invoice(1) qty=30 and invoice(2) qty=70.

Environment

None

Activity

Show:
Prakarn Krisungnoen
December 11, 2017, 3:39 AM

Hi,
I confirm this is an error.
The cause of error because line no 489 of CreateFromInvoice.java.
It try to search for available MR for you if you select PO during Invoice Create From. And it's only compare enter quantity and MR quantity without check that MR already refered by invoice.

Assignee

Carlos Ruiz

Reporter

Michael Powacht

Labels

None

Tested By

None

Components

Fix versions

Affects versions

Priority

Major
Configure