Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

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

    • 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

    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