Edit Report:Billed on BO Account WPG Store
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Billed on BO Account WPG Store
-- PLACE HOLDER REPORT DESCRIPTION
-- PLACE HOLDER REPORT FILTERS AND DRILL DOWN
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- ROLLUP: {
-- columns: {
-- "totalsales": "Total: {{sum}}"
-- }
-- }
--
--
select
loccode,
trandate,
type,
debtorno,
branchcode,
brname,
orderno AS 'Pick Slip #',
transno AS 'Invoice #',
sum( discountedlinetotal * - 1 ) AS totalsales
FROM
stocktrans
WHERE
trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND loccode ='05'
-- and debtorno = branchcode
and type = '10'
AND debtorno in ('2189','9817','3621','2077','0254','3566','9444','0775','0054','0170','1664','0963','2580','8754','2000','10253','0944','8755','10254')
GROUP BY
debtorno, branchcode, transno