@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

GSTIN/UIN of Recipient	Receiver Name	Invoice Number	Invoice Date	Invoice Value	Place Of Supply	Invoice Type	Rate	Taxable Value	Cess Amount
{{ $voucher->debitLedger->gst }}	{{ $voucher->debitLedger->name }}	{{ $voucher->voucher_number }}	{{ \Carbon\Carbon::parse($voucher->voucher_date)->format('d-m-Y') }}	{{ $voucher->amount }}	{{ $voucher->debitLedger->state_code }} - {{ $voucher->debitLedger->state }}	Regular B2B	{{ $gst }}	{{ $acVoucherItems->sum('taxable_value') }}	{{ $acVoucherItems->sum('cess') }}