The COA Cross Reference function lets you to map GL accounts, sub-accounts, cost centers, and projects in source entities to GL combinations in consolidation entities. In addition, you can also use COA Cross Reference Create (25.3.14.1) to define mappings from GL combinations to alternate COAs. The alternate COA mappings can be used to group and report data in statutory reports.

You can create COA cross-references from the source COA elements to the target COA elements in a many-to-one relation. For example, you can map a range of source GL accounts to a single GL account in the target domain.

When creating an alternate COA mapping, you do not need to specify a target domain; alternate COA mappings are created at the system level.

By selecting the Validate option at the end of COA Cross Reference Create, you can validate the cross-references that you have defined against posting history. If the cross-reference type is Separated COA Dimensions or Combined COA Dimensions, you can indicate whether to validate the sub-account, cost center, or project. See COA Cross-Reference Types.

If gaps exist in the cross-reference mappings used in a report or consolidation, the system displays an error. If there are any overlaps in the cross-reference mappings you create, the system uses the first mapping record it finds in the grid.

Alternate COA Structure and Mapped Values shows the alternate COA structure from Alternate COA Structure, updated to show the operational elements to which the alternate accounts are mapped.