Edit Report:Needs Bin Location
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Needs Bin Location
-- Items without a valid Bin
-- ^inventory
-- FILTER: {
-- filter: "class",
-- column: "Warehouse",
-- params: {
-- class: "center"
-- }
--}
-- FILTER: {
-- filter: "class",
-- column: "Quantity On Hand",
-- params: {
-- class: "center"
-- }
--}
--
select
locstock.stockid AS `Part Number`,
stockmaster.description as `Description`,
loccode AS `Warehouse`,
bin AS `Bin`,
quantity AS `Quantity On Hand`
FROM
locstock INNER JOIN stockmaster ON stockmaster.stockid = locstock.stockid
WHERE
categoryid = 'T'
and bin in ( 'DWI-12', 'NEED','DWI-11')
and quantity > 0