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

[SOLVED]
For a Item Fulfillment search, how do I get the item's description? For a sales order, it would be the `Memo` field, but this just gives the header memo and not the line (GL posting?) memo
The internal ID I want is either `description` or `itemdescription` but using them in a `formula(text)` field just gives "ERROR: Field Not Found"

Solved for my use-case. I was trying to use Advanced PDF from saved search results.
I see now that the item fulfillment has access to `record.item[i].description` and `record.item[i].inventorydetail.itemdescription`, although I think the former is what I'm after

Not that this would help you with getting the IF description onto search results (yes, I know you can go through the item join, but often the description is changed/customised on the Sales Order)

applied to transaction join should get you to the sales order

and from there you can get the memo from the matching line

Once again, you're invaluable battk
I suppose the `Created from` transaction join links to the SO 'header', while `Applied to` join links to the SO line item
Brilliant