Joined rows / expected orders— / 3Not evaluated
Line value · USD—Source control 390.00
Payment value · USD—Source control 290.00
Outstanding · USD—Source control 100.00
Orders
One intended report identity per order.
| Order | Customer | Lines | Payments |
|---|
O803 has no payment. Preserve it in the report.
Order lines
Line amounts have their own stable keys.
| Line | Order | USD |
|---|
Payments
Payment count is independent of line count.
| Payment | Order | USD |
|---|
No source records are changed by this exercise.
Acceptance contract
Run the detail join and inspect the repeated amounts. Then total each child by order, evaluate again and retain the passing selection as Report owner. Check Acorn separately: its balance can look correct while both underlying totals are inflated.
Evaluate the candidate to inspect its rows.
Joined row worksheet
| Order | Line key / group | Payment key / group | Line USD | Paid USD |
|---|
Per-order result
| Order | Line | Paid | Due |
|---|
A current passing evaluation and Report owner are required. An empty selection has no new acceptance snapshot.
Retained report acceptance
The saved selection stays identifiable while another candidate is prepared.
No acceptance snapshot retained.
| Order | Line USD | Paid USD | Due USD |
|---|
0 retained snapshots in this exercise.