Extracting Intercompany Transaction Files

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

You also have the option to extract the list of reason codes defined in the application.

  To extract intercompany transactions:

  1. In the Browser View, expand Tasks and select Extract Tasks.

  2. Select Extract IC Transactions.

  3. From the Point of View bar, select the scenario, year, and period.

  4. Enter the names of the Entity and Partner dimension members, or click Browse to find the Entity and Partner members.

  5. Select one or more options in the extract process: UnMatched, Matched, MisMatched, Posted, UnPosted, and Reason Codes.

  6. To extract transactions with a specific transaction currency, from Transaction Currency Filter , select a currency.

  7. For Match Code, enter a match code value, or use the percent symbol (%) as a wildcard.

  8. For Reason Code, select a reason code.

    Tip:

    To extract a list of reason codes defined in your application, select the check box for extracting reason codes.

  9. Click Extract.

  10. Click the Click Here to Download link and select Save.

  11. Enter a name for the extracted file and make sure that the location for the file is in the Web directory that you set up.

    Note:

    By default, transaction files use the TRN file extension.

  12. Click Save.