{% extends "core/base.html" %}{% load fmt %}
{% block title %}Accounts payable{% endblock %}
{% block content %}
<div class="head"><h1>Accounts payable</h1>
<div class="actions">{% include "core/_scenario_picker.html" %}
{% if optimize %}<a class="btn ghost" href="?{% if scenario %}scenario={{ scenario.id }}{% endif %}">Pay on due date</a>{% else %}<a class="btn" href="?optimize=1{% if scenario %}&scenario={{ scenario.id }}{% endif %}">Preview optimizer</a>{% endif %}</div></div>
<p class="sub">Open AP {{ kpi.ap_total|inr }} &middot; DPO {{ kpi.dpo|floatformat:1 }} days &middot; {% if optimize %}<strong>optimizer on</strong>: {{ total_delay }} bill-days deferred in total{% else %}bills paid on due date{% endif %}{% if saved %} &middot; early-payment discounts capture {{ saved|inr }}{% endif %}</p>
<section class="card"><h2>Aging (days past due)</h2>{% include "core/_aging.html" %}</section>
<div class="cols">
<section class="card"><h2>Early-payment discounts</h2>
<p class="hint">A discount is taken when its annualised return beats the hurdle rate ({{ hurdle|floatformat:0 }}%).</p>
<table class="t"><thead><tr><th>Vendor</th><th>Terms</th><th class="r">Annualised</th><th>Decision</th></tr></thead><tbody>
{% for d in discounts %}<tr><td>{{ d.v.name }}</td><td>{{ d.v.discount_pct|floatformat:0 }}/{{ d.v.discount_days }} net {{ d.v.terms_days }}</td><td class="r">{{ d.ret|floatformat:1 }}%</td><td>{% if d.take %}<span class="pill ok">take</span>{% else %}<span class="pill">skip</span>{% endif %}</td></tr>{% empty %}<tr><td colspan="4">No vendor offers a discount.</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Overdue vendors</h2><table class="t"><thead><tr><th>Vendor</th><th class="r">Overdue</th><th class="r">Oldest</th></tr></thead><tbody>
{% for r in kpi.ap_top_overdue %}<tr><td>{{ r.party }}</td><td class="r">{{ r.overdue|inr }}</td><td class="r">{{ r.oldest_days }} d</td></tr>{% empty %}<tr><td colspan="3">Nothing overdue.</td></tr>{% endfor %}</tbody></table></section>
</div>
<section class="card"><h2>Payment schedule (13 weeks)</h2><div class="scroll"><table class="t"><thead><tr><th>Pay on</th><th>Vendor</th><th>Bill</th><th>Priority</th><th class="r">Amount</th><th>Note</th></tr></thead><tbody>
{% for p in payments %}<tr><td>{{ p.date|date:"D j M" }}</td><td>{{ p.item.party }}</td><td>{{ p.item.number }}</td><td>{{ p.item.priority }}</td><td class="r">{{ p.amount|inr }}</td>
<td>{% if p.discounted %}<span class="pill ok">discount {{ p.item.discount_pct|floatformat:0 }}%</span>{% endif %}{% if p.delay_days %}<span class="pill warn">deferred {{ p.delay_days }} d</span>{% endif %}</td></tr>{% endfor %}</tbody></table></div></section>
{% endblock %}