How do I add the vendor item name or item code to a late purchase order search?
I have a saved search that shows me late purchase orders. I want to add the vendor code to the results.
On the purchase order line items it is called vendor name. On the item record under vendors it is called code.
How do I get this field on to my late purchase orders search so I can see the part name that the vendor uses?
I tried adding item:vendor code but since I hit the item record, I get a bunch of extra records because this item may have 3 vendors attached so I get 3 rows that I don’t want. I can add item:vendor is preferred to get around that but the problem that introduces is that I have many items with no vendor and no preferred vendor. I’m stuck. It feels like I should be able to grab the purchase order lines sub-record and get the vendor name but I can’t find that. I am attaching an image of the field I want on the purchase order.
Criteria – Item Fields… Select Vendor and specify vendor(s)
Results – Items Fields… Select Vendor Code
Setting the criteria will keep NS from returning Vendor Codes from all vendors.