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 a Sales Order PDF. Is there a way to grab data off of the item record that doesn't exists on an Sales Order?

We need some logic/formula based off of a few fields on an item, so I can't just source it unfortunately

You can create those fields without store value checked as transactions custom columns sourcing from the item and then use those in your advanced pdf template, Im afraid that is the only way.

Was hoping for a way without creating 2 new fields, but like you said, it's the only one I could think of was to create those 2 fields that way

The fields do not need to be showing on the form at least, I believe, so they don't take up real estate on your sublist. Just need to exist with the sourcing relationship in order for the data model to be able to access them.

Yeah, just tested that as well and was happy when I saw I could hide them haha

yeah i was stoked when i learned that - was like hey for once things worked out ok!

Have you tried this? use the item join? 

${item.item.custitem_field} 

<@UEWBBMSTX> it should but doesn't due to some weird bug, each line will show the value of the first line item's custom field instance