how to add child record in advanced pdf form in netsuite of a custom record

AI generated answer (using internal Slack threads):

To add a child record in an Advanced PDF form in NetSuite of a custom record, you can use the following steps: 1. Create a custom record that will act as the child record. This record should contain all the fields that you want to display in the Advanced PDF form. 2. Create a relationship between the parent record (in your case, the Sales Order) and the child record. This can be done by creating a custom field in the parent record of type 'List/Record' and selecting the child record as the record type. 3. In the Advanced PDF/HTML Template, you can access the child record fields using the following syntax:

record.custbody_customfield.fieldname

. Replace

custbody_customfield

with the script id of the custom field you created in step 2, and

fieldname

with the script id of the field in the child record. 4. If you want to display a list of child records, you can use the

#list

directive in the Advanced PDF/HTML Template. Here is an example:

html
<#list record.custbody_customfield as child>
    ${child.fieldname}
</#list>

Please note that this method only works if the relationship between the parent and child records is one-to-many. If the relationship is many-to-many, you will need to use a different method, such as creating a custom sublist on the parent record that references the child records. Also, note that the Advanced PDF/HTML Templates only have access to a limited set of data from the record. If you need to display data that is not natively available, you may need to use SuiteScript to load the additional data and pass it to the template. Remember, if you want to avoid using SuiteScript, you can create a parent-child relationship between your records. This will allow you to create a sublist on the parent record that references the child records. You can then use this sublist in your Advanced PDF/HTML Template. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******