G/L Account Filter Field

The Analysis View Table

In this field, you can set a filter to specify the G/L 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, 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

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:

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).