Edit Report:Item Master field check
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Item Master field check
--
-- No Drill Downs
-- VARIABLE: {
-- name: "stockid",
-- display: "Item Number",
-- type: "text",
-- }
SELECT *
FROM
stockmaster
where stockmaster.stockid like '{{ stockid }}%'