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

    Voyager "Fund Transactions - All" prepackaged report produces no data when there is a hyphen in the ledger name

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

     

    Question

    Ledger with name "OPERATING B 18-19" has no data when entered as a parameter value for "Ledger Name" in the "Fund Transactions - All" Prepackaged Access Report (PpR), even though there are data for the Fiscal Period specified.  Why?

    Answer

    The "Fund Transactions - All" PpR uses the NORMAL_LEDGER_NAME in the FUNDLEDGER_VW table.  The hyphen is dropped in the "NORMAL_LEDGER_NAME" field.  

    Exclude the hyphen when you enter the parameter value when running your query.

    For example, type this for Ledger Name:

    OPERATING B 18 19
    

    instead of this:

    OPERATING B 18-19

     

     


    • Article last edited: 31-Jul-2019