Date : {!! formatedDate(date('Y-m-d')) !!}

{!! $company->name ?? '' !!}

Item Wise Sales Return Statement

Report List From {{$from_date?formatedDate($from_date):formatedDate(date('Y-m-d H:i:s'))}} TO {{$to_date?formatedDate($to_date):formatedDate(date('Y-m-d H:i:s')) }}

Time : {!! formatedTime(date('H:i:s')) !!}

@if(isset($saleInvoices) && count($saleInvoices) > 0) @php $companyState = $company->getCompanyAddress->getComapnyState->name??null; $i = 1; $total_amount = $total_pack = $total_loose = $total_basic = $total_tax = 0; $IgstAmount = $CgstAmount = $SgstAmount = $CessAmount = 0; $discountAmount = 0; $productPriceAfterDiscount = 0; $totalValueAmount = 0; $totalIgstAmount = $totalCgstAmount = $totalSgstAmount = $totalCessAmount = 0; $totalValue = 0; $totalValueAmount = 0; $discountAmount = 0; $totalAmount = 0; $productPriceAfterDiscount = 0; $totalMrp = 0; @endphp @foreach($saleInvoices as $invoice) @php $discountAmount = $invoice->price * ($invoice->discount_percentage / 100); $totalMrp +=$invoice->price; $productPriceAfterDiscount = $invoice->price - $discountAmount; $totalValueAmount = $productPriceAfterDiscount*$invoice->main_qty; $patientState = getAccountState($invoice->patient_id); @endphp @if(!empty($invoice->bill_to_name)) @else @endif @php if ( isset( $invoice->getProduct ->getTaxMaster ->getTaxMasterSub, ) ) { foreach ($invoice->getProduct->getTaxMaster->getTaxMasterSub as $tax) { if ($tax->name == 'IGST') { $IGST = $tax->percentage ??0; $IgstAmount = taxAmountCalculate($tax->percentage,$totalValueAmount); $totalIgstAmount+=$IgstAmount; } elseif ( $tax->name == 'CGST' ) { $CGST = $tax->percentage ??0; $CgstAmount = taxAmountCalculate($tax->percentage,$totalValueAmount); $totalCgstAmount+=$CgstAmount; } elseif ( $tax->name == 'SGST' ) { $SGST = $tax->percentage ?? 0; $SgstAmount = taxAmountCalculate($tax->percentage,$totalValueAmount); $totalSgstAmount+=$SgstAmount; }elseif($tax->name == 'CESS') { $CESS = $tax->percentage ??0; $CessAmount = taxAmountCalculate($tax->percentage,$totalValueAmount); $totalCessAmount+=$CessAmount; } } } @endphp @php $tax_per = $invoice->tax != 'Tax Free' ? preg_replace('/[^0-9]/', '', $invoice->tax ?? 0,) : 0; $quantity = !empty($invoice->main_qty) ? $invoice->main_qty : $invoice->alt_qty; $discountAmount = $invoice->price * ($invoice->discount_percentage / 100); $productPriceAfterDiscount = $invoice->price - $discountAmount; $totalValueAmount = $productPriceAfterDiscount*$invoice->main_qty; $tax = taxAmountCalculate($tax_per,$totalValueAmount); $total_tax += $tax; @endphp @php $i += 1; $total_amount += convertDecimelPoint(round($invoice->total_amount)); $total_pack += $invoice->main_qty ?? 0; $total_loose += $invoice->alt_qty ?? 0; $total_basic += convertDecimelPoint(round($invoice->basic_amount)) ?? 0; $total_tax += convertDecimelPoint(round($tax)); @endphp @endforeach @else @endif

Sl.	Invoice	Bill To	Consultant	Voucher	Item Name	Category	HSN	QTY (Pack)	QTY (Loose)	Tax (%)	IGST (%)	IGST (Amt)	CGST (%)	CGST (Amt)	SGST (%)	SGST (Amt)	CESS (%)	CESS (Amt)	Basic Amt.	Total Tax	Total Amt.
{!! $i !!}	{!! $invoice->voucher_type_invoice_no ?? '' !!} {!! ($invoice->invoice_date ? formatedDate($invoice->invoice_date) : '') !!}	{!! $invoice->bill_to_name ?? '' !!}	{!! $invoice->account_name ?? '' !!} {!! $invoice->account_code ?? '' !!}	@if(!empty($invoice->doctor_name)) Dr {!! $invoice->doctor_name ?? '' !!} @else Self @endif	{!! $invoice->voucher_type_name ?? '' !!}	{!! $invoice->product_name ?? '' !!}	{!! $invoice->product_category ?? '' !!}	{!! $invoice->hsncode ?? '' !!}	{!! $invoice->main_qty ?? '' !!}	{!! $invoice->alt_qty ?? '' !!}	{!! $tax_per ?? '' !!}%	@if($companyState != $patientState) {!! $IGST??0 !!} @else 0 @endif	@if($companyState != $patientState) {!! convertDecimelPoint($IgstAmount)??0 !!} @else 0 @endif	@if($companyState == $patientState) {!! $CGST??0 !!} @else 0 @endif	@if($companyState == $patientState) {!! convertDecimelPoint($CgstAmount)??0 !!} @else 0 @endif	@if($companyState == $patientState) {!! $SGST??0 !!} @else 0 @endif	@if($companyState == $patientState) {!! convertDecimelPoint($SgstAmount)??0 !!} @else 0 @endif	{!! $CESS??0 !!}	{!! convertDecimelPoint($CessAmount)??0 !!}	{!! $invoice->basic_amount !!}	{!! $tax !!}	{!! $invoice->total_amount !!}
Total								{{ $total_pack }}	{{ $total_loose }}										{{ convertDecimelPoint($total_basic) }}	{{ convertDecimelPoint($total_tax) }}	{{ convertDecimelPoint($total_amount) }}
No Records Found