Account Filter Field, Analysis View Table
Specifies a filter to specify the general ledger accounts that will be included in an analysis view. By setting filters, you also specify that only entries posted to the filter accounts will be included when an analysis view is updated. To select among the G/L accounts in the chart of accounts, choose the field.
You can enter a maximum of 250 characters, both numbers and letters. There are certain rules for how these can be combined:
| Meaning | Sample Expression | Included in Update |
|---|---|---|
Equal to |
6210 |
Entries from account 6210. |
Interval |
5510 .. 5531 |
Entries from accounts 5510 through 5531. |
Either/or |
1200|1300 |
Entries with account 1200 or 1300. |
Different from |
<>1200 |
All accounts except 1200. |
You can also combine the various format expressions:
| Field | Description |
|---|---|
5999|8100 .. 8490 |
Include any entries with the account 5999 and in accounts from the interval 8100 through 8490. |
..1299|1400.. |
Include entries with an account less than or equal to 1299 or an account equal to 1400 or greater (all accounts except 1300 through 1399). |
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Analysis View Table | General Ledger |
| Analysis View Table | General Ledger |
| Analysis View Table | General Ledger |