Specifies a filter to specify the general ledger accounts that will be shown in an Analysis by Dimensions window. By setting filters, you can define that only entries posted to the specified accounts will be shown in the matrix window. To see 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 | Records Included in Breakdown |
---|---|---|
Equal to | 6210 | Account 6210. |
Interval | 5510 .. 5531 | Accounts 5510 through 5531. |
Either/or | 1200|1300 | Those with account 1200 or 1300. |
Different from | <>1200 | All accounts except 1200. |
You can also combine the various format expressions:
Sample Expression | Records Included in Breakdown |
---|---|
5999|8100 .. 8490 | Include any records with the account 5999 or an account from the interval 8100 through 8490. |
..1299|1400.. | Include records with an account less than or equal to 1299 or an account equal to 1400 or greater than (all accounts except 1300 through 1399). |
Tip |
---|
For more information about how to work with fields and columns, see Work with Data. For more information about how to find specific pages, see Search. |