Edit Report:Items without Purchdata
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Items without Purchdata
--
-- No Drill Downs
SELECT
s.stockid,
s.description,
s.controlled,
s.categoryid,
s.barcode AS `Barcode`,
s.lineid,
s.mbflag,
s.units,
s.longdescription,
s.actualcost,
s.lastcost,
s.materialcost,
s.labourcost,
s.overheadcost,
s.lowestlevel,
s.discontinued,
s.controlled,
s.eoq,
s.volume,
s.grossweight,
s.lastcostupdate
FROM
stockmaster s
left JOIN purchdata p ON s.stockid = p.stockid
WHERE
p.stockid is NULL and s.discontinued = 0