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_credit_bill_pkg.html | |
parent | fc8d730d0a7b31b617c963c5619bd3f45c5c3eb6 (diff) |
make customer location columns available in various reports, #940
Diffstat (limited to 'httemplate/search/cust_credit_bill_pkg.html')
-rw-r--r-- | httemplate/search/cust_credit_bill_pkg.html | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/cust_credit_bill_pkg.html b/httemplate/search/cust_credit_bill_pkg.html index 8b21f37..26da106 100644 --- a/httemplate/search/cust_credit_bill_pkg.html +++ b/httemplate/search/cust_credit_bill_pkg.html @@ -383,8 +383,8 @@ my $count_query = "SELECT COUNT(DISTINCT creditbillpkgnum), SUM(cust_credit_bill_pkg.amount)"; my $join_cust = - ' JOIN cust_bill ON ( cust_bill_pkg.invnum = cust_bill.invnum ) - LEFT JOIN cust_main ON ( cust_bill.custnum = cust_main.custnum ) '; + ' JOIN cust_bill ON ( cust_bill_pkg.invnum = cust_bill.invnum )'. + FS::UI::Web::join_cust_main('cust_bill', 'cust_pkg'); my $join_pkg; |