{% extends "inventory/base.html" %}{% load humanize_tags %}
{% block title %}Valuation{% endblock %}
{% block content %}
<h1>Inventory valuation <small>as of {{ as_of }} &middot; {{ method|upper }}</small></h1>
<form method="get" class="filters">
<label>As of <input type="date" name="as_of" value="{{ as_of|date:'Y-m-d' }}"></label>
<label>Period start <input type="date" name="start" value="{{ start|date:'Y-m-d' }}"></label>
<label>Method <select name="method"><option value="">Policy default</option><option value="fifo" {% if method == 'fifo' %}selected{% endif %}>FIFO</option><option value="wac" {% if method == 'wac' %}selected{% endif %}>Weighted average</option></select></label>
<button>Recalculate</button> <a class="btn" href="?{{ csv_query }}{% if csv_query %}&amp;{% endif %}format=csv">Export CSV</a></form>
<div class="kpis"><div class="kpi"><span>Book value</span><b>{{ total|money }}</b></div><div class="kpi"><span>NRV write-down</span><b>{{ write_down|money }}</b></div><div class="kpi"><span>Carrying value</span><b>{{ carrying|money }}</b></div></div>
<section class="card"><h2>Reconciliation <small>{{ start }} to {{ as_of }}</small></h2>
<table class="data compact recon"><tbody>
<tr><td>Opening value</td><td class="r">{{ rec.opening|money2 }}</td></tr>
<tr><td>+ Receipts</td><td class="r">{{ rec.receipts|money2 }}</td></tr>
<tr><td>+ Customer returns</td><td class="r">{{ rec.returns|money2 }}</td></tr>
<tr><td>- Cost of goods sold</td><td class="r">{{ rec.cogs|money2 }}</td></tr>
<tr><td>&plusmn; Adjustments</td><td class="r">{{ rec.adjustments|money2 }}</td></tr>
{% if rec.unbacked %}<tr><td>+ Issues without stock (negative stock offset)</td><td class="r">{{ rec.unbacked|money2 }}</td></tr>{% endif %}
<tr class="total"><td>= Closing value</td><td class="r">{{ rec.closing|money2 }}</td></tr>
<tr><td>Difference</td><td class="r">{{ rec.difference|money2 }}</td></tr></tbody></table></section>
<table class="data"><thead><tr><th>SKU</th><th>Name</th><th class="r">Qty</th><th class="r">Avg cost</th><th class="r">Value</th><th class="r">NRV</th><th class="r">Write-down</th><th class="r">Carrying</th></tr></thead>
<tbody>{% for r in rows %}<tr {% if r.write_down %}class="flag"{% endif %}><td><a href="{% url 'item' r.item.sku %}">{{ r.item.sku }}</a></td><td>{{ r.item.name }}</td><td class="r">{{ r.qty|qty }}</td><td class="r">{{ r.avg_cost|money2 }}</td><td class="r">{{ r.value|money2 }}</td><td class="r">{{ r.nrv|default_if_none:""|stringformat:"s" }}</td><td class="r">{{ r.write_down|money2 }}</td><td class="r">{{ r.carrying|money2 }}</td></tr>{% endfor %}</tbody></table>
{% endblock %}