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