G/L Account Filter

In this field, you can set a filter to specify the G/L accounts that will be shown in the G/L Balance by Dimension window. By setting filters, you can define that only entries posted to the specified accounts will be shown in the 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

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