diff options
| author | mark <mark> | 2010-11-08 21:54:49 +0000 |
|---|---|---|
| committer | mark <mark> | 2010-11-08 21:54:49 +0000 |
| commit | 32d4b2de6b02a1f742913a4cc860ca1e85e67b47 (patch) | |
| tree | 4f70aa57ff69789d702edd6e957379790a6caee4 /httemplate/search/report_tax.cgi | |
| parent | 638bbf822aa6fb160a0372fab7ef082eb8c9fb83 (diff) | |
sales tax report in Excel, RT#10321
Diffstat (limited to 'httemplate/search/report_tax.cgi')
| -rwxr-xr-x | httemplate/search/report_tax.cgi | 48 |
1 files changed, 29 insertions, 19 deletions
diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi index 803b7d48f..93e5b51c9 100755 --- a/httemplate/search/report_tax.cgi +++ b/httemplate/search/report_tax.cgi @@ -10,35 +10,45 @@ ) ) %> +<TD ALIGN="right"> +Download full results<BR> +as <A HREF="<% $p.'search/report_tax-xls.cgi?'.$cgi->query_string%>">Excel spreadsheet</A> +</TD> <% include('/elements/table-grid.html') %> <TR> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3></TH> <TH CLASS="grid" BGCOLOR="#cccccc" COLSPAN=9>Sales</TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2>Rate</TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2>Tax owed</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3>Rate</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3>Tax owed</TH> % unless ( $cgi->param('show_taxclasses') ) { - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2>Tax invoiced</TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2>Tax credited</TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> - <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2>Tax collected</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3>Tax invoiced</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3>Tax credited</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=3>Tax collected</TH> % } </TR> <TR> - <TH CLASS="grid" BGCOLOR="#cccccc">Total</TH> - <TH CLASS="grid" BGCOLOR="#cccccc"></TH> - <TH CLASS="grid" BGCOLOR="#cccccc">Non-taxable<BR><FONT SIZE=-1>(tax-exempt customer)</FONT></TH> - <TH CLASS="grid" BGCOLOR="#cccccc"></TH> - <TH CLASS="grid" BGCOLOR="#cccccc">Non-taxable<BR><FONT SIZE=-1>(tax-exempt package)</FONT></TH> - <TH CLASS="grid" BGCOLOR="#cccccc"></TH> - <TH CLASS="grid" BGCOLOR="#cccccc">Non-taxable<BR><FONT SIZE=-1>(monthly exemption)</FONT></TH> - <TH CLASS="grid" BGCOLOR="#cccccc"></TH> - <TH CLASS="grid" BGCOLOR="#cccccc">Taxable</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2>Total</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=1>Non-taxable</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=1>Non-taxable</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=1>Non-taxable</TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2></TH> + <TH CLASS="grid" BGCOLOR="#cccccc" ROWSPAN=2>Taxable</TH> + </TR> + + <TR> + <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>(tax-exempt customer)</FONT></TH> + <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>(tax-exempt package)</FONT></TH> + <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>(monthly exemption)</FONT></TH> </TR> % my $bgcolor1 = '#eeeeee'; |