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

so we utilize Item Groups. When running a saved search to get SO line items, (`mainline=F`), if an SO has both physical inventory and a group SKU, is there a way to get just the physical inventory and group skus, and not the components of of the group?
ex: if SO is
```ITEM           ITEMTYPE
GRPITM1        Group
PRT1           InvtPart
PRT2           InvtPart
End of Group   EndGroup
SKU334         InvtPart
SKU5453        InvtPart```
then what I would like is for the saved search to return
```GRPITM1
SKU334
SKU5453```
I'm working on coding a solution that looks forward for any "EndGroup" line items, then backtracks, but I'd prefer a cleaner solution if a saved search can account for it