Reconciliation Lines
Lists the lines of a reconciliation.
Object Definition
| Object Type | Page |
| Object ID | 71389609 |
| Object Name | QWERE Reconciliation Lines |
| Source Table | QWERE Reconciliation Line |
Controls
| Type | Caption | ToolTip |
|---|---|---|
| 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. |
This documentation is generated from Reconciliations for Eagle v28.1