@foreach ($vouchers as $voucher) @php $gstPercentages = \App\Models\AccountingVoucherItem::where('accounting_voucher_id', $voucher->id) ->select('gst_per') ->groupBy('gst_per') ->get(); @endphp @foreach ($gstPercentages as $gstPercentage) @php $gst = $gstPercentage->gst_per; $acVoucherItems = \App\Models\AccountingVoucherItem::where('accounting_voucher_id', $voucher->id) ->where('gst_per', $gst) ->get(); @endphp @endforeach @endforeach

Supplier Name	Invoice Number	Invoice Date	Invoice Value	Place Of Supply	Supply Type	Rate	Taxable Value	Integrated Tax Paid	Central Tax Paid	State/UT Tax Paid	Cess Paid
{{ $voucher->creditLedger->name }}	{{ $voucher->supplier_invoice_no }}	{{ \Carbon\Carbon::parse($voucher->supplier_invoice_date)->format('d-m-Y') }}	{{ $voucher->amount }}	{{ $voucher->creditLedger->state_code }} - {{ $voucher->creditLedger->state }}	UnRegistered	{{ $gst }}	{{ $acVoucherItems->sum('taxable_value') }}	{{ $acVoucherItems->sum('igst') }}	{{ $acVoucherItems->sum('cgst') }}	{{ $acVoucherItems->sum('sgst') }}	{{ $acVoucherItems->sum('cess') }}