We have a few thousand part plant records that erroneously have a vendor for items which are actually transfer parts. My data OCD is kicking in and I want to remove the vendor from the records - and also because it is complicating some BAQ that are relying on the field.
I cannot seem to clear this field via DMT! I have tried using VendorNum as the column header and using an empty value or a 0, I have tried using VendNumVendorID and setting it to zero (throws error) and an empty value, but it’s not working. I can change the value to another valid VendorID but cannot clear the field.
Is this a DMT bug or am I just not doing this right? Haven’t tried delete mode under the presumption that it’s going to try to delete the whole part plant record.
