import json,csv,re from decimal import Decimal as D from pathlib import Path p=Path('output/invoices.json') data=json.loads(p.read_text()) po=list(csv.DictReader(Path('inputs/purchase-orders.csv').read_text().splitlines())) assert len(data)==2 required='supplier invoice_number invoice_date po currency line_items subtotal tax shipping total bank_account_suffix exceptions'.split() for inv in data: assert all(k in inv for k in required) assert isinstance(inv['invoice_number'],str) and len(inv['invoice_number'])==6 assert isinstance(inv['bank_account_suffix'],str) and len(inv['bank_account_suffix'])==4 subtotal=D('0') for line in inv['line_items']: row=next(r for r in po if r['po']==inv['po'] and r['item']==line['description']) assert row['supplier']==inv['supplier'] assert int(row['qty'])==line['po_quantity'] assert D(row['unit_cad'])==D(line['po_unit_price']) assert line['quantity']-int(row['qty'])==line['quantity_variance'] assert D(line['unit_price'])-D(row['unit_cad'])==D(line['unit_price_variance']) amount=D(line['quantity'])*D(line['unit_price']) assert amount==D(line['amount'])==D(line['recalculated_amount']) subtotal+=amount assert row['bank_suffix']==inv['reconciliation']['po_bank_account_suffix'] rec=inv['reconciliation'] assert subtotal==D(inv['subtotal'])==D(rec['recalculated_subtotal']) tax=(subtotal*D(rec['tax_rate'])).quantize(D('.01')) assert tax==D(inv['tax'])==D(rec['recalculated_tax']) total=subtotal+tax+D(inv['shipping']) assert total==D(rec['recalculated_total']) assert D(inv['total'])-total==D(rec['printed_total_minus_recalculated_total']) assert (inv['bank_account_suffix']==rec['po_bank_account_suffix'])==rec['bank_suffix_matches_po'] assert data[0]['invoice_number']=='000742' and data[0]['bank_account_suffix']=='0412' assert data[1]['invoice_number']=='001083' rec=data[1]['reconciliation'] po_sub=sum(D(l['po_quantity'])*D(l['po_unit_price']) for l in data[1]['line_items']) assert po_sub==D(rec['po_merchandise_subtotal']) assert po_sub*D('.12')==D(rec['po_quantity_tax_at_invoice_rate']) assert po_sub*D('1.12')==D(rec['po_quantity_total_at_invoice_rate_and_invoiced_zero_shipping']) assert D(data[1]['total'])-po_sub*D('1.12')==D(rec['printed_total_minus_po_quantity_total']) words=len(Path('output/review-note.md').read_text().split()) assert words<400,words print(f'PASS: JSON parsed; two records; required fields; identifiers; all line/PO comparisons; tax and total calculations; banking comparisons; review note {words} whitespace-delimited words (<400).')