Edit Report:Customer Master (BRANCH)
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Customer Master (BRANCH)
--
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "today" }
-- }
--
-- VARIABLE: {
-- name: "location",
-- display: "Location",
-- type: "select",
-- database_options: { table: "locations", display: "locationname", column: "loccode" },
-- multiple:true,
-- }
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.area as AREA,
s.salesmanname as SALESPERSON,
d.salestype as TYPE,
d.paymentterms as TERMS,
d.creditlimit as CREDLIMIT,
c.defaultlocation as LOCATIONID,
d.clientsince as CLIENTSINCE
FROM
custbranch c
join debtorsmaster d on c.debtorno = d.debtorno
join salesman s on s.salesmancode = c.salesman
WHERE d.clientsince >= DATE("{{ range.start }}")
{% if location|length > 0 %}
and defaultlocation in (
{% for loc in location %}
'{{ loc }}'
{{ not loop.last ? ',' }}
{% endfor %})
{% endif %}
ORDER BY c.debtorno asc, c.branchcode asc