Moon Traders
Inventory Ledger Report
For the period {{ \Carbon\Carbon::parse($filters['start_date'] ?? now()->startOfMonth())->format('d-M-Y') }} to {{ \Carbon\Carbon::parse($filters['end_date'] ?? now())->format('d-M-Y') }}
Printed by: {{ auth()->user()->name }} | {{ now()->format('d-M-Y h:i A') }}

@php $runningBalance = $openingBalance; @endphp @forelse($entries as $entry) @php $runningBalance += (float)$entry->debit_qty - (float)$entry->credit_qty; @endphp @empty @endforelse @if($entries->isNotEmpty()) @endif

Date	Type	Product	Batch	Location	Reference	Debit (In)	Credit (Out)	Balance
{{ \Carbon\Carbon::parse($filters['start_date'] ?? now()->startOfMonth())->format('d M Y') }}	Opening Balance (Brought Forward)					-	-	{{ number_format($openingBalance, 2) }}
{{ $entry->date->format('d M Y') }}	{{ $transactionTypes[$entry->transaction_type] ?? $entry->transaction_type }}	{{ $entry->product?->product_code ?? '-' }} {{ $entry->product?->product_name ?? '' }}	{{ $entry->stockBatch?->batch_code ?? '-' }}	@if($entry->warehouse_id) 🏭 {{ $entry->warehouse?->warehouse_name ?? 'Warehouse' }} @elseif($entry->vehicle_id) 🚗 {{ $entry->vehicle?->registration_number ?? 'Van' }} @else - @endif	@if($entry->goods_receipt_note_id) GRN #{{ $entry->goodsReceiptNote?->grn_number ?? $entry->goods_receipt_note_id }} @elseif($entry->goods_issue_id) GI #{{ $entry->goodsIssue?->issue_number ?? $entry->goods_issue_id }} @elseif($entry->sales_settlement_id) SS #{{ $entry->salesSettlement?->settlement_number ?? $entry->sales_settlement_id }} @else {{ $entry->notes ?? '-' }} @endif	{{ (float)$entry->debit_qty > 0 ? number_format($entry->debit_qty, 2) : '-' }}	{{ (float)$entry->credit_qty > 0 ? number_format($entry->credit_qty, 2) : '-' }}	{{ number_format($runningBalance, 2) }}
@if(!empty($awaiting_filters)) Please select filters and click Apply to generate the report. @else No ledger entries found for the selected filters. @endif
{{ \Carbon\Carbon::parse($filters['end_date'] ?? now())->format('d M Y') }}	Closing Balance (Carried Forward)					{{ number_format($totalDebits, 2) }}	{{ number_format($totalCredits, 2) }}	{{ number_format($closingBalance, 2) }}