Friday Feature - Searching for Accounts Using a Series
Over the last few weeks, you have seen how to search for accounts with blank components and using wildcards. Now, it is time to search for a series of accounts I want to review. Let's say that I only want to see the benefit accounts for certificated management at the local high school. Seems complicated, but it is easy-squeezy using component lookups and the "series" capability. Check it out.
With this search, I limited my results to only those accounts with the following attributes:
- Certificated benefit account object - Separated by commas, I entered the four objects that are used for certificated benefit accounts: 3101, 3301, 3501, 3601.
- Location - Using the lookup, I selected the local high school.
- Bargaining Unit - Using the lookup, I selected the management bargaining unit.
And, the results are perfect!
I get exactly the four accounts I want. I can see the total for each account and a grand total for the balances, encumbrances, expenses, adopted and revised amounts at the bottom of the list. And, I can double-click on each account to produce a report listing all of the account's activity for the fiscal year.