Hello all,

I’ve created two custom transaction body fields on a Sales Order, “Contact Email:” “Contact Phone:”

We have another custom field called “Requested By:”

Using two saved searches, I’m pulling the email and the phone number to those two fields automatically dependent on which contact is chosen from the record in the Requested by field.

This works perfectly and I’m able to print it to an Advanced PDF/HTML form no problem.

However, we have a separate “Work Order” form that we’re actually creating using a script I’ve printed any field I wanted so far, using something like this:

var fields = [‘example’]
var columns = nlapiLookupField(‘salesorder’, stSOID, fields);

var stExample = colums.custbody_example

after this, I’m able to push them with xml without issue. For some reason though, these two fields being populated via Saved Search don’t seem to function the same way.

Is this just something that NetSuite isn’t capable of, or is there a different way to grab/print these fields?

Please let me know if you need anymore information or have any questions. I’d really like to figure out what’s going on here and appreciate any input.

Thank you!