Edit Report:Sales Value Report E-boutique + Salesman
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Sales Value Report E-boutique + Salesman
-- Sales Value Report for All locations.
-- Sales Value Report for Salesman (3) and E-boutique (4).
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "salesperson",
-- display: "SalesPerson Number",
-- type: "text",
-- }
-- VARIABLE: {
-- name: "placedfrom",
-- display: "Placed From",
-- type: "text",
-- }
-- FILTER: {
-- column: "DEBTORNO",
-- filter: "drilldown",
-- params: {
-- macros: { "debtorno": { column: "DEBTORNO" } },
-- report: "drilldown/customer-invoices.sql"
-- }
-- }
-- ignore
SELECT
loccode,
suppliername AS supplier,
placedfrom,
sum( discountedlinetotal * - 1 ) AS total
FROM
stocktrans
WHERE
trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND supplierno like '{{ supplierno }}%'
AND placedfrom like '{{placedfrom }}%'
GROUP BY
supplierno
order by
total desc