FUEL INVENTORY REPORT

Inventory Report From {{\Carbon\Carbon::parse($open_balance['startdate'])->toFormattedDateString()}} To {{\Carbon\Carbon::parse($open_balance['enddate'])->toFormattedDateString()}}

{{--*/ $in_quantity_total = 0 /*--}} {{--*/ $out_quantity_total = 0 /*--}} {{--*/ $avarage_price = $open_balance['avarage_price'] /*--}} {{--*/ $balance_quantity = $open_balance['open_quantity'] /*--}} @foreach($fuel_inventories as $index=>$inventory) {{----}} {{----}} {{----}} {{--*/ $in_quantity_total += $inventory['in_quantity'] /*--}} {{--*/ $out_quantity_total += $inventory['out_quantity'] /*--}} {{----}} {{----}} {{--*/ $in_quantity_total += $inventory['in_quantity'] /*--}} {{--*/ $out_quantity_total += $inventory['out_quantity'] /*--}} {{--*/ $balance_quantity += $inventory['in_quantity'] /*--}} {{--*/ $balance_quantity -= $inventory['out_quantity'] /*--}} {{--*/ $avarage_price = $inventory['average_price'] /*--}} @if($inventory['in_price']>0) @endif {{----}} {{-- --}} @endforeach
  Quantity
REF Date Equipment/Vehicle Inward Outward Balance
OPEN BALANCE AS OF {{\Carbon\Carbon::parse($open_balance['startdate'])->toFormattedDateString()}} {{number_format($open_balance['open_quantity'])}}
{{ ++$index}}{{ $inventory['ref']}}{{ \Carbon\Carbon::parse($inventory['date'])->toFormattedDateString()}} {{ $inventory['registration_number']}} {{number_format($inventory['in_quantity'])}}{{number_format($inventory['in_price'],2)}}{{number_format($inventory['in_amount'],2)}}{{number_format($inventory['out_quantity'])}}{{number_format($inventory['out_price'],2)}}{{number_format($inventory['out_amount'],2)}}{{number_format($balance_quantity)}}{{number_format($inventory['average_price'])}}{{number_format($inventory['average_price']*$balance_quantity)}}
TOTAL INWARD {{number_format($in_quantity_total)}} {{number_format($out_quantity_total)}} {{number_format($balance_quantity)}}