Edit Report:Top 100 Online Items
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Top 100 Online Items
select
stkcode as STOCKID,
sa.description as DESCRIPTION,
sum(quantity) as ORDERED
from
salesorderdetails
join salesorders on salesorders.orderno = salesorderdetails.orderno
join stockmaster sa on salesorderdetails.stkcode = sa.stockid
where
placedfrom = 4
group by
stkcode
order by
sum(quantity) desc
limit
100;