You can do so by using the field Vendor Price. But you are also going to need to use a formula to remove vendors that are not preferred. Follow the criteria and results below. Let me know if you have any questions.
On the Criteria Tab > Standard subtab : add the following:
–Type > select types of items to include (Inventory, Assembly etc.)
–Formula (Numeric) > Formula: case when {vendor} = {othervendor} then 1 else 0 end (on the dropdown below choose greater than or equal to 1)
On the Results Tab > Columns subtab
–Name
–Description
–Preferred Vendor
–Vendor Price
Torin Salerno
Aminian Business Services
NetSuite Support: support@aminian.com
(949) 407-8416 | (888) 800-5207 x 16