X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2FREST%2F1.0%2Fcust_main;fp=httemplate%2FREST%2F1.0%2Fcust_main;h=a8b1511d9f9b852d5c5ca6e819857a3ff2d32ceb;hp=5401195fc4d4e2522dd94acd3b0bb9b8bde77569;hb=571291dda91dd92db80660aa3d67333b0c88fc34;hpb=c47980a8d9e1b83a80232674a57a875e319f9643

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
                      )
       ";