diff options
| author | Mark Wells <mark@freeside.biz> | 2016-01-08 17:03:46 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2016-01-09 16:14:36 -0800 |
| commit | 226279ba70554a39a2c81c736895f1b875b2d37f (patch) | |
| tree | a7ce72fee474cad8d750e2f767e70cefae5802cb /httemplate/REST/1.0 | |
| parent | 75944a8bdfc02166b16f2f6c03adcff75bf6cc3b (diff) | |
reconcile invoice destination contacts with multiple-customer contacts, #25536 and #27943
Diffstat (limited to 'httemplate/REST/1.0')
| -rw-r--r-- | httemplate/REST/1.0/cust_main | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/REST/1.0/cust_main b/httemplate/REST/1.0/cust_main index 5401195fc..a8b1511d9 100644 --- a/httemplate/REST/1.0/cust_main +++ b/httemplate/REST/1.0/cust_main @@ -51,7 +51,7 @@ if ( $r->method eq 'GET' ) { JOIN contact USING (contactnum) JOIN contact_email USING (contactnum) WHERE cust_main.custnum = cust_contact.custnum - AND contact.invoice_dest = 'Y' + AND cust_contact.invoice_dest = 'Y' AND contact_email.emailaddress = $dest ) "; @@ -62,7 +62,7 @@ if ( $r->method eq 'GET' ) { JOIN contact USING (contactnum) JOIN contact_email USING (contactnum) WHERE cust_main.custnum = cust_contact.custnum - AND contact.invoice_dest = 'Y' + AND cust_contact.invoice_dest = 'Y' AND contact_email.emailaddress ILIKE $dest ) "; |