C1 (3 points)
https://knobit.org/id/task/dwbi-conformed-loads/C1
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dwbi-conformed-loads/C1 |
| rdfs:label | C1 (3 points) en |
| schema:hasPart | dwbi-conformed-loads C1: a load reporting no rejects that loses 60 rows and EUR 240 000 |
| schema:hasPart | dwbi-conformed-loads C1: the EUR clearing break explained by the unbalanced load |
| schema:hasPart | dwbi-conformed-loads C1: the USD clearing account reconciled in transaction currency, not across two conversion rates |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | Load control and GL reconciliation, 1 each. (a) LC-010 does not balance: rows in 51 240 minus out 51 180 minus rejected 0 leaves 60 rows, and €96 540 000 in minus €96 300 000 out minus €0 rejected leaves €240 000, in neither the output nor the rejects (checks.py recomputes); the load is marked not balanced and the missing rows are traced and reloaded or held as rejects - not accepted because nothing was rejected. (b) GR-010 account 1910 (EUR): warehouse €96 300 000 vs GL €96 540 000, difference −€240 000 (−0.25%), fail, explained by LC-010's 60 unaccounted rows rather than left as an unexplained break. (c) GR-010 account 1915 (USD) reconciled in its transaction currency: both sides USD 2 150 000 (€1 981 567 × 1.0850 and €1 990 741 × 1.0800), difference 0, pass; the −€9 174 is a conversion-rate difference (reference rate vs booking rate), not a data break, and is withdrawn from the escalation. en |