Edit Report:Date range And Text Search
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Date range And Text Search
-- This report will show discounted sales for a salesperson within date range specified.
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "salesperson",
-- display: "SalesPerson Number",
-- type: "text",
-- }
select salesmanname, transno, orderno, debtorno, branchcode, trandate from stocktrans where discountpercent <> 0 and
salesperson like '%{{ salesperson }}%' and trandate between "{{ range.start }}" AND "{{ range.end }}" group by transno