Share via

Totaling Field, G/L Account Table

  • Article

Specifies 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:

  • If the account has the type Posting, Begin-Total or Heading, the field must be blank.

  • If the account has the type End-Total, the program will automatically fill in the field when you click Actions, point to Functions, and then click Indent Chart of Accounts. The accounts that are totaled are the ones that lie between one pair of corresponding Begin-Total and End-Total accounts.

  • If the account has the type Total, you must fill in the field yourself to indicate which accounts will be totaled.

Important

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:

Sample Expression

Accounts Included

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

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
G/L Account Table General Ledger
G/L Account Table General Ledger
G/L Account Table General Ledger

See Also

Reference

G/L Account Card