diff options
author | Mark Wells <mark@freeside.biz> | 2013-02-05 16:23:29 -0800 |
---|---|---|
committer | Mark Wells <mark@freeside.biz> | 2013-02-05 16:23:29 -0800 |
commit | fed12e8214a8a951377961ccbe7a09171b1e38c2 (patch) | |
tree | b3c902ff90c7397d49716844506a81f921ad9fa4 /httemplate/search/cust_bill_event.cgi | |
parent | fc8d730d0a7b31b617c963c5619bd3f45c5c3eb6 (diff) |
make customer location columns available in various reports, #940
Diffstat (limited to 'httemplate/search/cust_bill_event.cgi')
-rw-r--r-- | httemplate/search/cust_bill_event.cgi | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/search/cust_bill_event.cgi b/httemplate/search/cust_bill_event.cgi index 90c89139c..00f7cd564 100644 --- a/httemplate/search/cust_bill_event.cgi +++ b/httemplate/search/cust_bill_event.cgi @@ -100,7 +100,7 @@ my $where = 'WHERE '. FS::cust_bill_event->search_sql_where( \%search ); my $join = 'LEFT JOIN part_bill_event USING ( eventpart ) '. 'LEFT JOIN cust_bill USING ( invnum ) '. - 'LEFT JOIN cust_main USING ( custnum ) '; + FS::UI::Web::join_cust_main('cust_bill'); my $sql_query = { 'table' => 'cust_bill_event', |