Edit Report:Salesman + E-Boutique Order Totals By Rep By Month
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Salesman + E-Boutique Order Totals By Rep By Month
--Salesman (3) and E-Boutique (4)
-- Salesman E-Boutique Totals by Date Range
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "salesman",
-- display: "Salesman",
-- type: "select",
-- database_options: { table: "salesman", display: "salesmanname", column: "salesmancode", where: " current = 1 and commissionrate2 = 1 " , order:{ column: "salesmanname" , order: "ASC"} },
-- multiple:true,
-- }
-- VARIABLE: {
-- name: "placedfrom",
-- display: "Placed From",
-- type: "text",
-- }
-- ROLLUP: {
-- columns: {
-- "NETSALES": "Total: {{sum}}"
-- }
-- }
SELECT
placedfrom,
salesmanname as SALESMAN,
sum( discountedlinetotal * - 1 ) AS NETSALES
FROM
stocktrans
WHERE
trandate BETWEEN ( '{{ range.start }}' ) AND ( '{{ range.end }}' )
AND placedfrom like '{{ placedfrom }}%'
GROUP BY
salesmanname
ORDER BY
NETSALES desc