- Knowledge Base Categories:
- School Accounting System
Training Tidbit: Is there a way to print reports with masks and wildcard characters?
Yes, when printing a report in the School Accounting System, wildcard characters can be utilized in the From field for parameters. The wildcard characters are _ for one character and % for an unlimited number of characters.
One particular place where the wildcard characters are frequently used is with the parameter for account numbers on an Account Inquiry report in General Ledger. Below are two examples of masks using the wildcard characters for the parameter for account numbers in order to print all the expenditure accounts for the General Fund instructional supplies. The first example will result in all account numbers having the exact structure and specified numbers printing on the report (those account numbers with optional pieces not utilized at the end or having additional pieces beyond what is included in the mask will not print). The second example will result in all account numbers having the specified numbers printing on the report (including those that have optional pieces at the end that are or are not being utilized).
EXAMPLE 1
Iowa – 10 _ _ _ _ 1_ _ _ _ _ _ _ _ _ _ 6_ _
(Example using expense account structure of Fund – Facility – Function – Program – Project – Object)
Idaho – 100 5 _ _ 4_ _ _ _ _ _ _ _ _ _ _ _
(Example using expense account structure of Fund – Function – Object – School – Project – Location)
Illinois – 10 11_ _ 4_ _ _ _ _ _
(Example using expense account structure of Fund – Function – Object – Operational Unit – Source of Funds)
Kansas – 06 1_ _ _ 6_ _ _ _ _
(Example using expense account structure of Fund – Function – Object – Operational Unit)
Missouri – 10 11_ _ 64_ _ _ _ _ _ _ _ _ _ _ _
(Example using expense account structure of Fund – Function – Expenditure Object – Location – Source of Funds – Project)
Nebraska – 01 11_ _ 4_ _ _ _ _
(Example using expense account structure of Fund – Function – Object – Building)
North Dakota – 01 _ _ _ _ _ _ _ _ _ 1_ _ _ 6_ _
(Example using expense account structure of Fund – Project – Organization – Program – Function – Object)
South Dakota – 10 11_ _ _ _ _ 4_ _
(Example using expense account structure of Fund – Function – Operational Unit – Object)
Wyoming – 01 _ _ _ 11_ _ 4_ _ _ _ _
(Example using expense account structure of Fund – Facility – Function – Object – Subject)
EXAMPLE 2
Iowa – 10 _ _ _ _ 1_ _ _ _ _ _ _ _ _ _ 6%
(Example using expense account structure of Fund – Facility – Function – Program – Project – Object)
Idaho – 100 5 _ _ 4%
(Example using expense account structure of Fund – Function – Object – School – Project – Location)
Illinois – 10 11_ _ 4%
(Example using expense account structure of Fund – Function – Object – Operational Unit – Source of Funds)
Kansas – 06 1_ _ _ 6%
(Example using expense account structure of Fund – Function – Object – Operational Unit)
Missouri – 10 11_ _ 64%
(Example using expense account structure of Fund – Function – Expenditure Object – Location – Source of Funds – Project)
Nebraska – 01 11_ _ 4%
(Example using expense account structure of Fund – Function – Object – Building)
North Dakota – 01 _ _ _ _ _ _ _ _ _ 1_ _ _ 6%
(Example using expense account structure of Fund – Project – Organization – Program – Function – Object)
South Dakota – 10 11_ _ _ _ _ 4%
(Example using expense account structure of Fund – Function – Operational Unit – Object)
Wyoming – 01 _ _ _ 11_ _ 4%
(Example using expense account structure of Fund – Facility – Function – Object – Subject)
Important Note: Be sure to key the spaces when keying a mask on the Report Printing Options screen.