Edit Report:Item Master List
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Item Master List
--
-- No Drill Downs
-- VARIABLE: {
-- name: "stockid",
-- display: "Item Number",
-- type: "text",
-- }
SELECT
stockmaster.stockid,
stockmaster.description,
stockmaster.categoryid,
stockcategory.categorydescription AS Category,
stockmaster.lineid,
stockmaster.mbflag,
stockmaster.barcode,
stockmaster.units,
stockmaster.taxcatid,
t.taxcatname
FROM
stockmaster left JOIN stockcategory ON stockmaster.categoryid = stockcategory.categoryid
left JOIN product_to_manufacturer ON stockmaster.stockid = product_to_manufacturer.stockid
left JOIN manufacturer ON product_to_manufacturer.manufacturer_id = manufacturer.manufacturer_id
left JOIN taxcategories t ON stockmaster.taxcatid = t.taxcatid
where stockmaster.stockid like '{{ stockid }}%'