Importing Pre-Mapped Transactions
When you import pre-mapped transactions, you enable authorized users to import Explained Balance, Source System Adjustments, or Subsystem Adjustments transactions into reconciliations, where the transactions have already been pre-assigned an account ID. The imported transactions are inserted into the existing Account Reconciliation transaction tables (including the summary amounts table), and assigned the appropriate account ID, period ID and transaction type.
These transactions are importable regardless of whether a reconciliation for the period exists (the data is keyed off of Account ID and Period ID, not Reconciliation ID).
Note:
Preparers should be able to import transactions regardless of whether reconciliation exists or not. For role checking, use profile security.
The following users are authorized to use the import feature, subject to the security rights noted:
- Administrator
-
All reconciliations
- Power User
-
Reconciliations included within the Power User’s security filter
- Preparer
-
Reconciliations where the user is assigned the Primary Preparer role, or the Backup Preparer role, where the user is currently the Active preparer (because the primary is unavailable), or a member of a Team/Group assigned the Preparer role, regardless of the Claimed status.
Note:
To give other roles the ability to use the import feature, adjust the format definition to allow editing of transaction attributes. See Adding Format Attributes.
To import pre-mapped transactions: