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

If I'm creating a Sales Order search with mainline = F, is there a way to get the line item description as a column? Is it as simple as a join?

Using the following
```                    search.createColumn({
                        name: 'description',
                        join: 'item',
                        label: 'S Reference'
                    })```
Gives me the name of the Item on that line rather than the description - can someone point out where I'm being a potato?

Nvm fixed - solution for those who may come across a similar issue.

I had to simply create a column for the 'memo' field.

I suspect that only works for you because you have the item description stored in the memo field...

I don't :slightly_smiling_face: - it returns all line items (which is what I wanted) with the description from the search result.

How does using the memo field help you get the description, these are 2 different fields :face_with_monocle:

Yes, they are but alas it works. I haven't read too much into it yet

Oh, Memo is just your column label, not necessarily the field.