{% load humanize %}
PT YOUR COMPANY NAME
AP CURRENT OUTSTANDING REPORT
As Of Date : {{ as_of_date|date:"d-m-Y" }}
Print Date : {{ now|date:"d-m-Y H:i" }}
Printed By : {{ request.user.username }}
IDR
| No |
Vendor |
Invoice No |
Due Date |
Days |
Bucket |
Balance |
{% for vendor in idr_data %}
| {{ forloop.counter }}. {{ vendor.vendor }} |
{% for row in vendor.rows %}
|
|
{{ row.invoice }} |
{{ row.duedate|date:"d-m-Y" }} |
{{ row.days }} |
{{ row.bucket }} |
{{ row.balance|intcomma }} |
{% endfor %}
| Subtotal |
{{ vendor.subtotal|intcomma }} |
{% empty %}
| No IDR data |
{% endfor %}
| GRAND TOTAL IDR |
{{ summary.IDR.total|intcomma }} |
USD
| No |
Vendor |
Invoice No |
Due Date |
Days |
Bucket |
Balance |
{% for vendor in usd_data %}
| {{ forloop.counter }}. {{ vendor.vendor }} |
{% for row in vendor.rows %}
|
|
{{ row.invoice }} |
{{ row.duedate|date:"d-m-Y" }} |
{{ row.days }} |
{{ row.bucket }} |
{{ row.balance|floatformat:2|intcomma }} |
{% endfor %}
| Subtotal |
{{ vendor.subtotal|floatformat:2|intcomma }} |
{% empty %}
| No USD data |
{% endfor %}
| GRAND TOTAL USD |
{{ summary.USD.total|floatformat:2|intcomma }} |