INVENTORY VALUE REPORT

{{ $reportPeriod }}

Generated on {{ now()->format('d M Y H:i') }}

Total SKUs
{{ $totalSkus }}
Total Items
{{ number_format($totalItems) }}
Total Inventory Value
RM {{ number_format($totalValue, 2) }}
@if($warehouseBreakdown->count() > 0)

Warehouse Breakdown

@foreach($warehouseBreakdown as $warehouse)
{{ $warehouse->warehouse_name ?? 'Unassigned' }} @if($warehouse->warehouse_code) {{ $warehouse->warehouse_code }} @endif
SKUs: {{ $warehouse->sku_count }}
Total Items: {{ number_format($warehouse->total_quantity) }}
Total Value: RM {{ number_format($warehouse->total_value, 2) }}
@endforeach
@endif @foreach($inventory as $index => $item) @endforeach
No. SKU Product Name Quantity Warehouse Avg Cost Total Value Location
{{ $index + 1 }} {{ $item->sku }} {{ $item->product_name }} {{ $item->quantity }} @if(isset($item->warehouse_name))
{{ $item->warehouse_name }}
{{ $item->warehouse_code }}
@else - @endif 		@if($item->avg_cost > 0) RM {{ number_format($item->avg_cost, 2) }} @else - @endif RM {{ number_format($item->total_value, 2) }} {{ $item->location ?? '-' }}
TOTAL INVENTORY VALUE: RM {{ number_format($totalValue, 2) }}
@if($stockOutSummary->count() > 0)

STOCK OUT SUMMARY ({{ $reportPeriod }})

@foreach($stockOutSummary as $index => $item) @endforeach
No. SKU Product Name Warehouse Qty Out Transactions Type
{{ $index + 1 }} {{ $item->sku }} {{ $item->product_name ?? '-' }} @if($item->warehouse_name)
{{ $item->warehouse_name }}
{{ $item->warehouse_code }}
@else - @endif 		{{ number_format($item->total_out) }} {{ $item->transaction_count }} @php $types = explode(', ', $item->out_types ?? ''); $typeLabels = [ 'agent_sale' => 'Sales', 'order' => 'Order', 'transfer' => 'Transfer', 'adjustment' => 'Adjustment', ]; @endphp @foreach($types as $type) {{ $typeLabels[$type] ?? ucfirst($type) }} @endforeach
TOTAL STOCK OUT: {{ number_format($totalStockOut) }}
@else

STOCK OUT SUMMARY ({{ $reportPeriod }})

No stock out recorded for this period.

@endif
Note: Values are calculated based on the average unit cost from all purchase orders. Items without purchase history are valued at RM 0.00.

Prepared By:

{{ $user['name'] ?? 'User' }}

Name & Signature

Verified By:

______________________

Name & Signature

Printed on {{ now()->format('d M Y H:i:s') }} | {{ \App\Models\SystemSetting::getCompany('name', 'Company') }}

This is a computer-generated document. No signature is required unless specified.