Edit Report:Pony Sales Report
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Pony Sales Report
-- Pony Sales for Jarret
-- ^Monthly Reports
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- ROLLUP: {
-- columns: {
-- "Qty": "Total: {{sum}}",
-- "Total Sales": "Total: {{sum}}"
-- }
-- }
SELECT
loccode,
trandate,
debtorno,
branchcode,
brname,
salesmanname,
transno,
suppliername,
lineid,
stockid,
description,
sum( qty * - 1 ) AS 'Qty',
CAST(
AVG( price ) AS DECIMAL ( 10, 2 )) AS avgprice,
sum( discountedlinetotal * - 1 ) AS 'Total Sales'
FROM
stocktrans
WHERE
supplierno = 'PH'
AND trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND loccode IN ( '00', '01', '02', '03', '04', '05', '06','07','08' )
AND lineid = 'WFT'
GROUP BY
brname, stockid
ORDER BY
trandate asc,
loccode asc