| Field |
Workflow Id |
Specifies the ID of the workflow. |
| Field |
No. |
Specifies the number of the reconciliation setup record. |
| Field |
Reconciliation Code |
Specifies the reconciliation code that identifies and links reconciliations, allowing you to view the lines of related reconciliations. |
| Field |
Description |
Specifies the description of the reconciliation. |
| Field |
Comparison Type |
Specifies the type of comparison to be performed for the reconciliation. For example, it can be a comparison between two tables, one table and a filter, or a date filter only. |
| Field |
Comments are Mandatory |
Specifies if a comment is mandatory to mark the reconciliation line as Handled. |
| Field |
Difference % Calculation |
Specifies the method to calculate the difference percentage for the reconciliation. The difference can be divided by Value, Value (Compared), or Index, where Index divides Value by Value (Compared). |
| Field |
Exclude Values |
Specifies which values to exclude from the reconciliation lines. "Zero Values" excludes lines with 0 in Value, Value (Compared) and Value (Reference). "Zero Difference" excludes lines with 0 in Difference. |
| Field |
Tolerance Code |
Specifies the reconciliation tolerance code used to identify tolerance settings for determining if a reconciliation line is within range and can be automatically marked as handled. |
| Field |
Table Setup Code |
Specifies the unique identifier for the table setup, which defines the table, drill-down page, and fields used to group the reconciliation lines for the Value field. |
| Field |
Opposite Sign |
Specifies whether to use the opposite sign for the Value field in the reconciliation. |
| Field |
Filter |
Specifies the filter applied to the value in the reconciliation. |
| Field |
Table Setup Code (Compared) |
Specifies the unique identifier for the table setup, which defines the table, drill-down page, and fields used to group the reconciliation lines for the Value (Compared) field. |
| Field |
Opposite Sign (Compared) |
Specifies whether to use the opposite sign for the Value (Compared) field in the reconciliation. |
| Field |
Filter (Compared) |
Specifies the filter applied to the compared value in the reconciliation. |
| Field |
Reference Settings From |
Specifies the reference settings, which can be based on either the value or the compared value. |
| Field |
Period Code |
Specifies the period for the value. |
| Field |
Period Code (Compared) |
Specifies the period for the compared value. |
| Field |
Number of Periods (Compared) |
Specifies the value used to divide the compared value. If left blank, the value will be calculated automatically. |
| Field |
Period Code (Reference) |
Specifies the period for the reference value. |
| Field |
Number of Periods (Reference) |
Specifies the value used to divide the reference value. If left blank, the value will be calculated automatically. |
| Action |
New Supporting |
Create a new supporting workflow reconciliation setup. |
| Action |
Verify Settings |
Verify the settings for the reconciliation setup. This action checks if the setup is valid and ready for use. |
| Action |
Lines |
Open the setup page for reconciliation lines, allowing you to configure detailed settings such as those for balance sheet reconciliations. |
| Action |
Groups |
Open the setup page for the groups of reconciliation lines. This page allows you to configure the settings for groups instead of individual lines. |
| Action |
Up |
Move the record one step up in the list. |
| Action |
Down |
Move the record one step down in the list. |