Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

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

    • Article Type: General
    • Product: Voyager
    • Product Version: 7.1.0

    Description:
    Bug Report Form for Issue 16384-11201

    Module: Acquisitions
    Release(s): reported in 7.1.0, replicated in 7.2.1
    Server Platform(s) affected: Solaris/all
    PC O/S (if this is PC specific): n/a
    Browser type & version (if WebVoyage): n/a

    Expected Results: Invoice approval should not be allowed if the Amount and Total Invoice Amount fields are not the same.

    Actual Results: 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).

    Workflow Implications: Operators may be confused about which is the correct value; if reporting tools are using the Amount value, report totals may be incorrect.

    Replication steps: Unable to reproduce at will locally or at customer site, but can clearly see evidence of the problem in the tables/client.

    Other 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;

    Resolution:


    • Article last edited: 3/13/2015
    //doorbell.io feedback widged