{{-- --}}
{{ strtoupper($dsr->distributor_name) }}
DSR No. {{ strtoupper($dsr->unique_id) }}
Load No. {{ strtoupper($dsr->load_unique_id) }}
Daily Sales Report
Date: {{ date('l, d-M-Y', strtotime($dsr->executed_date)) }} Saleman: {{ $dsr->saleman_name }}
@foreach ($brands as $brand) @foreach ($brand->items as $item) @endforeach @endforeach
Code Product Unit Issued Cancel MKT Return Sold FOC Rate Gross Amt. TO T. Disc SPC. Disc B. Disc Tax Net Sale
{{ $item->item_sku }} {{ $item->item_name }} {{ $item->unit_name }} {{ $item->total_dispatch_qty }} {{ $item->total_cancel_qty }} {{ $item->total_return_qty }} {{ $item->total_sold_qty }} {{ $item->total_foc_qty }} {{ number_format($item->item_trade_price, 2) }} {{ number_format($item->gross_sale_amount, 2) }} {{ number_format($item->total_trade_offer, 2) }} {{ number_format($item->total_trade_discount, 2) }} {{ number_format($item->total_special_discount, 2) }} {{ number_format($item->total_booker_discount, 2) }} {{ number_format($item->total_tax_amount, 2) }} {{ number_format($item->total_net_amount, 2) }}
{{ $brand->name }} - {{ $brand->total_dispatch_qty }} {{ $brand->total_cancel_qty }} {{ $brand->total_return_qty }} {{ $brand->total_sold_qty }} {{ $brand->total_foc_qty }} {{ number_format($brand->item_trade_price, 2) }} {{ number_format($brand->gross_sale_amount, 2) }} {{ number_format($brand->total_trade_offer, 2) }} {{ number_format($brand->total_trade_discount, 2) }} {{ number_format($brand->total_special_discount, 2) }} {{ number_format($brand->total_booker_discount, 2) }} {{ number_format($brand->total_tax_amount, 2) }} {{ number_format($brand->total_net_amount, 2) }}
Total: - {{ $inventories->sum('total_dispatch_qty') }} {{ $inventories->sum('total_cancel_qty') }} {{ $inventories->sum('total_return_qty') }} {{ $inventories->sum('total_sold_qty') }} {{ $inventories->sum('total_foc_qty') }} {{ number_format($inventories->sum('item_trade_price'), 2) }} {{ number_format($inventories->sum('gross_sale_amount'), 2) }} {{ number_format($inventories->sum('total_trade_offer'), 2) }} {{ number_format($inventories->sum('total_trade_discount'), 2) }} {{ number_format($inventories->sum('total_special_discount'), 2) }} {{ number_format($inventories->sum('total_booker_discount'), 2) }} {{ number_format($inventories->sum('total_tax_amount'), 2) }} {{ number_format($inventories->sum('total_net_amount'), 2) }}
   
   
Gross Amount: {{ number_format($dsr->total_gross_amount, 2) }}
Less Trade Offer: {{ number_format($dsr->total_trade_offer, 2) }}
Less Trade Disc: {{ number_format($dsr->total_trade_discount, 2) }}
Less Special Disc: {{ number_format($dsr->total_special_discount, 2) }}
Less Booker Disc: {{ number_format($dsr->total_booker_discount, 2) }}
+ Tax: {{ number_format($dsr->total_tax_amount, 2) }}
Net Amount: {{ number_format($dsr->total_net_amount, 2) }}
CREDIT & CHEQUE SALES DETAIL
@if (collect($creditChequeDetail)->count()>0) @foreach ($creditChequeDetail as $crChDetail) @php $cheque_number = ''; $cheque_date = ''; if($crChDetail->payment_mode=='Cheque'){ if(!empty($chequeDetail)){ $chequeDetail = json_decode($chequeDetail); $cheque_number = $chequeDetail->cheque_number; $cheque_date = $chequeDetail->cheque_date; } } @endphp @endforeach @else @endif
Bill No Party Name / Address Type Cheque No. Cheque Date Amount
{{ $crChDetail->invoice_number }} {{ $crChDetail->retailer_name }} {{ ucfirst($crChDetail->payment_mode) }} {{ $cheque_number }} {{ $cheque_date }} {{ number_format($crChDetail->amount_received, 2) }}
No Record Found
Total Credit Sales Amount: {{ number_format(collect($creditChequeDetail)->sum('amount_received'), 2) }}
RECOVERY DETAIL
@if (collect($recoveryDetail)->count()>0) @foreach ($recoveryDetail as $recovery) @endforeach @else @endif
Bill No Party Name / Address Type Mode Amount
{{ $recovery->invoice_number }} {{ $recovery->retailer_name }} {{ ($recovery->type=='Out Of Route')? 'Out Of Route' : 'Bill Recovery' }} {{ $recovery->payment_mode }} {{ number_format($recovery->recovered, 2) }}
No Record Found
Total Recovered Amount: {{ number_format(collect($recoveryDetail)->sum('recovered'), 2) }}
Net Sales Amount: {{ number_format($dsr->total_net_amount, 2) }}
Add Recovery: {{ number_format($dsr->total_recovered_amount, 2) }}
Less Credit Sales: {{ number_format($dsr->total_credit_amount, 2) }}
Total. Receivable AMT.: {{ number_format(($dsr->total_amount_recieveable), 2) }}
Cash Received: {{ number_format($dsr->total_cash_amount, 2) }}
Expenses: {{ number_format($dsr->total_expense, 2) }}
Cheque Amount: {{ number_format($dsr->total_cheque_amount, 2) }}
Sale Return: {{ number_format($dsr->total_return_amount, 2) }}
AMOUNT RECEIVED: {{ number_format($dsr->total_amount_recieved, 2) }}
EXCESS AMOUNT: {{ number_format($dsr->total_balance_amount, 2) }}