About Defining a Data Load to Import Balances into Account Reconciliation
A data load definition enables you to import balances that you set up using Data Management or Data Integration.
Defining a data load is especially useful when you want to import balances multiple times, which is usually the case. Once a data load is defined, you can execute the data load to load balances, view the results, and correct any errors.
Loads for the same period must run sequentially for each location, they cannot be run in parallel. Data load definitions can be configured to run Location by Location as needed when load timing is similar across locations. For example, if Location A and B have balance files arriving at the same or similar times, they can be scheduled to run back to back (sequentially) by configuring them in the same data load definition.
By default, data load rules are run one at a time and the system waits for the data load rule job to complete before starting another. However, by using the Execute data load rules in parallel check box, you can run all data load rule jobs at once and the system waits for all data load rules to complete before setting staging to complete. This is useful to increase performance when processing large data sets.
Automatic Translation of Imported Balances into Higher Currency Buckets
When loading balances using Data Management, if the source system does not natively provide balances in all currency buckets, the load process translates the imported source system or subsystem balance and loads it into configured higher currency buckets. Currency translation is useful in scenarios where the source is a transactional system that typically stores only Entered balances.
The currency translation is performed using the configured currency rates. If currency rates are not available, the currency translation fails. To enable automatic translation of imported balances, you must select Translate balances to higher currency buckets while defining the data load. See Steps to Create and Save a Data Load Definition.
Depending on which currency buckets are configured, the translation options (in order of priority) are:
- Entered balance to Functional balance
- Entered balance to Functional and Reporting balance
- Functional balance to Reporting balance