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 have saved the search which gets  the qty sold of the member item (parent item ) i am litle confused with the syntax how can i get info about the item like cost name etc
```DECODE({item.memberitem},NULL,{item},{item.memberitem})  DECODE({item.memberquantity},NULL,{quantity},{quantity}*{item.memberquantity})```

in which case you wouldnt have access to the member item join

the item join of the transaction search only has a couple of member related columns

the full information is in the member item join of the item, which is one level to far for a transaction search

If I switch this to a sql search I assume it would work