Detail item mapping is done in Transaction Matching. If a match set is assigned to a reconciliation, you must map each data set within the match set to a reconciliation.
Keep these mapping requirements in mind:
-
If the account reconciliation instance is single currency (multi-currency is not enabled), then Local Amount and Item Name must be mapped.
-
If multi-currency is enabled and all reconciliations within the Reconciliation Inventory are multi-currency, then Detail Amount and Item Name must be mapped.
-
If multi-currency is enabled and single and multi-currency reconciliations exist in the Reconciliations Inventory, then Local Amount, Detail Amount, and Item Name must be mapped.
To map detail item information:
-
In Transaction Matching, click Show Match Set Administration page
. -
Click Data Sets and then select a data set.
-
Align the Name column with the alias for the Account Reconciliation column. For example, Attribute 17 (Date) is mapped to the Check Date in Account Reconciliation.
-
In the Detail Item Mapping column, make selections to map which columns in Transaction Matching populate the detail item in Account Reconciliations. For example, the check number will be displayed in the Item Name column.
-
In the Editable column, select which fields will be editable on the Transactions page directly in the grid. The following fields cannot be set as editable: SourceID, S.Cons, Cons, S.Scenario, Scenario, S.Time, Time, S.View, View, S.Origin, Origin, WF Profile, WF Time, and Status WF Time.
NOTE: Even if fields are marked editable, they cannot be edited for matched transactions and transactions that are associated to a detail item in Account Reconciliations.