Import Inventory Control Preferred Vendor flag is not working, how do you mass update preferred vendor in the vendor details?

Question

I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even exist to update. 
 
 Can anyone help with this?

MusickInt · Accepted Answer

Even though the Preferred Vendor is on the IC Vendor Details screen and included on the IC Vendor Details export, this is not the correct field to export. 
Export the IC ITEM Master and check the box for the field "SIA Preferred Vendor Type". This is not "Yes/No", but the "VENDORTYPE" from the ICITMV table. 
Take a look at the ICITEM.PREVENDTY ("SIA Preferred Vendor Type") field.

Sage 300

Import Inventory Control Preferred Vendor flag is not working, how do you mass update preferred vendor in the vendor details?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING