Edit Report:Negative Inventory
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Negative Inventory
-- Items with qty < 0
-- ^inventory
--
select loccode AS `Warehouse`, locstock.stockid AS `Part Number`,
sum( quantity) AS `Quantity On Hand`
FROM
locstock INNER JOIN stockmaster ON stockmaster.stockid = locstock.stockid
WHERE
categoryid = 'T'
and bin <> 'ZPOHOLD'
and quantity < 0