Edit Report:Quarterly Spiff Report
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Quarterly Spiff Report
-- Select Date Range
-- ^Monthly Reports
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- ROLLUP: {
-- columns: {
-- "Qty": "Total: {{sum}}",
-- "Total Sales": "Total: {{sum}}"
-- }
-- }
SELECT
trandate,
loccode,
salesmanname,
SUPPLIERNAME,
description,
cast( ( price * - 1 ) AS DECIMAL ( 10, 2 ) ) AS 'Price',
sum( qty *- 1 ) AS 'Qty',
cast( sum( discountedlinetotal * - 1 ) AS DECIMAL ( 10, 2 ) ) AS 'Total'
FROM
stocktrans s
inner join debtorsmaster d on s.debtorno = d.debtorno
WHERE
trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND salesperson IN ( SELECT salesmancode FROM salesman WHERE commissionrate1 = 1 )
AND stockid IN ( 'RK99NGLBOJA2025', 'KS99HELOJA2025', 'AH99HBLOJA2025', 'AHSTK1835092', 'AMINMAN2025', 'MNINMNCI2025', 'EVINITMI2024', 'GODTRGODTR0000', 'GODTRGODTR0017', 'BBMKBBYPDQLJJ18', 'BBMKBBYLGPDQ18', 'ROSLEDFACE01', 'EV99TDOJA2025', 'RX71ARI542779', 'AMCDAMCAM021384', 'AMSHAMSAM05021382', 'AMCDBH0095', 'AMSHBH0096', 'AMCDBL0044' ,'AMCDHR002', 'AMSHBL0012', 'AMSHHR002', 'AMCDMB0003', 'AMCDREP0095', 'AMSHREP0083', 'AMCDSG0020', 'AMSHSG0001', 'AMCDSTH0034' 'AMSHSTH0006' )
AND d.typeid NOT IN ('6', '8','10','21')
GROUP BY
salesmanname,
stockid
ORDER BY
stockid ASC