Hello - anyone knows a way to display memberitem - display name on a saved search? This person was trying to do the same but no luck - https://netsuiteprofessionals.com/answer/re-saved-search-quantity-sold-formula/

In your results: Member Item Fields… > Display Name

Is that on a item search? @Nick - We are pulling transactional data with items for our warehouse

Could you reverse engineer your transaction search using an item search > Transaction Fields…?

That's what I'm thinking

The closest I've come is just returning the Member Item "name" (item sku/part number) using a Formula (Text) field for {item.memberitem} . But what you really want is {item.memberitem.displayname} which syntactically doesn't exist. It would take two "joins" to accomplish, and Saved Searches only handle one join on their own. Someone may have a cheat to get that second join... perhaps using an INSTR or DECODE function.... I tried quickly and couldn't get it to work. I think Nick is onto something re-writing the search from an Item Search and going the other way 'round.