| Field |
Line No. |
Specifies the number of the reconciliation line. |
| Field |
Grouped by |
Specifies the group. The grouping is defined in the reconciliation table setup and can consist of one or several fields. Separated with a semicolon if there are multiple fields. |
| Field |
Grouped by (Description) |
Specifies the description related to the fields specified in the reconciliation table setup to group the reconciliation lines. Separated with a semicolon if there are multiple fields. |
| Field |
Category |
Specifies the category of the line. The category is defined in the reconciliation line setup. |
| Field |
Description (Custom) |
Specifies the description. |
| Field |
Count |
Specifies the value. The group, caption and the value are defined in the reconciliation table setup. |
| Field |
Count (Compared) |
Specifies the compared value. The group, caption and the compared value are defined in the reconciliation table setup. |
| Field |
Value |
Specifies the value. The group, caption and the value are defined in the reconciliation table setup. |
| Field |
Value (Compared) |
Specifies the compared value. The group, caption and the compared value are defined in the reconciliation table setup. |
| Field |
Value (Reference) |
Specifies the reference value. The group, caption and the reference value are defined in the reconciliation table setup. |
| Field |
Value (Reference 2) |
Specifies the reference value 2. The group, caption and the reference value are defined in the reconciliation table setup. |
| Field |
Value (Reference 3) |
Specifies the reference value 3. The group, caption and the reference value are defined in the reconciliation table setup. |
| Field |
Value (Reference 4) |
Specifies the reference value 4. The group, caption and the reference value are defined in the reconciliation table setup. |
| Field |
Difference |
Specifies the deviation between the value and the compared value. |
| Field |
% |
Specifies the deviation in percentage. The calculation of this field is specified in the reconciliation table setup. |
| Field |
Infinite Difference |
Specifies that the difference is infinite. This is the case when the value to divide by is zero. |
| Field |
Responsible Code |
Specifies who is responsible for the reconciliation line. |
| Field |
Comment on Previous |
Specifies whether the line has a comment in the previous reconciliation. |
| Field |
Comment |
Specifies a comment that explains why there are deviations on the line. Use the Work Note field for internal notes. |
| Field |
Handled |
Specifies that the line has been handled. This indicates that the user has reviewed the line and confirmed the difference is acceptable, even if it is outside the configured tolerance. |
| Field |
Work Note |
Specifies an internal working note to be used during the reconciliation process until the line is marked as Handled. |
| Field |
Specification |
Specifies whether the line has a specification. |
| Field |
Specified Value |
Specifies the amount that has been specified. |
| Field |
Remaining to Specify |
Specifies the remaining amount to be specified. |
| Field |
Files |
Specifies the number of files related to the line. |
| Field |
Manual Specification Total |
Specifies the total amount of the related manual specification lines. |
| Field |
Reconciliation Lines Total |
Specifies the total amount of the related reconciliation lines. |
| Field |
Report Value |
Specifies the value retrieved from the report. The setup, accessible via the Report Setup action on the line setup, defines the column to summarize or the field to extract. |
| Field |
Table Entries Total |
Specifies the total amount of the related table entries. |
| Field |
Handled by |
Specifies the user who handled the line. |
| Field |
Handled at |
Specifies the date and time the line was handled. |
| Field |
Handled Reason |
Specifies the reason why the line was marked as handled. |
| Action |
Open Page |
Open the related record for the selected line. |
| Action |
Open in New Tabs |
Open the source of the value and compared value for the selected lines in separate tabs to facilitate analysis. |
| Action |
Open in New Tab |
Open the source of the value for the selected line in a new tab to facilitate analysis. |
| Action |
View Group |
View the lines and details for the group of the selected line. |
| Action |
Specification |
Show the specification or overview. If there is (only) one related specification, it will be shown, otherwise, the overview will be displayed. |
| Action |
Specification Overview |
View an overview of the specifications for the selected line. |
| Action |
Manual Specification |
View the manual specification for the selected line. |
| Action |
Table Entries |
View the table entries for the selected line. |
| Action |
Reconciliation |
View the reconciliation details applied as a specification for the selected line. |
| Action |
Recalculate Selected |
Recalculate the selected lines to update values and statuses. This is useful after posting entries affecting the reconciliation. |
| Action |
Recalculate All |
Recalculate all lines to update values and statuses. This is useful after posting entries affecting the reconciliation. |
| Action |
Handle Selected |
Mark the selected lines as handled. This is useful for tracking the status of the reconciliation. |
| Action |
Set Selected as Unhandled |
Mark the selected lines as unhandled. This can be helpful if the lines were marked as handled in error. |
| Action |
Group |
Group the selected lines in the reconciliation. |
| Action |
Ungroup |
Ungroup the selected group, separating its lines into individual reconciliation lines. |
| Action |
Ungroup Selected |
Separate the selected lines in the reconciliation. |
| Action |
View Unhandled |
View unhandled lines in the reconciliation. |
| Action |
View Handled |
View handled lines in the reconciliation. |
| Action |
View All |
View all lines in the reconciliation. |
| Action |
View With Specification |
View lines with a specification in the reconciliation. |
| Action |
View Without Specification |
View lines without a specification in the reconciliation. |
| Action |
View All |
View all lines in the reconciliation. |
| Action |
Summarize Selected |
Display a summary of the selected lines in the reconciliation, providing an overview of their values and differences. |
| Action |
Summarize All |
Display a summary of all lines in the reconciliation, providing an overview of their values and differences. |
| Action |
Related Lines |
View related lines in other reconciliations. Related lines share the same group and reconciliation code. It is possible to change the reconciliation code in a reconciliation. |
| Action |
Recreate Specification Report |
Recreate the specification report for the selected lines and overwrite the existing report. This is useful if the report data has changed. |
| Action |
Recreate Table Entries |
Recreate the table entries for the selected lines and overwrite the existing entries. This is useful if the table entries have changed. |
| Action |
Files |
View the files for the selected line. |