This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

i know there is a method to view itemid without matrix parent included, anyone remember how?

sorry should have clarified, I'd like to get rid of parent item name in a saved search

for ex. would not like to see the 02xL or 02xR in the results

oh gosh, I've had a formula for an old client for the exact use case... I wish i've wrote it down somewhere.  I basically try to find the location of the " : " and grabbed everything to the right of the " : ".  Do you have sql expert in house?  otherwise I can reach out to my old client to send over the formula to me bc I'm too lazy to figure it out again lol

found it! we do have one but was able to rely on trusty ol' google

case when instr({itemid},' : ')!=0 then substr({itemid},instr({itemid},' : ')+3) else {itemid} end

appreciate the help and info though! thanks

not sure if thats the exact same formula, but it returned the child item name exactly how i needed it. posted in case someone else needs :slightly_smiling_face:

Yes, that looks like my old friend! lol  Thanks for sharing it here!!!