Page 1 of 1

Using Wildcard Characters in Fund Accounting

Posted: Wed Dec 27, 2006 4:10 pm
by Matt
Does anyone know of any wildcard characters you can use in Fund Accounting (Version 9) in the Reference field when running the Journal Report or looking at View Posted Transactions? For example, if a transaction with reference number 1234 is reversed, the reversed reference number is 1234-reversal. However, if you input reference number 1234 when running the journal report only the transaction with 1234 as the reference number appears. The reversal transaction does not appear, even though the 1st four digits of the reference number are the same. It would be great if you could input a wildcard character after the 1234 on the reference number to pull up both transactions.

Posted: Wed Dec 27, 2006 4:17 pm
by Zorak
The reference fields are a range, so running the journal report FROM 1234 TO 1234-REVERSE will get both transactions.