<% include('/elements/header.html', 'Tax Report' ) %>

<& /elements/tr-select-agent.html, 'disable_empty'=>0 &> <& /elements/tr-input-beginning_ending.html &> <& /elements/tr-select.html, 'label' => 'Country', 'field' => 'country', 'options' => \@countries, 'curr_value' => ($conf->config('countrydefault') || 'US'), &> <& /elements/tr-select.html, 'label' => 'For tax named ', 'field' => 'taxname', 'options' => \@taxnames, 'disable_empty' => 1, &> <& /elements/tr-checkbox-multiple.html, 'label' => 'Break down by ', 'field' => 'breakdown', 'options' => \@breakdown, 'option_labels' => { taxclass => 'Tax class', pkgclass => 'Package class', city => 'City', district => 'District', }, &>

	<& /elements/radio.html, 'field' => 'all', 'value' => 1, 'curr_value' => 1, &> All taxes <& /elements/radio.html, 'field' => 'all', 'value' => 0, &> A specific tax
	Deduct credited tax if it was invoiced in this period credited in this period

<% include('/elements/footer.html') %> <%init> die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Financial reports'); my $conf = new FS::Conf; my $sth = dbh->prepare('SELECT DISTINCT(COALESCE(taxname, \'Tax\')) FROM cust_main_county'); $sth->execute or die $sth->errstr; my @taxnames = map { $_->[0] } @{ $sth->fetchall_arrayref }; $sth = dbh->prepare('SELECT DISTINCT(country) FROM cust_location'); $sth->execute or die $sth->errstr; my @countries = map { $_->[0] } @{ $sth->fetchall_arrayref }; my @breakdown; if ( $conf->exists('enable_taxclasses') ) { push @breakdown, 'taxclass'; } if ( FS::pkg_class->count() > 0 ) { push @breakdown, 'pkgclass'; } if ( FS::cust_main_county->count("city is not null and city != ''") > 0 ) { push @breakdown, 'city'; } if ( FS::cust_main_county->count("district is not null") > 0 ) { push @breakdown, 'district'; }