ACQ:approved invoices have mismatch b/w Amt and Tot Inv Amt

Symptoms

Some approved invoices clearly have different values in the Amount and Total Invoice Amount fields (in all cases, the correct total is in the Total Invoice Amount field).

Defect Status

Issue 16384-11201/VYG-4471 is currently in Development.

Replication Steps

Unable to reproduce at will locally or at customer sites, but can see evidence of the problem in the tables/client.

Additional Information

To detect instances of the problem, use the following sql:
select
invoice_id
, invoice_number
, invoice_status_date
, currency_code
, conversion_rate
, invoice_total
, total
from invoice
where invoice_status = 1 -- Approved
and invoice_total != total;

• Article last edited: 13-Mar-2015