FAILURE MAP
← Case archive

FA-59836 / Subscription proration billing / Open access

Unused-time credit based on amount paid: refunded invoice exclusion · case 01

Customers whose payment was already refunded receive an unused-time credit on top of the refund.

Verified by executionVariant 1 · 8 checks per implementationDownload source bundle ↓JSON ↗

ROOT CAUSE

Refunded invoices are not excluded from unused-time credits.

VERIFIED REPAIR

Restore the contract rule at the refunded invoice exclusion step: use `if x['status'] in ('open', 'void', 'refunded'):`.

Unsuccessful approach: The attempt excludes only invoices with zero recorded payment, but refunded invoices keep their original paid amount.

Case contract

Input {list, paid, status paid|partial|open|void|refunded, left, period}. Open, void and refunded invoices earn no unused-time credit. Paid and partially paid invoices earn paid*left/period half-up (the amount actually collected, not the list price). Return cents.

Why this case matters

Credits for unused time must not exceed what the customer actually paid for the period.

1 / The failure

Exit 1
"""Failure Map reference implementation. Python standard library only."""
import json

N = 1
observations = []
def solve(x):
    if x['status'] in ('open', 'void'):
        return 0
    return (x['paid'] * x['left'] * 2 + x['period']) // (2 * x['period'])
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
fixtures = [[('regression', {'list': 1000, 'paid': 461, 'status': 'refunded', 'left': 10, 'period': 31}, 0), ('regression', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 20, 'period': 31}, 0), ('partial-repair probe', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 4950, 'status': 'void', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'void', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 0, 'status': 'open', 'left': 4, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'open', 'left': 29, 'period': 31}, 0)], [('regression', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 20, 'period': 31}, 0), ('regression', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'partial', 'left': 24, 'period': 31}, 1897), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'paid', 'left': 19, 'period': 31}, 3003), ('normal control', {'list': 1000, 'paid': 500, 'status': 'open', 'left': 15, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'paid', 'left': 6, 'period': 31}, 474)], [('regression', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('regression', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 25, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'refunded', 'left': 1, 'period': 31}, 0), ('normal control', {'list': 1000, 'paid': 0, 'status': 'partial', 'left': 13, 'period': 31}, 0), ('normal control', {'list': 1000, 'paid': 500, 'status': 'open', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'open', 'left': 20, 'period': 31}, 0)], [('regression', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 10, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 26, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'void', 'left': 3, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'open', 'left': 25, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 935, 'status': 'partial', 'left': 23, 'period': 31}, 694), ('normal control', {'list': 4900, 'paid': 0, 'status': 'void', 'left': 29, 'period': 31}, 0)], [('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 25, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 22, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 14, 'status': 'refunded', 'left': 31, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 2540, 'status': 'open', 'left': 27, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'refunded', 'left': 6, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 4950, 'status': 'paid', 'left': 25, 'period': 31}, 3992), ('normal control', {'list': 4900, 'paid': 3688, 'status': 'partial', 'left': 5, 'period': 31}, 595)]]
for i, (label, args, expected) in enumerate(fixtures[N-1]):
    check("%s %d" % (label, i), solve(args), expected)
print(json.dumps({"observations": observations, "passed": all(x["passed"] for x in observations)}, ensure_ascii=False))
raise SystemExit(0 if all(x["passed"] for x in observations) else 1)
Boundary fixtureActualExpectedOutcome
regression 01490Failed
regression 115810Failed
partial-repair probe 236690Failed
partial-repair probe 32950Failed
normal control 400Passed
normal control 500Passed
normal control 600Passed
normal control 700Passed

SHA-256 / 7de310d026b3466fa367c0b08e1a4f7f8c9ee334226687f9bdde216d0e6a647c

2 / The unsuccessful fix

Exit 1
"""Failure Map reference implementation. Python standard library only."""
import json

N = 1
observations = []
def solve(x):
    if x['status'] in ('open', 'void') or x['paid'] == 0:
        return 0
    return (x['paid'] * x['left'] * 2 + x['period']) // (2 * x['period'])
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
fixtures = [[('regression', {'list': 1000, 'paid': 461, 'status': 'refunded', 'left': 10, 'period': 31}, 0), ('regression', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 20, 'period': 31}, 0), ('partial-repair probe', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 4950, 'status': 'void', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'void', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 0, 'status': 'open', 'left': 4, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'open', 'left': 29, 'period': 31}, 0)], [('regression', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 20, 'period': 31}, 0), ('regression', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'partial', 'left': 24, 'period': 31}, 1897), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'paid', 'left': 19, 'period': 31}, 3003), ('normal control', {'list': 1000, 'paid': 500, 'status': 'open', 'left': 15, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'paid', 'left': 6, 'period': 31}, 474)], [('regression', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('regression', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 25, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'refunded', 'left': 1, 'period': 31}, 0), ('normal control', {'list': 1000, 'paid': 0, 'status': 'partial', 'left': 13, 'period': 31}, 0), ('normal control', {'list': 1000, 'paid': 500, 'status': 'open', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'open', 'left': 20, 'period': 31}, 0)], [('regression', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 10, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 26, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'void', 'left': 3, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'open', 'left': 25, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 935, 'status': 'partial', 'left': 23, 'period': 31}, 694), ('normal control', {'list': 4900, 'paid': 0, 'status': 'void', 'left': 29, 'period': 31}, 0)], [('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 25, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 22, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 14, 'status': 'refunded', 'left': 31, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 2540, 'status': 'open', 'left': 27, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'refunded', 'left': 6, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 4950, 'status': 'paid', 'left': 25, 'period': 31}, 3992), ('normal control', {'list': 4900, 'paid': 3688, 'status': 'partial', 'left': 5, 'period': 31}, 595)]]
for i, (label, args, expected) in enumerate(fixtures[N-1]):
    check("%s %d" % (label, i), solve(args), expected)
print(json.dumps({"observations": observations, "passed": all(x["passed"] for x in observations)}, ensure_ascii=False))
raise SystemExit(0 if all(x["passed"] for x in observations) else 1)
Boundary fixtureActualExpectedOutcome
regression 01490Failed
regression 115810Failed
partial-repair probe 236690Failed
partial-repair probe 32950Failed
normal control 400Passed
normal control 500Passed
normal control 600Passed
normal control 700Passed

SHA-256 / f656857f8a73c8cc8e1b180ab9b22fb3afc8553e8f3a0fe5bab1e008ae55c7bd

3 / The verified repair

Exit 0
"""Failure Map reference implementation. Python standard library only."""
import json

N = 1
observations = []
def solve(x):
    if x['status'] in ('open', 'void', 'refunded'):
        return 0
    return (x['paid'] * x['left'] * 2 + x['period']) // (2 * x['period'])
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
fixtures = [[('regression', {'list': 1000, 'paid': 461, 'status': 'refunded', 'left': 10, 'period': 31}, 0), ('regression', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 20, 'period': 31}, 0), ('partial-repair probe', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 4950, 'status': 'void', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'void', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 0, 'status': 'open', 'left': 4, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'open', 'left': 29, 'period': 31}, 0)], [('regression', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 20, 'period': 31}, 0), ('regression', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'partial', 'left': 24, 'period': 31}, 1897), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'paid', 'left': 19, 'period': 31}, 3003), ('normal control', {'list': 1000, 'paid': 500, 'status': 'open', 'left': 15, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'paid', 'left': 6, 'period': 31}, 474)], [('regression', {'list': 9900, 'paid': 4739, 'status': 'refunded', 'left': 24, 'period': 31}, 0), ('regression', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 25, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'refunded', 'left': 1, 'period': 31}, 0), ('normal control', {'list': 1000, 'paid': 0, 'status': 'partial', 'left': 13, 'period': 31}, 0), ('normal control', {'list': 1000, 'paid': 500, 'status': 'open', 'left': 9, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 2450, 'status': 'open', 'left': 20, 'period': 31}, 0)], [('regression', {'list': 4900, 'paid': 1142, 'status': 'refunded', 'left': 8, 'period': 31}, 0), ('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('partial-repair probe', {'list': 4900, 'paid': 2450, 'status': 'refunded', 'left': 10, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 26, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'void', 'left': 3, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 4900, 'status': 'open', 'left': 25, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 935, 'status': 'partial', 'left': 23, 'period': 31}, 694), ('normal control', {'list': 4900, 'paid': 0, 'status': 'void', 'left': 29, 'period': 31}, 0)], [('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 7, 'period': 31}, 0), ('regression', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 25, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 1000, 'status': 'refunded', 'left': 22, 'period': 31}, 0), ('partial-repair probe', {'list': 1000, 'paid': 14, 'status': 'refunded', 'left': 31, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 2540, 'status': 'open', 'left': 27, 'period': 31}, 0), ('normal control', {'list': 4900, 'paid': 0, 'status': 'refunded', 'left': 6, 'period': 31}, 0), ('normal control', {'list': 9900, 'paid': 4950, 'status': 'paid', 'left': 25, 'period': 31}, 3992), ('normal control', {'list': 4900, 'paid': 3688, 'status': 'partial', 'left': 5, 'period': 31}, 595)]]
for i, (label, args, expected) in enumerate(fixtures[N-1]):
    check("%s %d" % (label, i), solve(args), expected)
print(json.dumps({"observations": observations, "passed": all(x["passed"] for x in observations)}, ensure_ascii=False))
raise SystemExit(0 if all(x["passed"] for x in observations) else 1)
Boundary fixtureActualExpectedOutcome
regression 000Passed
regression 100Passed
partial-repair probe 200Passed
partial-repair probe 300Passed
normal control 400Passed
normal control 500Passed
normal control 600Passed
normal control 700Passed

SHA-256 / c101e45805668082f9f34ac924327912d8031069965e79ff6a760cad79fa19f1

Verification & scope

A deterministic teaching model of a stipulated billing rule. It makes no claim to reproduce any billing provider's exact behaviour and is not billing software. This reproducer isolates one failure mechanism. Results cover the supplied fixtures. Variants within a family share a test contract and should remain grouped when constructing evaluation splits. Related mechanisms with a shared evaluation_group must also remain together; these controlled models are not independent production incidents.

Observations recorded using Python 3.12.14 at 2026-09-29T14:46:40.093210+00:00.

Case digest / 2b63d1881fa42ad86ccb1d5966207e1511740120fe97999a57a752b0fdb2b988