About Wildcard Characters in Account Numbers
You can use two wildcard characters when specifying account numbers:
- The underline character, _, is a placeholder for one character.
- The percent character, %, is a placeholder for one or more characters.
| Account number specification | Description |
|---|---|
| A123%[sc] | Specifies all single segment account numbers starting with the characters “A123.” |
| D_6834 | Specifies all single segment accounts sharing the same first character (D), followed by one character of any value, and ending with the same four characters (6834). |
Note: You cannot use the Finder with FR Paste to insert wildcard characters. You must type in the wildcard characters yourself.
"%%" is Not a Wildcard Character
Although %% resembles a wildcard character, it is used in only two very specific ways:
- %% specifies all account numbers in the ledger. (See the QUIKINC and QUIKBAL statements that come with General Ledger.)
- 6000%% specifies all account numbers starting with 6000—no matter how many segments they have. (This specification has the same effect as 6000:6000.)
In this example, account number selection is based solely on the account group specified in column B.
|
A |
B |
|---|---|
|
%% |
ACCTGRPCOD=1 |
|
%% |
ACCTGRPCOD=2 |
|
%% |
ACCTGRPCOD=3 |
Financial Reporter will list all Current assets, then all Fixed assets, and, finally, all Other assets.
Unless you process accounts by ACCTGROUP, Financial Reporter must scan every account in the ledger to see if it fits the criterion in column B.
Tip: To get the best performance from Financial Reporter, you should use specific account references, and specify account processing orders that complement the references. For more information, see About Account Order in Financial Statements.
Note also that you cannot combine account reference ranges with wildcard characters. For example, A123%:B567% is not allowed.
However, you can combine account references in a list, such as 1000:1099, 1100~1199-B, 1250-A.
Related Topics