Advanced PDF Templates – Page 3

Extracting ‘Bill To’ Address Line by Line from Invoice Records for Advanced PDF Templates.

The provided code can retrieve the address line by line from the billing address in the invoice record. To retrieve the billing address as a whole, we can utilize the additional code below.

PDF template to split a value with a divider

Requirement Client would like to make everything prior to the “|” divider 1 font larger and bolder in the item name Attached the current template Solution ${record.name[0..*43]?split(‘|’)[0]} | ${record.name[0..*43]?split(‘|’)[1]}

How to show Checkbox in Advanced PDF?

There is no standard method for showing the checkbox in PDF. Showing a checkbox image in the print or using the following code snippet based on the check box field value. <#if record.checkbox == true> [ ✓ ] <!– Checkmark symbol –> <#else> [ ✗ ] <!– Cross symbol –> </#if>

Freemarker Formula for Advances PDF Template to convert date to user-preferred format.

The date provided to the Advanced PDF template should be a date time Object. ${receiptObj.trandate?datetime.iso?string(“dd.MM.yyyy”)}

Chinese font style in Advanced PDF Template

Get the Font File: Obtain a copy of the actual .ttf file(s) for the font(s) you wish to use. Store the Font File: Upload all versions of the .ttf files (Regular, Bold, Italic, Bold-Italic, etc.) to a designated location in the NetSuite File Cabinet. Be sure the .ttf font file(s) is/are accessible from NetSuite and the… Continue reading Chinese font style in Advanced PDF Template

Function in XML

Creates a method variable. This directive works in the same way as the macro directive, except that return the directive must have a parameter that specifies the return value of the method, and that attempts to write to the output will be ignored. If the </#function> is reached (i.e. there was no return returnValue), then the return value of the method is an… Continue reading Function in XML

Break in P tag based on length in PDF Template

Dynamically Add External PDF File within Printed PDF File

Create Custom Field Label:Enter Label Type:Select Free-form Text ID: Enter _link_pdf Click Applies To Enter Checkmark for relevant Transaction/Record Click Save Add the PDF File to the File Cabinet Get the External Link on the File record Insert the link on the Custom field Navigate to Customization > Forms > Advanced PDF/HTML Templates Click Edit beside the preferred Advanced PDF/HTML Template Insert a <pdfset> tag before the first <pdf> tag After the </pdf> tag add <pdf src = “${‌record.custbody_link_pdf}” /> </pdfset>

Convert Amount to Number in advanced PDF template

An error is displayed as “Can’t convert this string to number” when attempting to generate the PDF. This error arises because the number retrieved from the record might be interpreted as a string, which prevents the successful generation of the print. To address this issue, please refer to the sample code provided below for a… Continue reading Convert Amount to Number in advanced PDF template

Print Item Name/Number Instead of Display Name on Price Lists

Create a separate field that contains the value of the Item Name/Number and reference that field instead. Solution Create Custom Item Field Navigate to Customization > Lists, Records, & Fields > Item Fields > New Label: Enter LabelExample: Printed Name ID: Enter _printed_name Type: Select Free-Form Text Store Value: Enter Checkmark Click Applies To Necessary Item Type(s): Enter Checkmark Print on Price List: Enter Checkmark Click Save Perform Mass Update Navigate to Lists > Mass Update > Mass Updates Click General Updates Items: Click the… Continue reading Print Item Name/Number Instead of Display Name on Price Lists