Hi

Take the scenario where an inventory item can be purchased from 2 vendors (one preferred) and both vendors and the appropriate vendor code is recorded on the item record.

We have this scenario and we have to issue our purchase orders in a particular file format. In order to do this we use search to export the PO lines into csv and manipulate it from there.

However in the above scenario I cannot work out how to ONLY return the vendor code for the entity on the PO. In the results section I have included "Item: Vendor Code" but the search returns two lines for the item, one for each vendor code on the item record.