Creating Intercompany Matching Reports

To create Intercompany Matching reports, you select the POV members, accounts, and matching accounts that you want to display. You can also select whether to suppress display of dimension members, and data cells associated with a specific variance.

To create an Intercompany Matching report:

1. On the Home page, click Reports.
2. Click Intercompany Reports.
3. From the Point of View, select a single member for the following dimensions: Scenario, Year, Period, View, Consolidation, and Currency.

   The Currency must be a Reporting Currency. If you select entities that have a common Parent entity, you can select the Parent Currency member for the report. The dimension members that you select will be displayed in the header section of the generated report.

   Tip:

   The Dimension names (Consolidation, View, and so on) are displayed by default. To hide the Dimension names and display only the members, click the Actions icon, and then select Hide Dimension Names.

4. For Entity and Partner, enter an entity name, or click the Member Selector and select an entity.

   Entities can be both ICP and non-ICP enabled.

   If you specify any Consolidation member within the FCCS_Entity Total hierarchy, the report displays the member name in the Entity column without the Parent member reference, because both primary entity and shared entity instances are the same.

   If you specify a node-level Consolidation member (any member above FCCS_Entity Total), the report displays the member name in the Entity column using the [Parent].[Child] format, because the node-level data could be different for each [Parent].[Child] pair.

5. Optional: For Plug Accounts, select the Plug Account checkbox, then select the accounts to include, or select All.
6. If you do not select Plug Accounts, select the Accounts and Matching Accounts for the report.
   You must select both the Account and Matching Account. The accounts must be valid Intercompany accounts. You can specify the same Account and Matching Account, but you can select only one set of the same member in Accounts and Matching Accounts. The report will be generated for the accounts to which you have access.
7. For Suppression/Group Dimensions, select members and then select a suppression option:

   To select members, you can click the Member Selector, or specify the member names in text, with each member delimited by a comma.

   • Not Suppressed

   • Suppressed

   • Group - If you select this option, you can only select base members.

8. For Suppression Options, select one or more options:

   • Suppress Matches - click to select this check box.

   • Tolerance Value - enter a value.

   • Tolerance Percent - enter a percent. The value must be a positive number less than or equal to 100.

   • Reversals - select this check box to suppress the reversal Entity/Partner rows.

   • Blank Columns - select this checkbox to suppress columns with no values.

     For details on suppression options, see Setting Up Intercompany Matching Reports.

9. Select Display Options:

   • Report Title - enter a report title or use the default.

   • Scale Factor - enter a value between 0 and 9.

   • Decimal Override - enter an integer between 0 and 6.

   • Member Display - select Name, Description, or Both.

10. From Report Type, select an option:
    • HTML
    • PDF
    • XLSX
11. To run the report, click Run Report and then select to open or save the report.
12. Optional: To save the report as a job, which you can schedule to run immediately or at a later time, set the Location field to Outbox, then click Save as Job, enter a job name and click Submit.