Stock Movement Report

Generated on: {{ $report_date }}

Period: {{ $date_range['from'] }} to {{ $date_range['to'] }}

Summary

Total Movements: {{ number_format($summary['total_movements']) }}
Unique Products: {{ number_format($summary['unique_products']) }}
Affected Warehouses: {{ number_format($summary['affected_warehouses']) }}
Quantity In: +{{ number_format($summary['total_quantity_in']) }}
Quantity Out: -{{ number_format($summary['total_quantity_out']) }}
Net Change: {{ $summary['net_quantity_change'] >= 0 ? '+' : '' }}{{ number_format($summary['net_quantity_change']) }}
Total Value Moved: ${{ number_format($summary['total_value_moved'], 2) }}
@if(!empty($by_action_type))
Movement by Action Type
@foreach($by_action_type as $type) @endforeach
Action Type Count Total Quantity Total Value
{{ ucfirst(str_replace('_', ' ', $type['type'])) }} {{ number_format($type['count']) }} {{ number_format($type['total_quantity']) }} ${{ number_format($type['total_value'], 2) }}
@endif @if(!empty($by_product))
Top Products by Movement
@foreach($by_product as $product) @endforeach
Product ID Supplier Movements Qty In Qty Out Net Change Value In Value Out
{{ $product['product_id'] }} {{ $product['supplier'] }} {{ number_format($product['movements']) }} +{{ number_format($product['quantity_in']) }} -{{ number_format($product['quantity_out']) }} {{ $product['net_change'] >= 0 ? '+' : '' }}{{ number_format($product['net_change']) }} ${{ number_format($product['value_in'], 2) }} ${{ number_format($product['value_out'], 2) }}
@endif @if(!empty($daily_summary))
Daily Summary
@foreach($daily_summary as $day) @endforeach
Date Total Movements Quantity In Quantity Out Net Change
{{ $day['date'] }} {{ number_format($day['movements']) }} +{{ number_format($day['quantity_in']) }} -{{ number_format($day['quantity_out']) }} {{ $day['net_change'] >= 0 ? '+' : '' }}{{ number_format($day['net_change']) }}
@endif @if(!empty($movements))
Detailed Movements (Latest 500)
@forelse($movements as $movement) @empty @endforelse
Date/Time Product ID Supplier Warehouse Location Action Qty Before Change Qty After Unit Price User
{{ $movement['date'] }} {{ $movement['product_id'] }} {{ $movement['supplier'] }} {{ $movement['warehouse'] }} {{ $movement['location'] }} {{ ucfirst(str_replace('_', ' ', $movement['action'])) }} {{ number_format($movement['quantity_before']) }} {{ $movement['quantity_change'] >= 0 ? '+' : '' }}{{ number_format($movement['quantity_change']) }} {{ number_format($movement['quantity_after']) }} {{ $movement['unit_price'] ? '$' . number_format($movement['unit_price'], 2) : '-' }} {{ $movement['user'] }}
No movements found for the selected period
@else

No stock movements found for the selected period and filters.

@endif

This report was automatically generated by WHIMS - Inventory Management System

© {{ date('Y') }} Go-Parts. All rights reserved.