Edit Report:Duplicate Barcodes
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Duplicate Barcodes
--
-- ^inventory
-- ignore
SELECT
l.code AS `Barcode`,
COUNT(DISTINCT l.item) AS `# of Linked Items`,
GROUP_CONCAT(
DISTINCT CONCAT(
l.item,
' (',
CASE
WHEN s.discontinued = 1 THEN 'Y'
ELSE 'N'
END,
')'
)
ORDER BY l.item SEPARATOR ', '
) AS `Stock IDs (Discontinued Y/N)`,
GROUP_CONCAT(DISTINCT s.description ORDER BY s.description SEPARATOR ', ') AS `Item Descriptions`
FROM labeltoitem l
JOIN stockmaster s ON s.stockid = l.item
GROUP BY l.code
HAVING COUNT(DISTINCT l.item) > 1
ORDER BY l.code;