Edit Report:Luxury Brand Salon Sales
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Luxury Brand Salon Sales
-- Select Date Range. Select all Sales Reps.
-- ^Monthly Reports
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- ROLLUP: {
-- columns: {
-- "Oribe Total Sales": "Total: {{sum}}",
-- "Stephen J Total Sales": "Total: {{sum}}",
-- "K18 Total Sales": "Total: {{sum}}",
-- "BOB Total Sales": "Total: {{sum}}",
-- "Total Sales": "Total: {{sum}}",
-- }
-- }
--
SELECT
debtorno,
branchcode,
brname AS 'Salon Name',
salesmanname AS 'Salesman',
CAST(
SUM(
CASE WHEN supplierno = 'OR' THEN (discountedlinetotal * -1) ELSE 0 END
) AS DECIMAL (10, 2)
) AS 'Oribe Total Sales',
CAST(
SUM(
CASE WHEN supplierno = 'SJ' THEN (discountedlinetotal * -1) ELSE 0 END
) AS DECIMAL (10, 2)
) AS 'Stephen J Total Sales',
CAST(
SUM(
CASE WHEN supplierno = 'AH' THEN (discountedlinetotal * -1) ELSE 0 END
) AS DECIMAL (10, 2)
) AS 'K18 Total Sales',
CAST(
SUM(
CASE WHEN supplierno = 'CBB' THEN (discountedlinetotal * -1) ELSE 0 END
) AS DECIMAL (10, 2)
) AS 'BOB Total Sales',
sum(discountedlinetotal * -1) AS 'Total Sales'
FROM
stocktrans
WHERE
1
AND trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND loccode = '00'
AND brname like '%(LB)%'
AND supplierno IN ('CBB','AH','SJ','OR')
GROUP BY
debtorno