<% k = 1 creditdays = 0 outstanding = 0 if @allList.length >0 @allList.each do |aprov| custobj = get_customer_credit_days(aprov.qt_customers) if custobj creditdays = custobj.creditdays outstanding = custobj.outstanding end crdpmtobj = get_customer_last_payment(aprov.qt_customers) custtopmt = get_customer_total_payment(aprov.qt_customers) lastpamdate = '' lastnetpay = 0 if crdpmtobj lastpamdate = crdpmtobj.pr_date lastnetpay = crdpmtobj.pr_netamount end if aprov.qdt_netamount.to_f >0 # outstanding = aprov.qdt_netamount.to_f-custtopmt.to_f end %> <% k +=1 end else %> <% end %>

S.No	Quotation No.	Quotation Date	Customer Name	Total Qty	Total Value	Total Disc	Total Tax	Net Amount	Total Product(s)	Credit Days	Total Outstanding	Last Payment Date	Last Payment Amount	Approval Status	View
<%=k%>	<%=aprov.qt_quotno%>	<%=formatted_date(aprov.qt_quotdate)%>	<%=aprov.cs_customername%>	<%=currency_formatted(aprov.totalqty)%>	<%=currency_formatted(aprov.tvalues)%>	<%=currency_formatted(aprov.totaldiscount)%>	<%=currency_formatted(aprov.totaltax)%>	<%=currency_formatted(aprov.qdt_netamount)%>	<%=aprov.totalprod%>	<%=creditdays%>	<%=currency_formatted(outstanding)%>	<%=formatted_date(lastpamdate)%>	<%=currency_formatted(lastnetpay)%>	<% if aprov.qt_status =='AP' %> Approved <% elsif aprov.qt_status =='PK' %> Packed <% elsif aprov.qt_status =='C' %> Cancelled <% else %> <% end %>
No Record(s) Found