@foreach ($accountingVouchers as $accountingVoucher) @foreach ($accountingVoucher->items as $key => $item) @if ($key == 0) @endif @endforeach @foreach ($accountingVoucher->items as $key => $item) @if ($key != 0) @endif @endforeach @endforeach

Voucher Date	Voucher Type	Voucher Number	Ledger Name	Ledger Alias	Ledger Amount	Ledger Amount Dr/Cr	Main Ledger	Main Ledger Dr/Cr	Item Name	Item Alias	Godown	Item HSN	Gst Percentage	Billed Quantity	Item Rate	Item Rate per	Discount %	Item Amount	CGST	CGST Amount	CGST Dr/Cr	SGST	SGST Amount	SGST Dr/Cr	CESS	CESS Amount	CESS Dr/Cr	IGST	IGST Amount	IGST Dr/Cr	Bill Discount	Bill Discount Amount	Bill Discount Dr/Cr	Round Off	Round Off Amount	Round Off Dr/Cr	Freight	Freight Amount	Freight Dr/Cr	TCS	TCS Amount	TCS Dr/Cr	Change Mode	Cancelled	Registraion Type	State	Country	Place Of Supply	GST No	Pincode	Address	Remarks	Supplier Inv No	Supplier Inv Date
{{ \Carbon\Carbon::parse($accountingVoucher->voucher_date)->format('d-m-Y') }}	{{ $accountingVoucher->voucherType->name }}	{{ $accountingVoucher->voucher_number }}	{{ $accountingVoucher->creditLedger->name }}	{{ $accountingVoucher->creditLedger->ledger_code }}	{{ $accountingVoucher->amount }}	Cr	{{ $accountingVoucher->debitLedger->name }}	Dr	{{ $item->stockItem->name }}	{{ $item->stockItem->item_code }}	{{ $accountingVoucher->stockLocation?->name }}	{{ $item->stockItem->hsn_code ?? '' }}	{{ $item->gst_per }}	{{ $item->quantity }}	{{ $item->price }}	{{ $item->unit->symbol }}	{{ $item->disc_percentage }}	{{ $item->taxable_value }}	CGST	{{ $accountingVoucher->items->sum('cgst') }}	Dr	SGST	{{ $accountingVoucher->items->sum('sgst') }}	Dr	CESS	{{ $accountingVoucher->items->sum('cess') }}	Dr	IGST	{{ $accountingVoucher->items->sum('igst') }}	Dr	Discount	{{ $accountingVoucher->discount ?? 0 }}	Cr	ROUND OFF	{{ $accountingVoucher->round_off >= 0 ? $accountingVoucher->round_off : -1 * $accountingVoucher->round_off }}	{{ $accountingVoucher->round_off >= 0 ? 'Dr' : 'Cr' }}	FREIGHT ETC	{{ $accountingVoucher->freight }}	Dr	TCS	{{ $accountingVoucher->tcs }}	Dr	Item invoice	{{ $accountingVoucher->status == 0 ? 'Yes' : 'No' }}	{{ $accountingVoucher->creditLedger->gst != 0 && $accountingVoucher->creditLedger->gst != null ? 'Regular' : 'Unregistered/Consumer' }}	{{ $accountingVoucher->creditLedger->state ?? 'Kerala' }}	{{ $accountingVoucher->creditLedger->country ?? 'India' }}	Kerala	{{ $accountingVoucher->creditLedger->gst }}	{{ $accountingVoucher->creditLedger->pincode }}	{{ $accountingVoucher->creditLedger->address }}	{{ $accountingVoucher->remarks }}	{{ $accountingVoucher->supplier_invoice_no }}	{{ $accountingVoucher->supplier_invoice_date != null ? \Carbon\Carbon::parse($accountingVoucher->supplier_invoice_date)->format('d-m-Y') : '' }}
									{{ $item->stockItem->name }}	{{ $item->stockItem->item_code }}	{{ $accountingVoucher->stockLocation?->name }}	{{ $item->stockItem->hsn_code ?? '' }}	{{ $item->gst_per }}	{{ $item->quantity }}	{{ $item->price }}	{{ $item->unit->symbol }}	{{ $item->disc_percentage }}	{{ $item->taxable_value }}