Edit Report:new customer report
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- new customer report
-- PLACE HOLDER REPORT DESCRIPTION
-- PLACE HOLDER REPORT FILTERS AND DRILL DOWN
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "salesman",
-- display: "salesman number",
-- type: "text",
-- }
-- FILTER: {
-- column: "DEBTORNO",
-- filter: "drilldown",
-- params: {
-- macros: { "debtorno": { column: "DEBTORNO" } },
-- report: "drilldown/customer-invoices.sql"
-- }
-- }
-- ignore
SELECT
clientsince as client_since,
custbranch.debtorno as customer_number,
brname as salon_name,
salesman as 'salesman number',
s.salesmanname as salesman_name,
phoneno as phone_number,
contactname as contact,
email as email_address,
braddress1 as street_address,
braddress3 as city,
braddress4 as province,
paymentterms
FROM
custbranch
inner join debtorsmaster on custbranch.debtorno = debtorsmaster.debtorno
inner join salesman s on custbranch.salesman = s.salesmancode
WHERE
clientsince BETWEEN '{{ range.start }}' AND '{{ range.end }}'
and custbranch.branchcode = custbranch.debtorno
AND salesman like '{{ salesman }}%'
order by salesman_name asc