Wildcards are characters that are used in combination with part of the Cost Account to represent the other characters. All Cost Accounts that contain that part of the Cost Account are then included.
The characters that can be used as Wildcards are the underscore, '_' and the percent symbol, '%'. The underscore represents one character, and the percent symbol represents zero 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
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, 001 and 0010
If you used Wildcards and entered the Cost Account with the following combinations, the results would be:
NSW%
All NSW Cost Accounts are included as MicrOpay Evo matches the Wildcard search with any Cost Account that starts with NSW. Any characters after the % are disregarded.
NSW-ADM%
All NSW-ADM Cost Accounts are included as MicrOpay Evo matches the Wildcard search with any Cost Account starting NSW-ADM.
_ _ _ _ADM%
All NSW and VIC ADM Cost Accounts are included as MicrOpay Evo ignores the first four characters, represented by underscores, and anything from the % onwards.
_ _ _ -ADM%
As above. This scenario gives the same result as the previous one. The difference is that the separator (hyphen) is shown in the Wildcard combination, while in the previous one, it was replaced by an underscore. When using Wildcards, remember to account for the separator characters when defining your search.
%ADM%
As above. MicrOpay Evo selects any Cost Accounts containing ADM to include.
%1000
The report includes the following Cost Accounts, as MicrOpay Evo will select any cost account that ends with 1000.
NSW-ADM-1000
NSW-SAL-1000
VIC-ADM-1000
VIC-SAL-1000
_ _ _ _SAL%1%
The report includes the following Cost Accounts. By using this combination, you are asking to include any Cost Account that contains both SAL after the first four characters and a 1 in any position after that.
NSW-SAL-0001
NSW-SAL-0010
NSW-SAL-0100
NSW-SAL-1000
VIC-SAL-0001
VIC-SAL-0010
VIC-SAL-0100
VIC-SAL-1000
%1
The report includes the following Cost Accounts. MicrOpay Evo disregards all characters except the last one, and only selects Cost Accounts that end with 1.
NSW-ADM-0001
NSW-SAL-0001
VIC-ADM-0001
VIC-SAL-0001