Tag: parent

Why some of the Parent field modifications are not tracked in the System note?

NetSuite’s system notes do not include updates to the “parent” field for certain record types. The “parent” field is typically a reference to a parent record in a hierarchical relationship, such as the parent of a sub-record. The reason why updates to the “parent” field are not available in system notes is a design choice… Continue reading Why some of the Parent field modifications are not tracked in the System note?

Search to get item child name

Use the below formula to return only the item’s child name in a saved search. Formula(Text): ltrim(regexp_substr({name},'[^:]*$’)) For example without the formula a parent: child item will display as: Parent Item Name: Child Item Name Using the formula only the Child Item Name will display. search export:var itemSearchObj = search.create({type: “item”,filters:[[“name”,”is”,”SKTHA96976″]],columns:[search.createColumn({name: “itemid”,sort: search.Sort.ASC,label: “Name”}),search.createColumn({name: “formulatext”,formula: ” ltrim(regexp_substr({name},'[^:]*$’))”,label: “Formula (Text)”})]});