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

    When using extended fund allocation with percentages, amounts don't match in all tables

    • Product: Voyager
    • Product Version: 9.2.0, 9.2.1
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Symptoms

    • Using extended fund allocation, amounts stored in PO_FUNDS / LINE_ITEM FUNDS and INVOICE_FUNDS / INVOICE_LINE_ITEM_FUNDS don't match.
    • Amount in LINE_ITEM_FUNDS and INVOICE_LINE_ITEM_FUNDS off by $0.01

    Defect Status

    Issue VYG-6851 is resolved in Voyager 9.2.1 and higher.

    Replication Steps

    1. Create purchase order (PO)
    2. Add line item with price $208.09
    3. Click Detailed Line Item > Copies/Funds
    4. Edit funds > Extended Fund Allocation
    5. Using Percentage, allocate this total across four different funds
      1. 33% (68.6697)
      2. 37% (76.9933)
      3. 16% (33.2944)
      4. 14% (29.1326)
    6. Save
    7. Totals in client show additional penny added to first fund:
      1. 68.68 (66.6697)
      2. 76.99 (76.9933)
      3. 33.29 (33.2944)
      4. 29.13 (29.1326)
    8. Total for first fund (33% allocation) is 68.67 in PO_FUNDS and INVOICE_FUNDS, and 68.68 in LINE_ITEM_FUNDS and INVOICE_LINE_ITEM_FUNDS

    Workaround

    Use amounts instead of percentages for extended fund allocation.


    • Article last edited: 21-Mar-2017