You can create mappings using ranges, single elements, or wildcards.

You can map a range of accounts, sub-accounts, cost centers, or projects to the target element in the target entity.

In line 1, all accounts from 1030 to 1099 inclusive are mapped to target account 1100.

In line 2, all accounts from 2000 to 2300 inclusive are mapped to target account 2300.

You can map a single account (or sub-account, cost center, or project) to the target element. In this case, you enter the source COA element in both the Source From and Source To fields.

As a result of the mappings in Single Element Mapping, source account 1030 is mapped to target account 1100 in the consolidation entity, and source account 2000 is mapped to target account 2300 in the consolidation entity.

You can enter an asterisk (*) as a wildcard when creating COA cross-reference mappings.

When an asterisk alone is entered in the Source From field, this means “include all.” Only the Source From field can contain just an asterisk. In this case, any value specified in the Source To field is irrelevant.

 

In Wildcard Mapping, all accounts in the source entity are mapped to target GL account 1100 in the consolidation entity. Specifying account 1030 in the Source To field did not affect the mapping.