If a user sees duplicate AVLs in the BOM import list of parts, it means they were able to get a duplicate manufacturer in the database. A built-in SP (dbo.InvtMpnCleanRefresh) exists to clear it.