Aggregation Options for Intercompany Entities

Aggregation options determine how child member values aggregate to parent members. During application creation, if you enable Intercompany Data, three Aggregation options are available for aggregating Intercompany entities to the Intercompany Top member:

  • + Addition (default value)

  • - Subtraction

  • ~ Ignore

To enable features during application creation, see Application Feature Descriptions.

Note:

If you do not enable Intercompany Data, these options are not available.

The Consolidation Operator for FCCS_Intercompany Entities in the Intercompany Dimension is based on the aggregation option that you select, and the Standard Elimination system rules run as required by the aggregation option.

Aggregate Intercompany Entities to Intercompany Top (Addition)

If you select to aggregate intercompany entities to the Intercompany Top member, you select the Addition option.

  • The Consol Operator for the "FCCS_Intercompany Entities" member becomes Addition.

  • The Standard Eliminations system rules execute using the default Standard Eliminations process:

    If the plug account is flagged as "Is I/C Acct", then there are two entries. Both the entry posted to the plug account and the reversal of the source amount use the source Intercompany member.

    When an Intercompany entry is eliminated, the source POV amount is reversed and an offsetting entry is made to the plug account.

    • If the plug account is flagged as "Is I/C Acct", then there are two entries. Both the entry posted to the plug account and the reversal of the source amount use the source intercompany member.

    • If the plug account is NOT flagged as "Is I/C Acct", then there are also two entries. The entry posted to the plug account uses the "FCCS_No Intercompany" member while the reversal of the source amount uses the source intercompany member.

Do not aggregate Intercompany Entities to Intercompany Top (Ignore)

If you do not want to aggregate Intercompany entities to the Intercompany Top member, you select the Ignore option.

  • The Consol Operator for the "FCCS_Intercompany Entities" member becomes Ignore.

  • Standard Eliminations execute using the default Standard Eliminations process, but post either three or four entries instead of the existing two entries, depending on whether the plug account is flagged as "Is I/C Acct" or not:

    If the plug account is flagged as "Is I/C Acct", then there will be four entries during elimination. The first two reverse the source entry using the source intercompany member and post to the plug account using the source intercompany member, then two more entries reverse the same amount at "No Intercompany" and post to the plug account at "No Intercompany".

    If the plug account is NOT flagged as "Is I/C Acct", then there would only be three entries. The first entry reverses the source entry using the source intercompany member, then two more entities reverse the same amount at "No Intercompany" and post to the plug account at "No Intercompany".

Examples:


Intercompany Aggregation - Ignore option

Intercompany aggregation option ignore example 2

Aggregate Intercompany Entities to Intercompany Top as Subtract

If you want to aggregate Intercompany entities to the Intercompany Top member using the Subtract option:

  • The Consol Operator for the "FCCS_Intercompany Entities" member becomes Subtract.

  • Standard Eliminations execute under the same conditions as they do currently, but post either three or four entries instead of the existing two entries, depending on whether the plug account is flagged as "Is I/C Acct" or not:

    If the plug account is flagged as "Is I/C Acct", then there will be four entries during elimination. The first two reverse the source entry using the source intercompany member and post to the plug account using the source intercompany member, then two more entries reverse the same amount at "No Intercompany" and post to the plug account at "No Intercompany".

    If the plug account is NOT flagged as "Is I/C Acct", then there would only be three entries. The first entry reverses the source entry using the source intercompany member, then two more entities reverse the same amount at "No Intercompany" and post to the plug account at "No Intercompany".

Examples:


Intercompany aggregation option - Subtract

Intercompany aggregation option - Subtract example 2