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:
+ "HAVING "
+ (matched ? "0" : "lin.QtyInvoiced")
// 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");
Swing and ZK