[pbrilino]

I’m trying to retrieve a list of custom records in a scriptable template that will be sent from an invoice. I’ve referenced this SuiteAnswers article below, but I still can’t get it right. I have a custom record where the field custrecord_ntnx_lic_tran_num refers to a transaction list field on the custom record where record is parent is checked. The custom record id is customrecord_ntnx_license

Here’s my template content:

PHP Code:

  ${sublistLicense.custrecord_ntnx_lic_sku},${sublistLicense.custrecord_ntnx_lic_start_date} #list> 

When I preview the template, no content shows up. What am I missing?

Thanks,

Patrick
This is a cached copy. Click here to see the original post.

[chanarbon]

Hi Patrick,

I was able to replicate the scenario that you are experiencing. I am wondering if you have checked out the alternate solution for that query which can be found on SuiteAnswers ID (https://netsuite.custhelp.com/app/an…il/a_id/49137/). According to the mentioned SuiteAnswers, that capability is still an enhancements and tracked with ID 304767. Please tell us if this solution works on your end.

[pbrilino]

Hello,

Thanks for the suggestion. It looks like this is for advanced HTML/PDF forms, not scriptable email templates. Would the same solution apply to scriptable email templates? The SuiteAnswers article I linked to above makes me think this is supported in scriptable email template without any custom SuiteScript. Is this not the case?

[Author]

Posts