Translating and summarizing intercompany data

Financial Consolidation Only

Before reviewing and balancing the reported intercompany data, use the Summarize IC Data page to:

  • Translate the intercompany data into local currency for the selected unit.
  • Summarize the detail for each intercompany line into a total line for the selected specifying unit. This total line replaces the breakdown of different amounts specified for each affiliated unit for the same line and replaces it with a single total amount for that line.
  • Update a different database table with the local, summarized data than when submitting data from the Intercompany Data Entry page. This database allows reports like the ad hoc report to display the intercompany data.

To display in the list, a journal's periodicity, effective life, and version must correspond with the selected period range and version. If you change the default settings for period/year and version, click Update Journal List to display the journals applicable to your new selection. If necessary, a scroll bar is available for the journal list, which holds up to five journals.

  1. Open the Summarize IC Data page.
  2. From the Start and End lists, select the period range for the reported intercompany data.
  3. From the Version list, select the version for the reported intercompany data.
  4. From the Journals section, select the Intercompany Eliminations journals you want to create. Select the Select All Journals check box to select all journals.
    To show in the list, a journal's periodicity, effective life, and version must correspond with the selected period range and version. If you change the default settings for period/year and version, click Update Journal List to show the journals applicable to your new selection. If necessary, a scroll bar is available for the journal list, which holds up to five journals.
  5. To change these dimension members, click the underlined dimension name, and select members from the dialog box. Read-only or no-access members are not available for selection.
    1. Organization Unit. Select one reporting unit. Only reporting units involved in intercompany activity display in the list. Only the account associated with the selected unit is processed. The account associated with the affiliated unit is not processed.
    2. Product/Sales Channel. Select one or more custom dimension leaf members involved in intercompany activity. Selecting a parent member as Self automatically includes the implied descendants in the journal data generation. The report only displays the parent member. To avoid duplicate members being included in the journal data generation, do not select a parent member and any of its descendants.
  6. Click Create Data. Any subsequent consolidation does not roll up this local intercompany data.