Custom View of Items by Preferred Vendor

Custom View of Items by Preferred Vendor

We have added the preferred vendor to our items with the aim of making a list of items according to preferred vendor as a report or custom view so that we can quickly analyse stock in preparation for a purchase order.

However there is no such list available. Preferred vendor is not an option as an available column in custom views. It is not a column in the Inventory report either. Please can someone make a suggestion?

The Vendor - Reorder Items is not working for us on the EU server. However that is still not ideal as we also order items which will be going out of stock or need ordering in advance.