Enhanced Intercompany Report

The Intercompany Report is now enhanced to include two new options of suppressing blank columns and suppressing matched transactions. With this new capability, you can:

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

  • Suppress rows with matched transactions within a specified tolerance

You can use this option to suppress matches with:

  • Tolerance Value: This report illustrates the use of the Suppress Matches option with a specified Tolerance Value. Transactions where the variance between intercompany transactions is less than or equal to the specified tolerance value are suppressed.
  • Tolerance Percent: This report shows the effect of applying the Suppress Matches option along with a specified Tolerance Percent. Here, transactions where the variance between intercompany transactions falls within the tolerance percentage value are suppressed, reducing the visibility of minor variances.

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.
  • The variance amount can be a positive or negative value. The system uses the absolute value of the variance amount to determine whether it meets the suppression criteria.

Business Benefit: The Intercompany Report currently includes all transactions, regardless of whether they are matched or unmatched, and displays all columns, even if they contain no data. The new options allow you to suppress empty columns and only view significant differences, reducing time spent.

Key Resources