Edit Report:YTD Sales By Store Locations; Suppliers: Redken, Living Proof, Evo, Amika + Olaplex
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- YTD Sales By Store Locations; Suppliers: Redken, Living Proof, Evo, Amika + Olaplex
-- Select Date Range.
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- ROLLUP: {
-- columns: {
-- "YTD SALES": "Total: {{sum}}"
-- }
-- }
SELECT
loccode AS 'LOCATION CODE',
supplierno AS 'SUPPLIER NO',
suppliername AS 'SUPPLIER',
sum( discountedlinetotal * - 1 ) AS 'YTD SALES'
FROM
stocktrans
WHERE
trandate BETWEEN ( '{{ range.start }}' ) AND ( '{{ range.end }}' )
AND salesperson IN ( SELECT salesmancode FROM salesman WHERE commissionrate1 = 1 )
AND loccode IN ('01', '02', '03', '04', '05', '06', '07', '08')
AND supplierno IN ('RK', 'LP', 'EV', 'AM', 'OX')
GROUP BY
loccode,
supplierno
ORDER BY
supplierno,
loccode ASC