{% if pagination == 'emptyfilters' %}
Please select from the above filters to generate a report.
{% elseif pagination is empty %}
There are currently no records to show
{% else %} {% set grand_total = 0 %} {% for entity in pagination %} {% set grand_total = grand_total + entity.total %} {% endfor %}
{{ knp_pagination_sortable(pagination, 'Date', 't.date')|raw }} {{ knp_pagination_sortable(pagination, 'Account No', 't.account_number')|raw }} {{ knp_pagination_sortable(pagination, 'Account', 't.account_name')|raw }} {{ knp_pagination_sortable(pagination, 'Invoice No', 't.invoice_number')|raw }} {{ knp_pagination_sortable(pagination, 'Description', 't.description')|raw }} Inventory Category {{ knp_pagination_sortable(pagination, 'Amount', 't.total')|raw }}
{{ entity.date|date('Y-m-d') }} {{ entity.account_number | trim }} {{ entity.account_name | trim }} {{ entity.invoice_number | trim }} {{ entity.description | trim }} {% if ',' not in entity.category_item_ids %} {{ entity.category_item | trim}} {% else %} Mixed {% endif %} {% if ',' not in entity.category_ids %} {{ entity.category_description | trim}} {% else %} Mixed {% endif %} {{ d2_config('currency_symbol') }} {{ entity.total | number_format(2, '.', ' ') | trim('-') }}
Grand Total {{ d2_config('currency_symbol') }} {{ grand_total | number_format(2, '.', ' ') | trim('-') }}
{% endif %}