X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_tax-xls.cgi;h=07fcf7cfe29e9b3528930e0b52e2d0ead5229946;hb=e301521d1e90a50e9a776b2230c53c18a6fdeaa7;hp=773b403f1239c618991063312c36ac9caac846e5;hpb=80c2d997c5c983344c530ecbb46f94f1c299b35f;p=freeside.git diff --git a/httemplate/search/report_tax-xls.cgi b/httemplate/search/report_tax-xls.cgi index 773b403f1..07fcf7cfe 100755 --- a/httemplate/search/report_tax-xls.cgi +++ b/httemplate/search/report_tax-xls.cgi @@ -207,11 +207,11 @@ foreach my $row (@rows) { $x++; $ws->write_string($y, $x, " \N{U+2212} ", $f->{bigmath}); # MINUS SIGN $x++; - $ws->write($y, $x, $row->{credit} || 0, $f->{currency}); + $ws->write($y, $x, $row->{tax_credited} || 0, $f->{currency}); $x++; $ws->write_string($y, $x, " = ", $f->{bigmath}); $x++; - $ws->write($y, $x, $row->{tax} - $row->{credit}, $f->{currency}); + $ws->write($y, $x, $row->{tax} - $row->{tax_credited}, $f->{currency}); $x++; $ws->write($y, $x, $row->{tax_paid} || 0, $f->{currency}); @@ -221,11 +221,11 @@ foreach my $row (@rows) { } # at the end of everything -if ( $report->{outside} > 0 ) { +if ( $report->{out_sales} > 0 ) { my $f = $format[0]; $ws->set_row($y, 30); # height $ws->write($y, 0, mt('Out of taxable region'), $f->{rowhead_outside}); - $ws->write($y, 1, $report->{outside}, $f->{currency_outside}); + $ws->write($y, 1, $report->{out_sales}, $f->{currency_outside}); $y++; } @@ -292,6 +292,15 @@ foreach my $row (@rows) { $prev_row = $row; } +if ( $report->{out_credit} > 0 ) { + my $f = $format[0]; + $ws->set_row($y, 30); # height + $ws->write($y, 0, mt('Out of taxable region'), $f->{rowhead_outside}); + $ws->write($y, 1, $report->{out_credit}, $f->{currency_outside}); + $y++; +} + + for my $x (0..4) { $ws->set_column($x, $x, $widths[$x]); }