Custom Transaction Body Field Sourced from Saved Search – Printed w/ SuitScript 1.0

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!

Rookie Asked on November 11, 2022 in Other.
Add Comment
3 Answer(s)

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.

Beginner Answered on November 14, 2022.
Add Comment

Not exactly what I was looking for, but a good option if all else fails.

Thank you!

Rookie Answered on November 14, 2022.
Add Comment

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.

RE: Custom Transaction Body Field Sourced from Saved Search - Printed w/ SuitScript 1.0


Beginner Answered on November 22, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor