Usecase Examples: Suppressing Blank Columns and Matches

The following examples illustrate the two options of suppressing blank columns and suppressing matched transactions in Intercompany Report. See also: Selecting Suppression Options (Blank Columns and Matches)

Without Suppressed Options Selected

This report represents the default state where neither Suppress Blank Columns nor Suppress Matches options are selected. In this configuration, the report displays all transactions, including both matched and unmatched transactions, and shows all columns regardless of whether they contain data.

Example:

• Suppress Matches: false
• Tolerance Value: 0.0
• Tolerance Percent: 0.0
• Example Output:
  • The report includes all rows, even if the transactions are fully matched
  • Columns with no data are still displayed, potentially making the report cluttered (A2 asset Entity, A2 asset Partner)

Suppress columns that are entirely blank (that is, have no data across all rows)

This report demonstrates the functionality when the Suppress Blank Columns option is selected. This feature hides any columns that contain no data across all rows, simplifying the report and making it easier to focus on relevant data.

Example:

• Suppress Blank Columns: Enabled
• Example Output:
  • Columns without any data are omitted from the report
  • Note columns that were having no data are removed A2 asset Entity, A2 asset Partner

Suppress rows with matched transactions within a specified tolerance

You can use this option to suppress matches with:

• Suppress Tolerance Value:

  This report illustrates the use of the Suppress Matches option with a specified Tolerance Value. Cells where the variance between intercompany transactions is less than or equal to the specified tolerance value are suppressed.

  Example:

  • Suppress Matches: Enabled
  • Tolerance Value: 500.0
  • Tolerance Percent: 0.0
  • Example Output: Transactions with variances of 500 or less are suppressed.

  

• Suppress Tolerance Percent:

  This report shows the effect of applying the Suppress Matches option along with a specified Tolerance Percent. Here, cells where the variance between intercompany transactions falls within the tolerance percentage value are suppressed, reducing the visibility of minor variances.

  Example:

  • Suppress Matches: Enabled
  • Tolerance Value: 0.0
  • Tolerance Percent: 5.0
  • Example Output:
    • Calculates the Tolerance Percent Value by applying the specified percentage to the transaction amounts
    • Tolerance threshold = 5% of the lower of the two amounts (entity or partner transaction), if absolute variance is less than or equals to tolerance threshold, that transaction will be suppressed
    • Example: first transaction is suppressed transaction between LA => ICP_NY, where 5% of Min (80000,79500) >= 500 (variance value)
    • If the absolute variance is less than or equal to the threshold value calculated, the transaction is suppressed.

Note:

• You can choose to apply either or both tolerance criteria when generating reports.
• When you apply both the Tolerance Value and Tolerance Percent, the system effectively chooses the stricter criterion (that is, the lower of the two thresholds) to determine whether to suppress a row. This ensures that only variances that fall within the most restrictive tolerance setting are hidden from the report, providing a more precise control over what data is displayed.
• Variance value can be negative/positive, for suppression comparison we always take absolute value of variance.