Wildcards are characters that can be used to represent all or some characters in a Cost Account. All Cost Accounts that match are included.
The Wildcard characters are the underscore, '_' and the percent symbol, '%'. The underscore represents one character, and the percent symbol represents one or more characters.
Using Wildcards in the Costing Report
To generate the Costing Report using wildcards:
Go to Payroll, Reports, End of Pay, Costing Report.
Tick Search Cost Account using Wildcards.
In Cost Account, enter a Cost Account and wildcard combination.
Select any other parameters and options required to generate the report.
Print or Preview the report.
Using Wildcards in the General Ledger
Wildcards are used to include Cost Accounts that match the pattern. They cannot be used to exclude specific Cost Accounts. If you need different groups of Cost Accounts sent to different Ledger Accounts, use non-overlapping partial wildcard patterns or individual Cost Accounts so that Cost Accounts are not included multiple times.
To generate the General Ledger using wildcards:
Go to General Ledger Integration, Maintenance, Batches, Batches.
Edit the Batch.
Click on the Details tab.
Edit the detail line.
In Cost Account, enter a Cost Account and wildcard combination.
Select any other parameters and options required for your General Ledger.
Click OK and OK again to save the changes.
To produce the GL, go to General Ledger Integration, Transactions, Batch Process.
Example using Wildcards in Cost Accounts
If your Cost Account structure was made up of 3 levels:
STATE-DEPARTMENT-NUMERICAL CODE
Where you had:
State - All States including NSW and VIC
Department - Multiple Departments, including ADM and SAL
Numerical Code - Multiple Codes including 1000, 0001 and 0010
If you used Wildcards and entered the Cost Account with the following combinations, the results would be:
Cost Account and Wildcard | Result |
NSW% |
|
NSW-ADM% |
|
_ _ _ _ADM% |
|
_ _ _ -ADM% |
|
%ADM% |
|
%1000 |
|
_ _ _ _SAL%1% |
|
%1 |
|