Totaling Field

The G/L Account Table

Here you can enter an account interval or a list of account numbers.

The program will total the entries of the account numbers displayed in the field to give a total balance. How the field is completed depends on which account type you selected in the Account Type field:

Attention

For accounts of the End-Total type, the Totaling field can be filled in manually. It is, however, best to let the Indent function fill in the field.

You can enter a maximum of 250 characters, both numbers and letters. The Totaling field is a kind of filter field because what is entered in the field limits the number of accounts used by the program to calculate the total balance. There are specific rules for what you can enter:

Meaning

Sample Expression

Accounts Included

Equal to

377

377

Interval

1100 .. 2100

..2500

1100 through 2100

Up to and including 2500

Either/or

1200|1300

1200 and 1300

And

<2000&>1000

Those with a number less than 2000 and greater than 1000

Different from

<>1200

All except 1200

Greater than

> 1200

Those with a number above 1200

Greater than or equal to

>=1200

Those with number 1200 or above

Less than

<1200

Those with a number less than 1200

 

 

 

You can also combine the various format types:

5999|8100..8490

Account 5999 and accounts 8100 through 8490

..1299|1400..

Accounts up to and including 1299 and accounts 1400 and above, that is, all accounts except 1300 through 1399