Panel | |
---|---|
|
...
- From the Utilities menu select 'Account filters'
- Click on
- Enter in the required information:
Filter Name: Enter the name for the filter (this is a required field).
Active box will be checked by default. Unchecking this Active box will inactiviate the account filter and prevent the account filter from showing in the account filter dropdowns on certain reports. When an Inactive account filter is used on a saved report, the report will return no results.
- Enter the Order number in which the information should be entered and processed. When assigning order numbers, it is important to assign the more detailed accounts with lower order numbers (e.g. 1, 2, 3 ...) and the less detailed accounts a higher order number.
- Click on to add accounts and check all boxes that apply (hover over the letter C, R, U etc and it will display a tool tip of what each letter means.) Leaving a checkbox blank indicates that access will not be granted.
- C = Create which allows the user to create accounts for that filter
- R = Read which allows the user to view the accounts for that filter
- U = Update which allows the user to modify accounts for that filter
- D = Delete which allows the user to delete accounts for that filter
- P = Preencumbrance which allows the user to post requisitions against that filter
- E = Encumbrance which allows the user to post purchase orders against that filter.
- 'Wildcards' (% symbol) can be used in the account dimensions when giving access to more than one account. For example:
Ranges (value1..value2) can be used in the account dimensions when giving access to ranges of accounts. For example:
Note title Range The start and end values in a range must be a specific value. Wildcards cannot be used in combination with a range. For example, 400..999 will include accounts with 400, 500, 600, 700, 800, and 900 object codes.
To exclude accounts from user, create a row with the account dimensions and leave the Access check boxes blank.
Note title Exclude Accounts When excluding accounts, these rows generally need to be at the top of the Account Filter Grid. If there are any rows prior to the row to exclude that give access to the account, it will not be excluded. Moving the exclude rows to the top will ensure those are recognized first.
- To Insert an Item line, click the Plus sign to add a line below the current line:
- To mass add the access on several account filter lines, click on highlighting the filter rows blue. To unselect all, double click Select All button. You can also unselect specific account filter lines which will un-highlight the row blue. Once the desired filter lines are chosen, apply to select the access to those selected rows. A Pop Up box will allow user to select access to be applied to the selected account filter lines. Click OK to save to all chosen filter rows.
- Click on to create the account filter, click on to not create the account filter and return to the Account filter gird.
...
TI | Account Type | Relevant Fields |
---|---|---|
00 | Cash Accounts | Fund, SCC |
01 | Appropriation Accounts | Fund, Function, Object, SCC |
02 | Expenditure Accounts | Fund, Function, Object, SCC, Subject, OPU, IL, Job |
03 | Revenue Accounts | Fund, Receipt, SCC, Subject, OPU |
...