Edit Report:Boutiques Daily Sales Replenishment Report -testing
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Boutiques Daily Sales Replenishment Report -testing
--
--
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "loccode",
-- display: "location",
-- type: "text",
-- }
-- ROLLUP: {
-- columns: {
-- "qty": "Total: {{ sum }}"
-- }
-- }
SELECT
s.stockid,
description,
sum( qty) as qty,
s.loccode as 'location',
suppliername as 'supplier',
bin
FROM
stocktrans s
LEFT JOIN locstock l on l.stockid = s.stockid and l.loccode = '00'
WHERE
trandate BETWEEN "{{ range.start }}" AND "{{ range.end }}"
and s.loccode IN ('01','02','03','04','05','06','07','08','09', '10', '11')
AND s.loccode like '{{ loccode }}%'
GROUP BY
s.stockid, s.loccode
ORDER BY
bin asc