Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. How are the foreign currency conversion rates calculated?

    How are the foreign currency conversion rates calculated?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Voyager
    • Product Version: All
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    Question

    How are the foreign currency conversion rates calculated?

    Answer

    1. Voyager collects currency amounts listed for actual commitment or expenditure from fund:
    1.a. line_item charges from LINE_ITEM_FUNDS (PO) or INVOICE_LINE_ITEM_FUNDS (invoice)
    1.b. "other" charges from FUND_PAYMENT
    1.c. other tables with amounts to contribute: LINE_ITEM.PRICE and LINE_ITEM.PRICE_ADJUSTMENT

    2. Charges subtotaled by fund.

    3. Subtotals for each fund converted to base currency so that the fund balances can be adjusted.
    3.a. If the PO (or invoice) not Approved, conversion rate is assumed to be a floating rate and uses current CONVERSION_RATE from CURRENCY_CONVERSION table.
    3.b. If the PO (or invoice) is Approved, conversion rate is assumed to be fixed at time of approval and uses CONVERSION_RATE from PURCHASE_ORDER (or INVOICE) table, where it was stored during the approval process.

    4. Once the fund subtotals are converted to base currency, funds are updated, and a record of the current commitment/expenditure levels is saved in the PO_FUNDS (or INVOICE_FUNDS) table.

    Additional Information

    What is base currency?

    Category: Acquisitions


    • Article last edited: 3/5/2015
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How are reports produced when running Fiscal Period Close?
      • How can a record be removed from an import file once the record has been saved to Voyager?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. Acquisitions
      2. all
      3. contype:kba
      4. Dedicated-Direct
      5. Direct
      6. Local
      7. Prod:Voyager
      8. Total Care
      9. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved