{% extends "core/base.html" %}{% load fmt %}
{% block title %}Accounts receivable{% endblock %}
{% block content %}
<h1>Accounts receivable</h1>
<p class="sub">As of {{ as_of|date:"j M Y" }} &middot; open AR {{ kpi.ar_total|inr }} &middot; DSO {{ kpi.dso|floatformat:1 }} days &middot; CEI {{ kpi.cei|floatformat:1 }}%</p>
<section class="card"><h2>Aging (days past due)</h2>{% include "core/_aging.html" %}</section>
<div class="cols">
<section class="card"><h2>Top overdue customers</h2><table class="t"><thead><tr><th>Customer</th><th class="r">Overdue</th><th class="r">Invoices</th><th class="r">Oldest</th></tr></thead><tbody>
{% for r in kpi.top_overdue %}<tr><td>{{ r.party }}</td><td class="r">{{ r.overdue|inr }}</td><td class="r">{{ r.invoices }}</td><td class="r">{{ r.oldest_days }} d</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Most overdue invoices</h2><table class="t"><thead><tr><th>Customer</th><th>Invoice</th><th class="r">Outstanding</th><th class="r">Days past due</th></tr></thead><tbody>
{% for r in rows|slice:":15" %}<tr><td>{{ r.i.party }}</td><td>{{ r.i.number }}</td><td class="r">{{ r.out|inr }}</td><td class="r {% if r.late > 60 %}neg{% endif %}">{{ r.late }}</td></tr>{% endfor %}</tbody></table></section>
</div>
{% endblock %}