<%= render "layouts/portlet-config" %> <%= render "layouts/theme-panel" %> <% if flash[:error] %>
× <%= flash[:error] %>
<% end %> <%= render "layouts/breadcrumbs" %>
 
5, 6, 7, 11, 14, 10, 15, 19, 15, 2
CT(<%=@tprvcounts %>)
Sales
<%=@totalsale %>
66% Complete
2,6,8,12, 11, 15, 16, 11, 16, 11, 10, 3, 7, 8, 12, 19
CT(<%=@trcardcounts%>)
Card
<%=@totalcard%>
16% Complete
2,6,8,11, 14, 11, 12, 13, 15, 12, 9, 5, 11, 12, 15, 9,3
CT( <%=@trcashcounts%>)
Cash
<%=@totalcash%>
16% Complete
1,4,9,12, 10, 11, 12, 15, 12, 11, 9, 12, 15, 19, 14, 13, 15
CT(<%=@trecvcounts%>)
Receive
<%=@totalrecv%>
56% Complete
2,6,8,12, 11, 15, 16, 17, 14, 12, 10, 8, 10, 2, 4, 12, 19
CT(<%=@tprschcounts%>)
Purchase
<%=@totalprsch%>
72% Complete
1,7,9,11, 14, 12, 6, 7, 4, 2, 9, 8, 11, 12, 14, 12, 10
CT(<%=@tpmtcounts%>)
Payment
<%=@totalpmt%>
15% Complete
<% @isflgs = false if @chkpieyear.to_i >0 && @chkpiemth.to_i >0 @isflgs = true elsif @tpies.to_i >0 @isflgs = true end %> <% if @isflgs %>
Consolidated Report
<%= form_tag({:action=>'create'} ,:multipart=>true,:id=>'isMyForms' ) do %> <% end %>
 
 
 
 
<% end %>
Monthly Revenue
<%= form_tag({:action=>'create'} ,:multipart=>true,:id=>'myChartForms' ) do %> <% end %>
<% k =1 lstTotal = 0 if @LastTransaction.length >0 @LastTransaction.each do | lstns | %> <% if lstns.hd_billdate.to_s!=nil && lstns.hd_billdate.to_s!='' datex = Date.parse(lstns.hd_billdate.to_s).strftime('%d-%b-%Y') else datex = "NA" end if lstns.totalAmopunt!=nil && lstns.totalAmopunt!='' lstTotal +=lstns.totalAmopunt end %> <% k +=1 end end %>
Sl.No Document Date Document No. Amount() Ledger Name
<%=k%> <%=datex%> <%=lstns.hd_billnumber%> <%= '%.2f' % lstns.totalAmopunt%> <%=lstns.cs_customername.capitalize%>
Total <%='%.2f' % lstTotal.to_f%>
Tax Summary
<% x = 1 tqnt = 0 ttaxable = 0 tigst = 0 tcgst = 0 tsgst = 0 ttaxamt = 0 tnetamt = 0 dtqnt = 0 dttaxable = 0 dtigst = 0 dtcgst = 0 dtsgst = 0 dttaxamt = 0 dtnetamt = 0 if @curBillingSumary.length >0 @curBillingSumary.each do | billsum | if billsum.hd_sale_type =='SR' || billsum.hd_sale_type =='P' if billsum.tqnty >0 tqnt +=billsum.tqnty end if billsum.tAmount!=nil && billsum.tAmount!='' ttaxable +=billsum.tAmount end if billsum.dt_igstamount!=nil && billsum.dt_igstamount!='' tigst +=billsum.dt_igstamount end if billsum.dt_cgstamount!=nil && billsum.dt_cgstamount!='' tcgst +=billsum.dt_cgstamount end if billsum.dt_sgstamount!=nil && billsum.dt_sgstamount!='' tsgst +=billsum.dt_sgstamount end if billsum.tTaxAmt!=nil && billsum.tTaxAmt!='' ttaxamt +=billsum.tTaxAmt end if billsum.tNetAmount!=nil && billsum.tNetAmount!='' tnetamt +=billsum.tNetAmount end end if billsum.hd_sale_type =='PR' || billsum.hd_sale_type =='S' || billsum.hd_sale_type =='SL' || billsum.hd_sale_type =='SO' if billsum.tqnty >0 dtqnt +=billsum.tqnty end if billsum.tAmount!=nil && billsum.tAmount!='' dttaxable +=billsum.tAmount end if billsum.dt_igstamount!=nil && billsum.dt_igstamount!='' dtigst +=billsum.dt_igstamount end if billsum.dt_cgstamount!=nil && billsum.dt_cgstamount!='' dtcgst +=billsum.dt_cgstamount end if billsum.dt_sgstamount!=nil && billsum.dt_sgstamount!='' dtsgst +=billsum.dt_sgstamount end if billsum.tTaxAmt!=nil && billsum.tTaxAmt!='' dttaxamt +=billsum.tTaxAmt end if billsum.tNetAmount!=nil && billsum.tNetAmount!='' dtnetamt +=billsum.tNetAmount end end %> <% x +=1 end end %>
Sl.No Sale Type HSN Code Qnt. Taxable Value IGST CGST SGST Total Tax Value Net Amount
% Value % Value % Value
<%=x%> <% if billsum.hd_sale_type =='S' || billsum.hd_sale_type =='SL' || billsum.hd_sale_type =='SO' %> Sale <% elsif billsum.hd_sale_type =='SR' %> Sale Return <% elsif billsum.hd_sale_type =='P' %> Purchase <% elsif billsum.hd_sale_type =='PR' %> Purchase Return <% end %> <%=billsum.dt_hsncode%> <%=billsum.tqnty%> <%= '%.2f' % billsum.tAmount%> <%= '%.2f' % billsum.dt_igst%> <%= '%.2f' % billsum.dt_igstamount%> <%= '%.2f' % billsum.dt_cgst%> <%= '%.2f' % billsum.dt_cgstamount%> <%= '%.2f' % billsum.dt_sgst%> <%= '%.2f' % billsum.dt_sgstamount%> <%= '%.2f' % billsum.tTaxAmt%> <%= '%.2f' % billsum.tNetAmount%>
Total Credit <%= '%.2f' % tqnt%> <%= '%.2f' % ttaxable%> <%= '%.2f' % tigst%> <%= '%.2f' % tcgst%> <%= '%.2f' % tsgst%> <%= '%.2f' % ttaxamt%> <%= '%.2f' % tnetamt%>
Total Debit <%= '%.2f' % dtqnt%> <%= '%.2f' % dttaxable%> <%= '%.2f' % dtigst%> <%= '%.2f' % dtcgst%> <%= '%.2f' % dtsgst%> <%= '%.2f' % dttaxamt%> <%= '%.2f' % dtnetamt%>
Difference <% tdiff= dttaxamt-ttaxamt %> <%= '%.2f' % tdiff%>
Calendar
<% j= 1 billdate = '' amcdate = '' crdate = '' if @calendardetail.length >0 @calendardetail.each do |calday| if calday.hd_billdate!=nil && calday.hd_billdate!='' bildt = calday.hd_billdate.to_s.split('-') billdate = bildt[2].sub(/^0/, "") else billdate = '' end if calday.hd_amcdate!=nil && calday.hd_amcdate!='' amcdt = calday.hd_amcdate.to_s.split('-') amcdate = amcdt[2].sub(/^0/, "") else amcdate = '' end if calday.creaditdate!=nil && calday.creaditdate!='' crdt = calday.creaditdate.to_s.split('-') crdate = crdt[2].sub(/^0/, "") else crdate = '' end %> <% if calday.credDays!=nil && calday.credDays!='' && calday.credDays.to_i >0 %> <% else %> <% end %> <% j +=1 end else %> <% end %> <% c = 1 brdate = '' if @btodolisted.length >0 @btodolisted.each do |bday| if bday.rc_type!=nil && bday.rc_type!='' if bday.rc_date!=nil && bday.rc_date!='' bdte = bday.rc_date.to_s.split('-') brdate = bdte[2].sub(/^0/, "") end else brdate = '' end %> <% c +=1 end else %> <% end %>