Edit Report:Store Customer Sales by Supplier
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Store Customer Sales by Supplier
--
--
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "loccode",
-- display: "Store Code",
-- type: "text",
-- }
--
--
SELECT
s.loccode as 'Store Loc',
s.debtorno,
s.branchcode as 'Customer Code',
c.brname as 'Salon',
c.braddress3 as 'City',
c.phoneno as 'Phone No',
s.salesmanname as 'Sales Person',
s.suppliername as 'Supplier',
sum( -1 * discountedlinetotal ) AS 'Total Sales'
FROM
stocktrans s
INNER JOIN custbranch c ON c.debtorno = s.debtorno
AND c.branchcode = s.branchcode
WHERE
trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND loccode like '{{ loccode }}%'
AND suppliername like '{{ suppliername }}%'
AND loccode IN ('01', '02', '03', '04', '05', '06','07','08', '09', '10' )
GROUP BY
s.debtorno,
s.branchcode,
supplierno
ORDER BY
salesmanname,
c.brname