aperezcrespo wrote on Monday, January 26, 2009:
Hello
When I try getting a collections report I always get this error message
ERROR: column customer.address1 does not exist LINE 1: …ar.shipvia, customer.id AS custid, customer.name, customer.a… ^: SELECT ar.id, ar.invnumber, ar.duedate, ar.amount, ar.paid, ar.intnotes, ar.notes, ar.shipvia, customer.id AS custid, customer.name, customer.address1, customer.city, customer.state, customer.zipcode, customer.phone FROM ar JOIN customer ON customer.id = ar.customer_id WHERE ( 1 = 1 ) AND ar.amount != ar.paid ORDER BY ar.invnumber
Any Ideas?
Thanks