Edit Report:Product Line List (PLL)
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Product Line List (PLL)
-- List of product lines
SELECT
line_field as `LineID`,
line_description as `Description`,
mfgcode,
mfgbrand,
preferredsupp
FROM productlines
order BY
line_field