Totaling Field, Acc. Schedule Line Table
Specifies which accounts will be totaled on this line.
How you fill out this field depends on the contents of the Totaling Type field. If you assign the Formula totaling type to the account schedule line, you can enter a formula that includes row numbers (or totaling intervals) from the account schedule. If the totaling type is Posting Accounts or Total Accounts, you must enter an account number (or totaling interval) from the chart of accounts.
When you use a totaling interval, all the accounts within the range you define (for example, 1900..2100 inclusive) will be totaled.
You can use a formula to perform calculations on other lines. Other lines are referenced through their row number.
You can use the following symbols:
+ (addition)
- (subtraction)
* (multiplication)
/ (division)
^ (exponentiation)
() (parentheses)
% (percent) - If used between two terms, the result is the same as for / (division), but multiplied by 100.
Note
If you want to include a number in the formula, that number must not be used as a row number in your account schedule.
You can enter a maximum of 80 characters, both numbers and letters.
If you use Insert Accounts, this field is automatically copied from the No. field in the G/L account list.
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 |
|---|---|
| Acc. Schedule Line Table | General Ledger |
| Acc. Schedule Line Table | General Ledger |
| Acc. Schedule Line Table | General Ledger |
| Acc. Schedule Line Table | General Ledger |
| Acc. Schedule Line Table | General Ledger |