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/quotation.html | |
| parent | fc8d730d0a7b31b617c963c5619bd3f45c5c3eb6 (diff) | |
make customer location columns available in various reports, #940
Diffstat (limited to 'httemplate/search/quotation.html')
| -rwxr-xr-x | httemplate/search/quotation.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/search/quotation.html b/httemplate/search/quotation.html index 259c85c22..fbc35bea1 100755 --- a/httemplate/search/quotation.html +++ b/httemplate/search/quotation.html @@ -72,7 +72,7 @@ die "access denied" unless $curuser->access_right('List quotations'); my $join_prospect_main = 'LEFT JOIN prospect_main USING ( prospectnum )'; -my $join_cust_main = 'LEFT JOIN cust_main ON ( quotation.custnum = cust_main.custnum )'; +my $join_cust_main = FS::UI::Web::join_cust_main('quotation'); #here is the agent virtualization my $agentnums_sql = ' ( '. $curuser->agentnums_sql( table=>'prospect_main' ). |