Totaling Field, G/L Account Table
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 |