Matching invoice Receipts window shows matched documents as not matched

Description

When material invoices are matched by receipts using the Matching form, invoices that are matched will continue to appear in the search for Not Matched invoices.

The issue is that very small differences in quantities are still measured as non-zero and the invoices appear in the query. These differences could be due to the representation of numbers.

Recommend that the test for a matched invoice be the standard precision of the UOM and that differences smaller than that be considered zero.

Suggested that we change the test for matching in Match.java to something like this:

FROM
+ "HAVING "
+ (matched ? "0" : "lin.QtyInvoiced")
+ "<>SUM(NVL(mi.Qty,0))";

TO
// Very small values are equivalent to zero. Round to the product standard precision.
+ "HAVING round(lin.QtyInvoiced-SUM(NVL(mi.Qty,0)),uom.stdprecision)"
+ (matched ? "=0" : "<>0");
}

Environment

Swing and ZK

Assignee

Michael McKay

Reporter

Michael McKay

Labels

None

Components

Fix versions

Affects versions

Priority

Major
Configure