Reconciliation Line List
Lists the lines of a reconciliation as a lookup.
Object Definition
| Object Type | Page |
| Object ID | 71389608 |
| Object Name | QWERE Reconciliation Line List |
| Source Table | QWERE Reconciliation Line |
Controls
| Type | Caption | ToolTip |
|---|---|---|
| Field | Reconciliation No. | Specifies the number of the reconciliation to which the line belongs. |
| Field | Line No. | Specifies the number of the reconciliation line. |
| Field | Description | Specifies the description. |
| 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 | 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 | 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 | 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 | 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. |
| Field | Last Checked | Specifies the date and time when the line was last checked. |
| Action | Open Page | Show the entries. |
| Action | Open in New Tab(s) | Open the source for "Value" and "Value (Compared)" in new tabs. |
| Action | View Group | Show the group of the selected line. |
| Action | Recalculate Selected | Recalculate the selected lines to refresh the values and statuses. This is useful after posting entries that affect the reconciliation. |
| Action | Handle Selected | Mark the selected lines as handled. |
| Action | Set Selected as Unhandled | Mark the selected lines as unhandled. |
| 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 | View Unhandled | Show unhandled lines. |
| Action | View Handled | Show all handled lines. |
| Action | View All | Show all lines. |
| Action | Specification | View the specification or overview. If there is (only) one related specification, it will be shown, otherwise, the overview will be displayed. |
| Action | Files | Show the files related to this line. |
| Sub page | Information | Reconciliation Line |
| Sub page | Tolerance | Reconciliation Tolerance |
| Sub page | Settings | Reconciliation Settings |
| Sub page | Workflow Information | Reconciliation Workflow |
This documentation is generated from Reconciliations for Eagle v28.1