I would be pretty surprised if you could execute inline javascript in a PDF template

in my invoice pdf i am pulling the customer id like this: <#if record.entity.id=='13429'> is it possible to retrieve the value of another field from the customer record?

In my experience, linking back via two joins seems to sometimes work, and sometimes doesn’t, depending on the field. Have you just gone ahead and tried it?

i haven't. i am not sure how to go back to a related record

what field are you looking to get?

a custom field...

record.entity.myfield - that wouldn't work would it...

i can always source the value from the customer record to the invoice - but was wondering if i could access the field directly

@mg2017 it should work.

Does anyone have an efficient way of getting Primary Contact of a transaction (estimate, sales order) name & details (e.g. email, phone number) on the print form? I first tried using the internal id of the Contact (Primary) field that is provided by the Records Browser, contactprimary so {record.contactprimary.entityid} but that did not work so I asked NetSuite Support how to do this and they said it is not available and gave me an enhancement request no 297850 Advanced PDF/HTML Templates > Print the Primary Contact Name and Phone in the Sales Orders. I still need a way to do this....

@mg2017 I’d try it, and see if it works - if not, just source it onto the transaction

@cwiersum The issue is that both the role and the primary contact indicator isn’t stored on the contact, it’s stored in the join between the entity and the contact. I’ve done this previously by sourcing the contact into a custom field on the transaction, and including it from there.

@igorp @markderrick that actually worked...thank you chaps

Anybody have an ide why I'm unable to show rate on packing slip? anybody having problem with that?

Yup, rate doesn’t (currently) seem to be available to pull through. Why do you need it? Logically, rate isn’t that useful unless you also take any discount into account, which makes it even more complex to deal with.

Yep I'm doing a packing slip with discount and another generic... doing with script now since I was unable to get it from the standard print....

Does anyone know how to create a custom column field sourced from a kit/package item? I cannot see kit/package item in the "source list" to be able to select the costestimate field I need for RMA Commercial Invoices - (I found that kit/package items were classed as assembly in the source list)

Anyone have a handy example of sort by within a Advanced PDF template?

@alien4u: i’m using

><#list record.item?sort_by("description")?sort_by("custcol_item_XXX") as item>

to sort by my custom item group field and then alphabetically (courtesy of @michoel)

I'm printing a barcode on an Advanced PDF, within a table; the barcode is overlapping other columns - how can I set it to honor/fit to the column?

@NS.TX I don't know a way to make it fit the column you can try make it smaller...

Or you will probably need a function that change the barcode size base on the value length

@alien4u I couldn't figure out how to resize the barcode, but I was able to change the tablet-format from Fixed, to Auto. This appears to work.

@NS.TX Good, I think I have an example of a barcode size change wait...

@alien4u @NS.TX you can try

From memory I think only setting it on the containing div worked, but looking at my templates I am setting it for both

You can also try changing the

bar-width

attribute, the default is 1 but you can lower it till 0.6