Setting Up General Ledger > COA Cross-References > Search Order for COA Cross-Reference Mappings
  
Search Order for COA Cross-Reference Mappings
When searching for COA cross-references to use in Chinese GL reports and in consolidation, the system searches for mappings in the following order:
1 Matching account, sub-account, cost center, and project
2 Matching account, sub-account, cost center, and blank project
3 Matching account, sub-account, blank cost center, and project
4 Matching account, sub-account, blank cost center, and blank project
5 Matching account, blank sub-account, blank cost center, and blank project
The following example uses alternate COA cross-references to illustrate how the system searches for and uses cross-reference mappings, and how it treats blank mappings.
Example:  
A user defines the following COA cross-references:

Example Cross-References
 
GL Account
Sub-Account
Cost Center
Project
Alternate Account
1000
10
0100
 
AC-2
1000
 
 
 
AC-5
1000
10
 
White
AC-3
1000
10
0100
White
AC-1
1000
10
 
 
AC-4
The user then runs the Account Transaction Journal report and specifies the cross-reference code for the mappings created in Example Cross-References. At run time, the system searches mappings in the order specified in Search Order for COA Cross-Reference Mappings.
The mappings listed in Example Cross-References are searched in following order:

Search Order
 
GL Account
Sub-Account
Cost Center
Project
1000
10
0100
White
1000
10
0100
 
1000
10
 
White
1000
10
 
 
1000
 
 
 
For the postings listed in Mapping Search Result, the mapping search result is:

Mapping Search Result
 
 
Postings
 
 
GL Account
Sub-Account
Cost Center
Project
Mapping Search Result
1
1000
10
0100
White
AC-1
2
1000
10
 
White
AC-3
3
1000
10
 
I19
AC-4
4
1000
10
0100
 
AC-2
5
1000
10
 
 
AC-4
6
1000
 
 
 
AC-5
7
1000
20
0200
I19
AC-5
8
1000
10
0200
White
AC-3