Edit Report:Customer Master (BRANCH)
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Customer Master (BRANCH)
--
--
SELECT
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.taxgroupid as TAXCODE,
c.salesman as SALESID,
c.area as AREA,
s.salesmanname as SALESPERSON,
c.defaultlocation as STOCKWHSE
FROM
custbranch c
join salesman s on s.salesmancode = c.salesman
order by c.debtorno asc, c.branchcode asc