Edit Report:AMIKA SALES BY DATE
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- AMIKA SALES BY DATE
-- Amika Sales
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
SELECT
fromstkloc,
locations.locationname,
sum( discountedlinetotal * - 1 ) AS totalsales
FROM
stocktrans
INNER JOIN locations ON locations.loccode = fromstkloc
WHERE
trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND supplierno = 'AM'
GROUP BY
-- salesmanname,
fromstkloc
ORDER BY
fromstkloc AS