Edit Report:Store YTD Sales Rep + DSC Breakdown
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Store YTD Sales Rep + DSC Breakdown
-- PLACE HOLDER REPORT DESCRIPTION
-- PLACE HOLDER REPORT FILTERS AND DRILL DOWN
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
select locations.loccode, locations.locationname,
(SELECT sum(discountedlinetotal * -1)
FROM
stocktrans
WHERE
loccode=locations.loccode AND YEAR (trandate)='2025' AND salesperson IN ( SELECT salesmancode FROM salesman WHERE commissionrate1=1) ) AS '2025 DSC SALES',
(select sum(discountedlinetotal * -1)
from
stocktrans
where
YEAR (trandate)='2025' and stocktrans.loccode = locations.loccode) - (SELECT sum(discountedlinetotal * -1) FROM stocktrans WHERE loccode=locations.loccode
AND YEAR (trandate)='2025' AND salesperson IN ( SELECT salesmancode FROM salesman WHERE commissionrate1=1)) as '2025 STORE SALES',
(select sum(discountedlinetotal * -1)
from
stocktrans
where
YEAR (trandate)='2025'and stocktrans.loccode = locations.loccode) as '2025 TOTAL SALES'
from
locations