Skip to content

Specific Validation Rules Page – Accounts

Admin

Application database > Data processing tile > Diagnostic > Validation > (Specific rules) Accounts

Application Database > Navigation Panel > Data processing > Diagnostic > Validation > (Specific Rules) Accounts

Page purpose

This page allows you to manage the account specific validation rules for checks on the Sign, IC Sign, IC Capacity, Notes and FX Rate.

To override these rules on a per-process basis, see the Rules page in the Processes section.

Actions on this page

Element Description
Validation rules: opens a window to set and generate a preview, in Excel format, of all the elements impacted by the rule.

Attributes on the page

Element Description
Control type The criterion used to select the accounts to be checked. - Sign: check only on accounts that, in the elements list, have Standard sign check different from Any. - IC sign: check only on accounts that, in the elements list, have IC sign check different from Do not check. - IC Capacity: check only on accounts that, in the elements list, have IC capacity check different from Do not check. - FX rate: check only on accounts that, in the elements list, have FX rates check different from Do not check. - Notes: check only on accounts that, in the elements list, have Notes check different from Do not check.
Accounts Specifies the accounts for which the data is checked: - All elements (default) - an element of the account table - A node or an element of an accounts hierarchy
Category Specifies the categories for which the data is checked: - All elements (default) - An element in the categories table - A node or an element of the categories groupings
Granularity Sets the granularity with which the data are checked and is conditional on the Category attribute setting: - By node, only if Category contains a node of category groupings. - By category (default), only if Category contains an amount category or an entity journal category or All elements or a node of category groupings. In the two latter cases, the consolidation journals are discarded from the result categories. - By journal, only if Category contains an entity journal category or a consolidation journal category or All elements or a node of category groupings. In the two latter cases, By category granularity is applied to amount-type result categories.
Severity This allows you to define the severity level to be applied to the rule, and consequently what happens if the data processing detects an error. - Non-blocking (default). - Blocking: Entity's data is not submitted - Only Diagnostic: the check is only run if explicitly requested by manually running the diagnostic from the Detail summary (for the contributor) or Overview (for the consolidator) cockpit tabs; in this case it is possible to customise the filters before running the data processing. However, whenever diagnostics are run automatically (from the cockpit/from other data processing), the check is not performed. - Do not run : data is not verified. A useful option for excluding elements from a node to be deployed.
IC capacity thresholds
Currencies for thresholds Currency in which the threshold amounts set in this section are considered to be expressed; for the comparison, these must be converted into the currency of the entities/journals to which it is applied. The FX rate used for the conversion is the final FX rate. If the currency is not set, the currency of the relative entity or journal will be used.
Submission threshold Applied only to IC Capacity check. If set, below the threshold value, the entity is submitted even if there are errors with Blocking severity. In the submission step, these errors are classified as Below threshold blocking.
Original scenarios balancing threshold Applied only to IC capacity check and to accounts for which, in the elements list, IC capacity check is set to ‘Check =’. If this option is enabled, during the balancing data processing for the original scenarios, rows with an unbalanced amount below this value will be balanced. . Accounts with the following levels of granularity are not balanced: - "by node" containing only journal categories - "by category" on journal categories.
Dimensions check
Entity - Element: displays the result by Entity (default). - Contributor node: displays the results for the relevant nodes in the data collection process by summing the amounts associated with the entities belonging to those nodes.
Check by Custom dimension It can be set for any custom dimension enabled in the environment. - Total (default): It displays the result grouped by the custom dimension. - Lowest level elements: displays the result for each element of the custom dimension. - Hierarchy nodes: displays the results grouped by the top-level nodes of the hierarchy specified in the ‘Custom Dimension Hierarchy’ field.
Custom dimension hierarchy. The custom dimensions on which this setting is allowed are those enabled in the environment configuration. If Check by Custom dimension is set to Hierarchy nodes, then it is mandatory to specify an element of the custom dimensions hierarchy list.

IMPORTANT: if thresholds are not set, the threshold on the row preceding the definition for the same data collection will be considered. If no other rows exist, the threshold will be set to zero.