diff options
| author | Mark Wells <mark@freeside.biz> | 2016-01-08 17:03:46 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2016-01-08 17:04:04 -0800 |
| commit | 571291dda91dd92db80660aa3d67333b0c88fc34 (patch) | |
| tree | e2a2d75bca09be9d6e887d49675a7992d73c85d4 /httemplate/REST | |
| parent | c47980a8d9e1b83a80232674a57a875e319f9643 (diff) | |
reconcile invoice destination contacts with multiple-customer contacts, #25536 and #27943
Diffstat (limited to 'httemplate/REST')
| -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 ) "; |