Removing a Vendor from Inventory Items in Microsoft Dynamics GP

When a vendor is no longer valid, for example if they have gone out of business, you might wish to remove the item vendor records. This makes it more difficult for a user to enter a purchase order from a defunct vendor. If
the vendor is related to hundreds of inventory records, this could take some time using the Dynamics GP screens.  As an alternative, use the following script in Query Analyzer. (BE SURE to make a backup of your database before performing any SQL command against a database!)

DELETE FROM IV00103 WHERE VENDORID = ‘DELETED_VENDOR’

To remove the vendor from the Default Vendor field in the Item Master record, use the following script in Query Analyzer:

UPDATE IV00102 SET PRIMVNDR=’’ WHERE PRIMVNDR=’DELETED_VENDOR’

Of course, replace DELETED_VENDOR with the vendor ID of the vendor that is being deleted.