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

Can we dynamically pull subsidiary information, based on the invoice record?
SA seems to want me to create an if statement for each. <https://netsuite.custhelp.com/app/answers/detail/a_id/85603/kw/subsidiary%20pdf/related/1>

I've done this, but I've found that the native subsidiary fields aren't available, so you usually have to create custom fields to reference them, and then pull those in.

They don't have to store the value though I'm pretty sure.

although looking closer, i think i'm also pulling them into non-stored transaction body fields?

oh no - i am grabbing them right from `${record.subsidiary}`

some do work though, such as `${record.subsidiary.legalname}`

Would it be dynamic based on sub on record? SA makes it seem like its not so

<@UKJC8Q66A> and <@U29JEQVL6>
`{record.subsidiary.field}`  DOES NOT WORK

But you CAN use `${subsidiary.customfield}` and `${subsidiary.nativefield}`

This does work based on the subsidiary of the invoice.. I used it yesterday to get `${subsidiary.mainaddress_text}`.

The trick is that it’s not joined from the Record… it’s a separate join..

The SuiteBuilder Advanced Templates Reference Guide for Invoices calls it out.. but at first I had used ‘record.’ and then realized it’s a join of the subsidiary, and not the record.

Odd, I have a working PDF using record.subsidiary.field...