Edit Report:Sku Sales
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Sku Sales
--
--
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "supplierno",
-- display: "Supplier Code",
-- type: "text",
-- }
--
select
stocktrans.stockid,
purchdata.suppliers_partno as 'Vendor #',
description,
sum(CASE WHEN loccode = '00' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Warehouse',
sum(CASE WHEN loccode = '00' THEN (qty * -1) ELSE 0 END) as 'Warehouse_QTY',
sum(CASE WHEN loccode = '01' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Calgary South',
sum(CASE WHEN loccode = '01' THEN (qty * -1) ELSE 0 END) as 'Calgary South_QTY',
sum(CASE WHEN loccode = '02' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Edmonton',
sum(CASE WHEN loccode = '02' THEN (qty * -1) ELSE 0 END) as 'Edmonton_QTY',
sum(CASE WHEN loccode = '03' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Regina',
sum(CASE WHEN loccode = '03' THEN (qty * -1) ELSE 0 END) as 'Regina_QTY' ,
sum(CASE WHEN loccode = '04' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Saskatoon',
sum(CASE WHEN loccode = '04' THEN (qty * -1) ELSE 0 END) as 'Saskatoon_QTY' ,
sum(CASE WHEN loccode = '05' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Winnipeg',
sum(CASE WHEN loccode = '05' THEN (qty * -1) ELSE 0 END) as 'Winnipeg_QTY' ,
sum(CASE WHEN loccode = '06' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'The Boutique',
sum(CASE WHEN loccode = '06' THEN (qty * -1) ELSE 0 END) as 'The Boutique_QTY' ,
sum(CASE WHEN loccode = '07' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Calgary NE',
sum(CASE WHEN loccode = '07' THEN (qty * -1) ELSE 0 END) as 'Calgary NE_QTY' ,
sum(CASE WHEN loccode = '08' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'Red Deer',
sum(CASE WHEN loccode = '08' THEN (qty * -1) ELSE 0 END) as 'Red Deer_QTY' ,
sum(CASE WHEN loccode != '00' THEN (discountedlinetotal * -1 ) ELSE 0 END) as 'NET STORE',
sum(CASE WHEN loccode != '00' THEN (qty * -1) ELSE 0 END) as 'NET STORE QTY' ,
sum(discountedlinetotal * -1 ) as 'NET',
sum(qty * -1) as 'NET QTY'
from stocktrans
join purchdata on purchdata.stockid = stocktrans.stockid
where
1
and trandate between "{{ range.start }}" AND "{{ range.end }}"
AND purchdata.supplierno like '{{ supplierno }}%'
group by stocktrans.stockid