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.
...
The account filter grid allows the user to search for existing account filters by clicking in the filter row in the grid columns and entering in the desired information. Click on any row of the search results to see a summary view of the record. The Advanced Search can be utilized by clicking on the in the upper right side of the grid.
...
There are some account filters that are automatically created in USAS-R. These filters work with specific processes or reports and are labeled as "ssdt" filters.
Filter Name | Description |
---|---|
ssdt-eisClassicAutomaticFilter | When the EIS Classic Integration Module is enabled and the EIS Classic Integration Configuration is set to Automatic, this filter is used by the system to mark EIS Items on Invoices for the EIS Pending Extract. This filter will only appear if the EIS Classic Integration Module has been enabled. |
ssdt-eisClassicEnabledFilter | When the EIS Classic Integration Module is enabled and the EIS Classic Integration Configuration is not set to Automatic, this filter is used by the system to flag potential EIS Items on Invoices for the EIS Pending Extract. This filter will only appear if the EIS Classic Integration Module is enabled. |
ssdt-moe | Used in generating the SSDT Budget Summary MOE report. |
Transaction Indicators
The TI field in the Account Filter indicates which level of accounts the filter row will apply to. Only fields relevant to that TI will be used in that filter row.
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 |