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

    acq:decimal places to 4 adds incorrectly w/values > 210,000

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

    Description:
    Bug Report Form for Issue 16384-9235

    Module: Acquisitions
    Release(s): reported in 7.0.4; replicated in 7.2.0
    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: Line item totals on an PO/invoice should be added together along with any adjustments, and the total amount should correctly display in the Total Order/Invoice Amount box.

    Actual Results: If the currency in use on the order/invoice is set to 4 decimal places and the total on the order/invoice exceeds around 210,000, the total that displays on the order/invoice is not at all accurate.

    Workflow Implications: Operators are alarmed about whether the client is accurately calculating totals, and if their financial data is corrupt.

    Replication steps:
    Create a new currency that calculates to 4 decimal places:
    In Acquisitions>Ledgers and Funds>Currency, hit New, select a Currency, and set the Decimal Places value to 4.
    Create a PO using the new currency.
    Add a line item with a price of 200,000.0000.
    Add a second line item with a price of 15,000.0000.
    Note the new total – it will be inaccurate (with the above example, I get a total of -214,496.7296).


    Other information: If you split the line items up across several POs/invoices, you’ll be okay.

    Resolution:


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