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.

How do I add the vendor item name or item code to a late purchase order search?

Rookie Asked on October 6, 2020 in Saved Searches.
Add Comment
1 Answer(s)

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.

 

Rookie Answered on July 15, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor