Item Saved Search to Display Preferred Vendor for multiple Subsidiaries (OneWorld)

By design, the Preferred Vendor field on the Item Record can only take in one value at any given point it time. For OneWorld accounts, users can assign multiple Preferred Vendor per Subsidiary. However, when a user add this on the Saved Search it will only show the most recent Preferred Vendor added based from the behaviour mentioned above.

As an alternate solution, if a user can use Vendor is Preferred filter instead:

1. Go to Transactions>Management>Saved Searches>New
2. Select Item
3. On the Criteria tab add Vendor is Preferred is True
4. On the Results tab add Name, Vendor, and Vendor Fields>Primary Subsidiary
5. Hit Preview or Save and Run

The Saved Search will display the name of the Item, the Preferred Vendor and the corresponding Subsidiary.