Skip to content
System Note 01 · Enterprise Systems

Order Value Correction

Bell Canada

SQLData QualityReconciliationChange Control
Live
What it is

A fix to a production pipeline that was misreporting order value in both directions: it restored $4.1M that was under-counted, including $2.7M across 8,355 missing orders, and removed $22.7M that was double-counted.

$40M+/year pipeline · 8,355 orders restored · reversible cutover · zero duplicate-key groups

Why I built it

The pipeline under-counted some orders and double-counted others at the same time, so its totals were wrong in both directions.

Outcome
$26.8Morder value corrected
8,355missing orders restored
← Back to Build Notes