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.

If you enabled additional cubes in the application, a Cube dropdown is displayed on the Intercompany Report Jobs list page, where you can select a cube for the report, for example, Consol2. By default, the cube is Consol. When you create any report in the selected cube, the cube name that you selected is displayed but disabled on the creation page. The dimension member selection and validations are based on the selected cube. The Cube information will also be displayed in the header section of the generated report. For information on enabling cubes, see "Adding Application Cubes" in Administering Financial Consolidation and Close.

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.

   You can also specify substitution variables for POV members. The information is stored as part of the report definition, and the variable values are used for processing the Intercompany Matching Report at runtime.

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.

   If you create a new Intercompany Account member, you must refresh the database so that the Account will be valid and display correctly in the Intercompany Matching report.

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 suppress matches, then enter a value or percent.

   • 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.

   • Intercompany Member Display - select an option to display the member: With ICP Prefix (such as ICP_PA), or Without ICP Prefix

   • Accounts in Rows - select to display the accounts in rows

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.