Edit Report:Product Line List with items (PLL2)
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Product Line List with items (PLL2)
-- List of product lines
SELECT
p.line_field as `LineID`,
p.line_description as `Product Line`,
s.stockid as `Item`,
s.description as `Item Description`
FROM productlines p
Left Join stockmaster s ON p.line_field = s.lineid
group by p.line_field, s.stockid
order BY p.line_field, s.stockid