About Wildcard Characters in Account Numbers

You can use two wildcard characters when specifying account numbers:

Using Wildcard 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:

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.