Account Totaling Field, VAT Statement Line Table
Specifies an account interval or a series of account numbers. You can enter a maximum of 30 characters, both numbers and letters.
When you enter account numbers in the field, the total balance for the accounts will be added up.
Note
You do not need to enter anything in this field unless you have selected Account Totaling in the Type field.
The Accounts Totaling field is a type 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:
Description | Sample Format | Means |
---|---|---|
Equal to |
377 |
Account 377 |
Interval |
1100..2100 ..2500 |
Accounts 1100 through 2100 Accounts up to and including 2500 |
Either/or |
1200|1300 |
Accounts 1200 and 1300 |
You can also combine the various format types:
Sample Format | Means |
---|---|
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 |
---|---|
VAT Statement Line Table | General Ledger |
VAT Statement Line Table | General Ledger |