import json, csv, os, shutil from decimal import Decimal as D os.makedirs("output/original-submission", exist_ok=True) for f in ["invoices.json", "review-note.md", "check.py"]: dst = "output/original-submission/" + f if not os.path.exists(dst): shutil.copy("output/" + f, dst) inv = json.load(open("output/invoices.json")) req = ["supplier","invoice_number","invoice_date","po","currency","line_items","subtotal", "tax","shipping","total","bank_account_suffix","exceptions"] po = list(csv.DictReader(open("inputs/purchase-orders.csv"))) print("records", len(inv)) for r in inv: print(r["invoice_number"], "missing keys:", [k for k in req if k not in r], "inv# is str:", isinstance(r["invoice_number"], str), "bank 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"]))) s = sum(D(str(l["amount"])) for l in r["line_items"]) print(" subtotal ok:", s == D(str(r["subtotal"])), "tax ok:", (s*D("0.12")).quantize(D("0.01")) == D(str(r["tax"])), "total ok:", s + D(str(r["tax"])) + D(str(r["shipping"])) == D(str(r["total"]))) pos = [x for x in po if x["po"] == r["po"]] print(" PO supplier match:", all(x["supplier"] == r["supplier"] for x in pos), "PO bank:", {x["bank_suffix"] for x in pos}, "invoice bank:", r["bank_account_suffix"]) print("original preserved:", sorted(os.listdir("output/original-submission"))) print("note words:", len(open("output/review-note.md").read().split()))