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

Subscribe by RSS
Share page by email
Last updated

Jul 20, 2017
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Voyager
Product Version: 7.1.0

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

01To detect instances of the problem, use the following sql:
02select
03invoice_id
04, invoice_number
05, invoice_status_date
06, currency_code
07, conversion_rate
08, invoice_total
09, total
10from invoice
11where invoice_status = 1 -- Approved
12and invoice_total != total;

Article last edited: 13-Mar-2015