Defining a Period for Reconciliation Compliance Transactions

Account Reconciliation transactions must be loaded to one period. To do this, use global mappings to map various periods to one period.

To define a global mapping period for Reconciliation Compliance Transactions:

1. From the Data Integration home page, and then from the Actions menu, select Period Mapping.

   Specify the date in MM/dd/yyyy format.

2. Select the Global Mapping tab.

3. Click .

4. In Period Key, specify the last day of the month of the current fiscal year to be mapped from the source. This is a date value that is stored in the database during the trial-balance load process and that becomes part of a key that identifies a set of trial-balance records.

   Specify the date in MM/dd/yyyy format.

   The Reconciliation Compliance Transactions load uses the Period Key and Prior Period Key defined in Data Integration to determine the source General Ledger periods mapped to each Data Integration period when the integration is run.

5. Select the Prior Period Key, specify the prior fiscal period key that is used during export.

   The Prior Period Key is just one month earlier to your current period key.

   The Prior Period Key is just one month earlier to your current period key.

6. Complete the following:

   1. Period Name; for example, July 2018

   2. Target Period Month; for example, August

   3. Target Period Year

   4. Target Period Day

   5. Year Target

7. Click Save.