{% 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('-') }}