Selecting Suppression Options (Blank Columns and Matches)
In Intercompany reports, you can suppress the display of data cells associated with a specific variance, as well as the variance itself, if a set of conditions are met. Suppressing the data in a data cell means that the system shows no value (a blank value) in that cell. If both variances are suppressed in the row, the system does not display the entire row.
Suppress Blank Columns
This option allows you to suppress columns that contain no data across all rows, reducing report clutter and improving readability.
Suppress Matches
You can suppress data by specifying a tolerance value (amount) or percentage. For example, if an Entity has an amount of 299 and the Partner Entity has 200, the difference is 99. If the matching tolerance is 100 and the difference between the Entity and Partner is less than 100 as in this example, the system suppresses the transactions because it is within the matching tolerance.
If you select not to suppress the Entity/Partner transactions, the system does not suppress them even if the Entity and Partner amounts are within the matching tolerance amount or percentage. Using the previous example, even if the difference amount is 99 and if it is within the matching tolerance, the system does not suppress the transactions. The matching tolerance is displayed in units.
You can suppress matches using one or both of these tolerance criteria when generating reports:
- Tolerance Value - A numeric value to define the acceptable
variance. Cells with variances within this tolerance will be suppressed.
For example, you can enter a Tolerance value. The value must be a positive number. If the absolute value of a specified variance is less than or equal to the Tolerance value, the system suppresses the variance, accounts, and matching account data cells for the specified variance in that row. By default, the Tolerance value is 0.
- Tolerance Percent - A percentage to define the acceptable
variance relative to the total value. Cells with variances within this percentage
will be suppressed.
For example, you can enter a Tolerance percent. The value must be a positive number less than or equal to 100. Determine the absolute value of the portion of the variance that was accounted by the Accounts. Determine the absolute value of the portion of the variance that was accounted by the Matching Accounts. Take the minimum of these two values (if there are no Matching Accounts, then just use the portion from Accounts only), and apply the Tolerance Percent. This is the Tolerance Percent Value. If the Tolerance Percent Value is greater than the absolute value of the variance, then the Variance, Accounts, and Matching Account data cells for the specified Variance in that row are suppressed.
Note:
A row that has no data for both transactions is automatically suppressed, regardless of whether any of the suppression options are enabled.
The Suppression options are displayed in the header section of the generated report.
See also: Usecase Examples: Suppressing Blank Columns and Matches