Edit Report:Hedkandi Quarterly Rebates Report All Purchases
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Hedkandi Quarterly Rebates Report All Purchases
-- Select date range. Enter RK in 'supplierno' field to pull Redken Sales. Leave 'supplierno' field blank for all sales
-- ^Monthly Reports
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "brname",
-- display: "Branch Name",
-- type: "text",
-- }
-- VARIABLE: {
-- name: "supplierno",
-- display: "Supplier Code",
-- type: "text",
-- }
-- ROLLUP: {
-- columns: {
-- "Total Sales": "Total: {{sum}}"
-- }
-- }
SELECT
MONTHNAME (trandate) AS 'Month',
YEAR (trandate) as 'Year',
debtorno,
branchcode,
brname,
suppliername,
sum(-1 * discountedlinetotal) as 'Total Sales'
FROM
stocktrans
WHERE
debtorno IN (
'2871',
'2872',
'2805',
'1682',
'0890',
'2776',
'5135',
'5138',
'3227',
'1626',
'1623',
'0059',
'1156',
'3229',
'3228',
'0329',
'0328',
'1033',
'3546',
'3226',
'3242'
)
AND trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND brname like '{{ brname }}%'
group by
debtorno,
branchcode,
suppliername,
YEAR (trandate),
MONTH (trandate)
order by
trandate ASC,
brname ASC