Pull Item Name using Netsuite saved search

Question

I want to extract Item name/number of a child item using saved search. Netsuite account contains item hierarchy Parent-> Child Item. Name of Parent is PARENT and Child item name/ number is CHILD. I have created a saved search for item ,While pulling the Child items name it is appearing as PARENT : CHILD. But I want it to appear as CHILD if Child item's data is being pulled. I also tried using {itemid} but its not working.

score 2 · Answer 1 · answered Dec 29 '17 at 15:21

2

You can use the following formula to give just the child id:

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

answered Dec 29 '17 at 15:21

Krypton

4,394
2
9
13

score 2 · Answer 2 · edited May 15 '18 at 01:15

2

Formula

LTRIM(regexp_substr({itemid},'[^:]*$'))

This returns only the Child Item Name/Number.

edited May 15 '18 at 01:15

Mahib

3,977
5
53
62

answered May 14 '18 at 22:57

Terran

21
1

Pull Item Name using Netsuite saved search

2 Answers2