About Defining a Balance Load to Import Balances into Account Reconciliation
A balance load enables you to import balances that you set up using Data Management or Data Integration.
Defining a balance load is especially useful when you want to import balances multiple times, which is usually the case. Once a balance load is defined, you can execute the balance 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. Balance loads 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 balance load.
By default, data integrations are run one at a time and the system waits for the Data Integration job to complete before starting another. However, by using the Execute data integration in parallel check box, you can run all Data Integration jobs at once and the system waits for all data integrations 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 Integration, 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 balance load. See Steps to Create and Save a Balance Load Template.
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