Account Reference Syntax and Examples
Account number references can use the following symbols:
Symbol | Description |
---|---|
Hyphen - | An account segment separator defined on the G/L Options screen in General Ledger. (The hyphen is the default separator.) |
Colon : | Separates account numbers in a range. |
Tilde ~ | Separates segment codes in a segment range. |
Note: All examples assume that segment 1 is the account segment and segment 2 is the department segment.
Standard Account References
Format | Description | Examples |
---|---|---|
aaaaaaaa
or aaaa-aaaa |
A specific General Ledger account number composed of one or two segments. Account numbers can be entered with or without the segment separator -. However, if you are specifying ranges of accounts, we suggest you include separators to remove ambiguity from your specifications. |
100-C
Account 100, department C. |
aaaa-A:bbbb-B |
A range of General Ledger accounts and departments. When creating a search statement from the information you enter, Financial Reporter adds Zs to the last number in the range. In other words, it searches for account numbers between "aaaa-A" and "bbbb-BZZZZZZZZZZZZZZZ". |
|
aaaa%%
or aaaa:aaaa |
A range of General Ledger account numbers. (The wildcard notation %% is a simpler way of specifying all accounts with the same segment.) |
100%% or 100:100 All accounts that start with 100, regardless of account structure. |
aaaa~bbbb-A |
A range of General Ledger account numbers with a fixed second segment. Financial Reporter retrieves information from each account within the range that includes the second segment code. |
|
aaaa~bbbb |
A range of General Ledger account segment codes. Financial Reporter retrieves all accounts matching the account segment you specify, no matter how many segments are in the number, and no matter where the account segment is in the account structure. This allows you to specify a range for one segment (rather than a range of complete account numbers), and is particularly useful when the account segment is not the first segment in the account number. |
4000~8000 Accounts with an account segment code from 4000 to 8000, no matter how many segments are in the number, and no matter where the account segment is in the account structure. For example, results will include 10-4000, 20-5000, and 10-6000 if those accounts exist in General Ledger. |
aaaa[ACCT], bbbb~cccc-A[MANU] |
An individual account number and a range of account numbers. The square brackets indicate the account structure codes used by the account numbers. | |
aaaa-%, bbbb~cccc-A~B, gggg-D |
A set of ranges and individual accounts with each specification separated by a comma. |