Running intercompany reports
Depending on your system you may have several apps that execute intercompany reports. Many of the settings for an intercompany report are pre-defined, but the actual data queried and some of the output options are determined by you when the app is executed. The options available in the report depend on the configuration of the app.
Specifying report options
Depending on the configuration of the app and the dimensions in the database, the exact options available will vary.
Report types and access restrictions
Each type of report has specific behaviors related to symbol access.
| Report type | Description |
|---|---|
Intercompany investment report | Owner entity will not be reported unless you have at least read access to that entity. |
Standard ELIMINATION report | This report will only show data for elimination entities for which you have at least read access. |
Standard GROUPING report | This report will show data without access to elimination entities. |
Standard MATCHING report | This report will show data for all entities you have access to, and all contra entities regardless of access. This report will show data without access to elimination entities. |
Specifying output options
Output options control the overall output of the report. To specify the output options, complete these fields:
| Field | Description |
|---|---|
Output formatted report | Check this option to output the report in a format for printing. If this option is unchecked, the report will generate a text file when executed. |
Generate reporter hierarchy totals | Check this option to generate sub-totals in the report based on the entity hierarchy Note: This option is not available in Standard ELIMINATION reports. |
Display account subtotals | Check this option to generate sub-totals for each group of accounts in the report. Note: This option is available only in Standard MATCHING reports. |
Show unmatched entries | Check this option to display transactions with the reporter entity where the reporter has not submitted a transaction. Note: This option is not available in Standard GROUPING and Investment reports. |
Specifying report restrictions
Use report restrictions to limit the entities and time periods included in the report. To specify report restrictions, complete these fields:
| Field | Description |
|---|---|
Entities | Choose the entity to include in the report. Note: Selecting a parent generates the report for all the leaf symbols under it. |
Contra entities | Choose the contra entity to restrict the report to. The default is no restriction. Leave this selection blank to report on all contra entities. Selecting a contra entity is based on your access in the entities dimension. Note: Selecting a parent restricts to all leaf symbols under it. Note: This option is not available in Investment reports. |
Elimination entities | Choose the elimination entity to restrict the report to. The report will only include transactions eliminated at the selected entity. Selecting a parent includes all transactions eliminated at any elimination entity under the selected parent. Note: If the elimination entity is restricted, data will only appear for elimination entities the user has access to. Select ‘All’ to report transactions without requiring access to elimination entities. |
Time Period | Choose the time period to include in the report. Note: Selecting a parent includes all leaf time periods under it. |
Specifying variance options
Use variance options to restrict the output of the report to include only transactions where there is a variance in the transactions reported between the entity and contra entity greater than the threshold specified.
Note: Variance options are only available in Standard MATCHING reports.
To specify variance options, complete these fields:
| Field | Description |
|---|---|
Group variance threshold | Use this to filter lines from the report where the variance at the group level is less than the threshold specified. Note: A line is filtered from the report if either the group or line variance threshold is not exceeded. |
Line variance threshold | Use this to filter lines from the report where the variance in the line is less than the threshold specified. Note: A line is filtered from the report if either the group or line variance threshold is not exceeded. |
Specifying numeric options
Use numeric options to format numeric output in the report. To specify numeric options complete these fields:
| Field | Description |
|---|---|
Use thousands separator | Check to display a locale-specific thousands separator based on the operating system setting. |
Decimals | Specify the number of decimals to include in numeric values. |
Specifying fixed dimension restrictions
All remaining dimensions must be specified as restrictions. For each dimension choose the symbol to include in the report.
Note: Selecting a parent includes all leaf symbols under it.