Accounts Payable Summary

Bills - Payments - Advances

Supplier: {{ request('supplier_id') ?: 'All' }} Currency: {{ request('currency_id') ?: 'All' }} From: {{ request('date_from') ?: '-' }} To: {{ request('date_to') ?: '-' }} Only Open: {{ request('only_open')==1 ? 'Yes' : 'No' }}

Printed: {{ date('Y-m-d H:i') }}

@forelse($rows as $r) @php $sup = $supplierLookup[$r['supplier_id']] ?? null; $cur = $currencyLookup[$r['currency_id']] ?? null; $supName = $sup->name ?? ('Supplier #'.$r['supplier_id']); $curName = $cur->title_en ?? $cur->title_ps ?? ('CUR #'.$r['currency_id']); @endphp @empty @endforelse @if(count($rows)) @endif

Supplier	Currency	Bills	Bills Total	Payments	Advances	Outstanding	Outstanding (Base)
{{ $supName }}	{{ $curName }}	{{ $r['bill_count'] }}	{{ number_format((float)$r['bill_total'],2) }}	{{ number_format((float)$r['payment_total'],2) }}	{{ number_format((float)$r['advance_total'],2) }}	{{ number_format((float)$r['outstanding'],2) }}	{{ number_format((float)$r['outstanding_base'],2) }}
No data found.
Totals			{{ number_format((float)($totals['bill_total'] ?? 0),2) }}	{{ number_format((float)($totals['payment_total'] ?? 0),2) }}	{{ number_format((float)($totals['advance_total'] ?? 0),2) }}	{{ number_format((float)($totals['outstanding'] ?? 0),2) }}	{{ number_format((float)($totals['outstanding_base'] ?? 0),2) }}

Note: Base currency conversion is calculated using ex_rate. Outstanding = Bills - Payments - Advances.