import json, csv from decimal import Decimal as D inv = json.load(open("output/invoices.json")) po = list(csv.DictReader(open("inputs/purchase-orders.csv"))) REQ = ["supplier","invoice_number","invoice_date","po","currency","line_items","subtotal", "tax","shipping","total","bank_account_suffix","exceptions"] print("records", len(inv)) for r in inv: missing = [k for k in REQ if k not in r] print(r["invoice_number"], "missing fields", missing, "invoice_number is str", isinstance(r["invoice_number"], str), "bank suffix is str", isinstance(r["bank_account_suffix"], str)) for l in r["line_items"]: print(" line amount ok", D(str(l["qty"])) * D(str(l["unit_price"])) == D(str(l["amount"]))) sub = sum(D(str(l["qty"])) * D(str(l["unit_price"])) for l in r["line_items"]) tax = (sub * D("0.12")).quantize(D("0.01")) tot = sub + tax + D(str(r["shipping"])) print(" calc sub", sub, "(stated", r["subtotal"], ") tax", tax, "(stated", r["tax"], ") total", tot, "stated", r["total"], "total match", tot == D(str(r["total"]))) for l in r["line_items"]: p = [x for x in po if x["po"] == r["po"] and x["item"] == l["description"]][0] print(" ", l["description"], "qty", l["qty"], "po", p["qty"], "unit", l["unit_price"], "po", p["unit_cad"], "bank inv", r["bank_account_suffix"], "po", p["bank_suffix"], "supplier match", p["supplier"] == r["supplier"]) psub = sum(D(x["qty"]) * D(x["unit_cad"]) for x in po if x["po"] == r["po"]) ptax = (psub * D("0.12")).quantize(D("0.01")) print(" PO expected", psub, ptax, psub + ptax + D(str(r["shipping"]))) n = len(open("output/review-note.md").read().split()) print("note words", n)