Custom Transaction Body Field Sourced from Saved Search – Printed w/ SuitScript 1.0
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.
So far I haven’t been able to pull fields sourced via saved search to display on a PDF.
Previously I have replaced the saved search fields with a script that will run the saved search and populates the value into a non-sourced custom field.
That way the field is treated the same way all of the other form fields are and should be able to be used within your PDF, although this is probably not the answer you were hoping for.
If the Requested by Field is a contact field then you should set the field up the other fields to source the contact email and phone number from the Requested by Field. If you set the fields up this way then you shouldn’t have any issue sourcing them into anything. See image for details.