In this field, you can set a filter to specify the G/L 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, click the AssistButton in 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:
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). |