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

Adding Fonts for Languages that Use Symbols

For languages that use symbols, such as Arabic, values in columns (POS, Quality, and so on) of Advanced PDF/HTML email attachments can appear empty. NetSuite views the symbols as missing fonts, and therefore leaves the fields blank. To have these symbols or fonts appear, users affected by this must customize standard templates based on language… Continue reading Adding Fonts for Languages that Use Symbols

Add Hyperlink to Advanced PDF/HTML Templates that will Open in a New Window/Tab

When printing records in NetSuite using Advanced PDF/HTML Templates, there are third party libraries used for generating the documents to PDF format. One of the major libraries is Freemarker (Engine template) with BFO (Used to convert XML to PDF).  According to BFO documentation, the “href” tag is supported but with some limitations. Given the example:   <a… Continue reading Add Hyperlink to Advanced PDF/HTML Templates that will Open in a New Window/Tab

Convert Numerical Sum From Integer to Currency in Advanced PDF/HTML Template

Advanced PDF/HTML templates allows simple computations through the use of the Freemarker language. For instances where values needs to be compared or displayed on a certain format, the Freemarker language has a built in function that converts the type casting of variables. Solution Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Advanced PDF/HTML Template: Click Edit Create a variable to… Continue reading Convert Numerical Sum From Integer to Currency in Advanced PDF/HTML Template

Resolve the “String “–” Is Not Permitted Within Comments” When Using Advanced PDF Template

The error “The template cannot be printed due to the following errors:  The string “–” is not permitted within comments” is usually encountered if an Advanced PDF Template is being used as a printing type of the transaction. It is a reserved character and it is being considered as part of the source code on… Continue reading Resolve the “String “–” Is Not Permitted Within Comments” When Using Advanced PDF Template

Remove the Gaps Between the Item Labels When Printing on Advanced PDF/HTML Template

There is a requirement to print Item Labels using Advanced PDF/HTML Templates, the labels are being printed by 3’s with large gaps in between. To minimize the gaps, an adjustment to the Item Label Template should be done. Solution Navigate to Customization > Forms > Advanced PDF/HTML Templates Click Edit beside the preferred Item Label PDF/HTML Template Top right corner: Toggle Source Code Remove the… Continue reading Remove the Gaps Between the Item Labels When Printing on Advanced PDF/HTML Template