Extracting Intercompany Transaction Files

You can extract intercompany transaction files if you have the Intercompany Transaction User or Administrator security role. You can specify whether to extract matched, unmatched, mismatched, posted, or unposted transactions, and transactions with a specific transaction currency, match code, or reason code. You can also extract the list of reason codes defined in the application.

To extract intercompany transactions:

1. Select Consolidation, then Extract, and then IC Transactions.
2. From the Point of View bar, select the scenario, year, and period.
3. Enter the names of the Entity and Partner dimension members, or click Browse to find the Entity and Partner members.
4. Select one or more types of transactions to include in the extract process:

   • Matched

   • Unmatched

   • Mismatched

   • Posted

   • Unposted

5. From Reason codes, select a reason code, or leave the default option of All.
6. From Transaction Currency, select a transaction currency for which to extract transactions, or leave the default option of All.
7. For Transaction Match Code, enter a match code value, or use the percent sign (%) as a wildcard.
8. Optional: To extract a list of reason codes defined in your application, select Include list of Reason Codes.
9. Click Extract.
10. From the confirmation prompt that the extract was successful, click OK.
11. Click the Download link and select Save.
12. Enter a name for the extracted file and make sure that the location for the file is in the directory that you set up.

    Note:

    By default, transaction files use the TRN file extension.

13. Click Save.