Moon Traders

Sales Settlement Detail

Settlement #:

Date:

Salesman:

{{ $settlement->employee->name }} ({{ $settlement->employee->employee_code ?? '-' }})

Vehicle:

Warehouse:

Status:

Product-wise Settlement

@foreach($settlement->items as $item) @php $bfIn = 0; // Placeholder as per show.blade.php $bfOut = $bfIn + $item->quantity_issued - $item->quantity_sold - $item->quantity_returned - $item->quantity_shortage; @endphp @endforeach

#	Product	BF In	Issued	Batch Breakdown	Sold	Returned	Shortage	BF Out	Sales Value
{{ $item->line_no }}	{{ $item->product->product_code }} {{ $item->product->product_name }}	{{ number_format($bfIn, 2) }}	{{ number_format($item->quantity_issued, 2) }}	@if($item->batches->count() > 0) @foreach($item->batches as $b) {{ number_format($b->quantity_issued, 0) }} × {{ number_format($b->selling_price, 2) }} @if($b->is_promotional) (Promo) @endif [S:{{ $b->quantity_sold }} R:{{ $b->quantity_returned }} Sh:{{ $b->quantity_shortage }}] @endforeach @else No batch data @endif	{{ number_format($item->quantity_sold, 2) }}	{{ number_format($item->quantity_returned, 2) }}	{{ number_format($item->quantity_shortage, 2) }}	{{ number_format($bfOut, 2) }}	{{ number_format($item->total_sales_value, 2) }}
Totals:			{{ number_format($settlement->items->sum('quantity_issued'), 2) }}		{{ number_format($settlement->total_quantity_sold, 2) }}	{{ number_format($settlement->total_quantity_returned, 2) }}	{{ number_format($settlement->total_quantity_shortage, 2) }}		{{ number_format($settlement->total_sales_amount, 2) }}

@if($settlement->creditSales->count() > 0)

Credit Sales Detail

@foreach($settlement->creditSales as $credit) @endforeach

Customer	Invoice #	Notes	Sale Amount
{{ $credit->customer->customer_name ?? 'N/A' }}	{{ $credit->invoice_number ?? '-' }}	{{ $credit->notes ?? '-' }}	{{ number_format($credit->sale_amount, 2) }}
Total Credit Sales:			{{ number_format($settlement->credit_sales_amount, 2) }}

@endif @if($settlement->recoveries->count() > 0)

Recoveries (Received)

@foreach($settlement->recoveries as $recovery) @endforeach

Rec #	Customer	Method	Bank / Ref	Notes	Amount
{{ $recovery->recovery_number ?? '-' }}	{{ $recovery->customer->customer_name ?? 'N/A' }}	{{ $recovery->payment_method }}	@if($recovery->payment_method === 'bank_transfer') {{ $recovery->bankAccount->account_name ?? '-' }} @elseif($recovery->payment_method === 'cheque') {{ $recovery->cheque_number ?? '-' }} @else - @endif	{{ $recovery->notes ?? '-' }}	{{ number_format($recovery->amount, 2) }}
Total Recoveries:					{{ number_format($settlement->credit_recoveries, 2) }}

@endif @if($settlement->bankTransfers->count() > 0)

Bank Transfers

@foreach($settlement->bankTransfers as $transfer) @endforeach

Date	Customer	Receiving Bank	Ref #	Notes	Amount
{{ $transfer->transfer_date ? \Carbon\Carbon::parse($transfer->transfer_date)->format('d-M-y') : '-' }}	{{ $transfer->customer->customer_name ?? 'N/A' }}	{{ $transfer->bankAccount->account_name ?? 'Online' }}	{{ $transfer->reference_number ?? '-' }}	{{ $transfer->notes ?? '-' }}	{{ number_format($transfer->amount, 2) }}
Total Transfers:					{{ number_format($settlement->bank_transfer_amount, 2) }}

@endif @if($settlement->cheques->count() > 0)

Cheque Payments

@foreach($settlement->cheques as $cheque) @endforeach

Cheque #	Date	Customer	Bank Name	Holder	Status	Notes	Amount
{{ $cheque->cheque_number }}	{{ $cheque->cheque_date ? \Carbon\Carbon::parse($cheque->cheque_date)->format('d-M-y') : '-' }}	{{ $cheque->customer->customer_name ?? 'N/A' }}	{{ $cheque->bank_name }}	{{ $cheque->account_holder_name ?? '-' }}	{{ $cheque->status }}	{{ $cheque->notes ?? '-' }}	{{ number_format($cheque->amount, 2) }}
Total Cheques:							{{ number_format($settlement->cheques_collected, 2) }}

@endif

Expense Detail

@php $totalExpenses = 0; @endphp {{-- 1. General Expenses (All records in sales_settlement_expenses) --}} @forelse($settlement->expenses as $expense) @php $totalExpenses += $expense->amount; @endphp @empty @endforelse {{-- 2. Advance Tax (Added to main table as per show view) --}} @foreach($settlement->advanceTaxes as $tax) @php $totalExpenses += $tax->tax_amount; @endphp @endforeach

Expense Account / Description	Rcpt #	Amount
@if($expense->expenseAccount) {{ $expense->expenseAccount->account_name }} ({{ $expense->expenseAccount->account_code }}) @else {{ $expense->description ?? 'Unknown Account' }} @endif	{{ $expense->receipt_number ?? '-' }}	{{ number_format($expense->amount, 2) }}
Advance Tax - {{ $tax->customer->customer_name }} @if($tax->invoice_number) (Inv: {{ $tax->invoice_number }}) @endif (A/C 1161)	-	{{ number_format($tax->tax_amount, 2) }}
Total Expenses:		{{ number_format($totalExpenses, 2) }}

@if($settlement->amrPowders->count() > 0)

AMR Powder Details

@foreach($settlement->amrPowders as $amr) @endforeach

Product	Notes	Amount
{{ $amr->product->product_name }}	{{ $amr->notes ?? '-' }}	{{ number_format($amr->amount, 2) }}
Total AMR Powder:		{{ number_format($settlement->amrPowders->sum('amount'), 2) }}

@endif @if($settlement->amrLiquids->count() > 0)

AMR Liquid (FMR) Details

@foreach($settlement->amrLiquids as $amr) @endforeach

Product	Notes	Amount
{{ $amr->product->product_name }}	{{ $amr->notes ?? '-' }}	{{ number_format($amr->amount, 2) }}
Total AMR Liquid:		{{ number_format($settlement->amrLiquids->sum('amount'), 2) }}

@endif

Cash Denominations

@php $denoms = $settlement->cashDenominations->first(); $denomList = [5000, 1000, 500, 100, 50, 20, 10]; $coins = $denoms->denom_coins ?? 0; $totalCash = 0; @endphp @foreach($denomList as $val) @php $qty = $denoms->{"denom_$val"} ?? 0; $amt = $qty * $val; $totalCash += $amt; @endphp @endforeach @php $totalCash += $coins; @endphp

Denomination	Qty	Amount
{{ number_format($val) }}	{{ $qty > 0 ? $qty : '0' }}	{{ $amt > 0 ? number_format($amt, 2) : '-' }}
Coins	-	{{ number_format($coins, 2) }}
Total Physical Cash:		{{ number_format($totalCash, 2) }}

Sales Summary

@php $shortageVal = 0; foreach ($settlement->items as $i) { $price = $i->unit_selling_price > 0 ? $i->unit_selling_price : $i->unit_cost; $shortageVal += $i->quantity_shortage * $price; } @endphp

Total Sale Amount	{{ number_format($settlement->total_sales_amount, 2) }}
Credit Sales	{{ number_format($settlement->credit_sales_amount, 2) }}
Cheque Sales	{{ number_format($settlement->cheque_sales_amount ?? 0, 2) }}
Bank Transfer	{{ number_format($settlement->bank_transfer_amount, 2) }}
Cash Sales	{{ number_format($settlement->cash_sales_amount ?? 0, 2) }}
Net Sale (Sold Items Value)	{{ number_format($settlement->items->sum('total_sales_value'), 2) }}
Recovery (Cash + Bank)	{{ number_format($settlement->credit_recoveries, 2) }}
Shortage Value	{{ number_format($shortageVal, 2) }}

_______________________
Salesman Signature

_______________________
Verified By

_______________________
Approved By

Printed by: {{ auth()->user()->name }} | {{ now()->format('d-M-Y h:i A') }}