<%= render "layouts/portlet-config" %>
<%= render "layouts/theme-panel" %>
<% if flash[:error] %>
<%
@isflgs = false
if @chkpieyear.to_i >0 && @chkpiemth.to_i >0
@isflgs = true
elsif @tpies.to_i >0
@isflgs = true
end
%>
<%
if @isflgs
%>
<% end %>
×
<%= flash[:error] %>
<% end %>
<%= render "layouts/breadcrumbs" %>
5, 6, 7, 11, 14, 10, 15, 19, 15, 2
CT(<%=@tprvcounts %>)
Sales
<%=@totalsale %>
2,6,8,12, 11, 15, 16, 11, 16, 11, 10, 3, 7, 8, 12, 19
CT(<%=@trcardcounts%>)
Card
<%=@totalcard%>
2,6,8,11, 14, 11, 12, 13, 15, 12, 9, 5, 11, 12, 15, 9,3
CT( <%=@trcashcounts%>)
Cash
<%=@totalcash%>
CT(<%=@trecvcounts%>)
Receive
<%=@totalrecv%>
2,6,8,12, 11, 15, 16, 17, 14, 12, 10, 8, 10, 2, 4, 12, 19
CT(<%=@tprschcounts%>)
Purchase
<%=@totalprsch%>
1,7,9,11, 14, 12, 6, 7, 4, 2, 9, 8, 11, 12, 14, 12, 10
CT(<%=@tpmtcounts%>)
Payment
<%=@totalpmt%>
Consolidated Report
<%= form_tag({:action=>'create'} ,:multipart=>true,:id=>'isMyForms' ) do %>
<% end %>
Last Ten Transactions
<%
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%> |
<%
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 %>