has anyone come up with a way to associate a custo...
# administration
a
has anyone come up with a way to associate a custom segment value (like "brand") with a custom logo, or other custom fields? mainly wanting to output different stuff on a pdf depending on which custom segment is selected on a transaction.
e
Yes, we built a record type that we called “Invoice PDF Template”. Each department in the company can have their own template which allows for a different logo, email address, phone number, bank instructions, remittance, etc. Every invoice is tied to an Invoice Template. In Advanced PDF Template, we just reference the related fields from this Custom Record.
a
Thanks, this was basically my plan. How do you assign the custom record to each invoice?
e
Transaction Body field that references the “Invoice PDF Template” record. We use the Sourcing to set the template to the departments Invoice Template default so users don’t have to set it every time.
a
Got it- so you have a custom field on your Department segment that lets you connect each dept to its corresponding Invoice PDF Template right? That's what I can't get w/ custom segments unfortunately
figuring i'll need to do a script of some sort to set the appropriate custom record value based on which segment is selected on the customer/transaction
e
Are you trying to tie to a custom segment set as a Transaction Body field or a Transaction Line field? In other words, will you always just have one of these custom segments per transaction?
a
yeah it's one per transaction, not line-specific
i just realized there is a custom record that generates for each custom segment and that's where you add additional fields - never mind!
e
Oh yeah, I always forget about that. Once you add that just make sure you can get to that data through a saved search invoice record. If you can, you should be good to to update the Advanced PDF template to insert the values as needed. Example would be something like “record.custbody_rs_arphone”.
a
Yeah same! I just did a POC on a quote PDF template and it works nicely, just did record.cseg_brand.custrecord_logo
Was actually shocked how well it worked, I'm not used to that with Netsuite.
👍 1
e
I know what you mean.
stanley 1