Edit Report:Customer Master (BRANCH) no emails
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Customer Master (BRANCH) no emails
--
--
SELECT
d.name as BILLTO,
c.debtorno as CUSTOMERNO,
c.branchcode as SHIPTONO,
c.brname as SHIPTO,
c.braddress1 as ADD1,
c.braddress2 as ADD2,
c.braddress3 as ADD3,
c.braddress4 as PROVINCE,
c.braddress5 as POSTALCODE,
c.braddress6 as COUNTRY,
c.salesman as SALESID,
c.email as EMAIL,
c.area as AREA,
s.salesmanname as SALESPERSON,
d.salestype as TYPE,
d.paymentterms as TERMS,
d.creditlimit as CREDLIMIT,
c.defaultlocation as STOCKWHSE,
d.clientsince as CLIENTSINCE
FROM
custbranch c
join debtorsmaster d on c.debtorno = d.debtorno
join salesman s on s.salesmancode = c.salesman
WHERE
c.email = "" or c.email IS NULL
order by c.debtorno asc, c.branchcode asc