How do I Remove Duplicate AVL's?
If a user sees duplicate AVL's in the BOM import list of parts then it means somehow they were able to get a duplicate manufacturer in the database. We have a built in SP (dbo.InvtMpnCleanRefresh)  to clear that.
It is attached to this article as well.