Does anyone know if it's possible to access a rela...
# suitescriptm
mrob
04/05/2023, 8:51 PMDoes anyone know if it's possible to access a related record's sublist values in an advanced PDF template?
mrob
04/05/2023, 8:51 PMIt's a custom field with type Record, which is referencing the vendor bill on an invoice. I want to access the vendor bill's item data but it doesn't seem to be accessible
j
jen
04/05/2023, 8:52 PMin my experience, it’s not accessible
☝️ 1
jen
04/05/2023, 8:52 PMwhat I ended up doing is dumping the text I needed into a JSON field on the parent record
d
David B
04/05/2023, 8:53 PMThat's one way to do it, and would mean you don't have to script the PDF creation.
The other way you could do it is to script it with
N/renderDavid B
04/05/2023, 8:54 PMbut if you're only needing one or two fields from the vendor bill, use a custom field sourcing the data you want onto the invoice (or even for lots more fields, use Jen's solution of having some sourced JSON string on the invoice)
m
mrob
04/05/2023, 8:56 PMfor scripting it what script type would that be? Is there an advanced pdf template script? Or would it be a suitelet with n/render?
d
David B
04/05/2023, 9:01 PMhonestly Jen's solution seems easier. It would be a non-stored field/fields, so not bloating your DB and would be simple to setup
m
mrob
04/05/2023, 9:02 PMWould it require a user event script to populate the JSON field? Or is this something you are suggesting I could grab via the advanced PDF that would cause the vendor bill to dynamically generate the data (since it's non-stored)?
j
jen
04/05/2023, 9:02 PMummm
jen
04/05/2023, 9:02 PMnot sure if non stored would work
🫢 1
jen
04/05/2023, 9:03 PMwe had a problem where when the PDF was generated as a result of sending an email and ticking
Include Transactionjen
04/05/2023, 9:03 PMso we actually regenerate the JSON for the text field on each save of the parent record.
jen
04/05/2023, 9:03 PMthe OTHER way you could do it is that you can actually
<#include>m
mrob
04/05/2023, 9:04 PMWould it look like:
vendor bill new field:
itemJsonrecord.customVendorBill.itemJSONj
jen
04/05/2023, 9:04 PMyou’d need the JSON on the main record
m
mrob
04/05/2023, 9:04 PMUE meaning user event or user event script? Sorry I'm unclear what roll that plays
j
jen
04/05/2023, 9:04 PMUser Event Script
jen
04/05/2023, 9:05 PMI thought “oh I’ll just fire a UE script on beforeLoad in Print context, and generate the text into my non-stored field” but it doesn’t fire when attaching PDF in email
jen
04/05/2023, 9:05 PMif that’s never something you do, though, that method could work for you
jen
04/05/2023, 9:05 PMmight have been a workflow action and not a UserEvent, I can’t honestly remember now as it was several years ago that I last tried
m
mrob
04/05/2023, 9:06 PMHmm... a second thought was also if I could create a button on the invoice record that essentially pulls the print of a vendor bill (so I could access all the sublist values on the bill and then just pull the relevant invoice fields via record.referenceToInvoice.tranid etc)
mrob
04/05/2023, 9:35 PMBut sorry another clarifying question jen... with your solution it would be a stored field on the vendor bill record that's populated via a user event script? Could it just be a sourced (and stored) field instead of needing the UE to populate it?
I don't need to worry about the vendor bill unsyncing from the invoice, I have a UE script that updates the invoice everytime the vendor bill is modified (I guess I could also just populate the json field from that then too huh...)
j
jen
04/05/2023, 9:53 PMYeah if you can source it you could do that. Our use case was a bit more complex and had to do a bunch of a logic to get JSON object that had a bunch of other info in it that the PDF used.
m
mrob
04/05/2023, 9:56 PMOkay thanks for all the help Jen and David, will work on this a bit
6 Views