Item search to show the preferred vendor and it’s purchase price

There will be multiple line associated with item saved search when the feature Multiple Vendors = T. To limit the Search results only to the Preferred Vendor’s Purchase Price, please follow the steps below:

• Create a saved search for item
• on the criteria tab select the type of item
• Formula (Numeric) > Formula: case when {‌vendor} = {‌othervendor} then 1 else 0 end > equal to 1
• on the results tab enter

-Name
–Description
–Preferred Vendor
–Vendor Price

• save and run