Author: Keerthy Davis

Duplicate Resolution Returning with Unexpected Error

User is merging duplicate customer records and after tagging Master and Duplicate, the Duplicate Resolution Status returns with “An unexpected Error occurred”. This is happening because the Customer record being tagged as Duplicate has more transaction records than the record being tagged as Master. Solution Interchanging the tagging will allow the merging to push through.… Continue reading Duplicate Resolution Returning with Unexpected Error

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

Exporting to Excel

You can export reports, searches and lists into various formats. Exporting provides you with additional flexibility in reviewing and analyzing your business’s data. Each export format has its own advantages and limitations as detailed below: Supported Versions – Only XLS files are supported. XLSX files are not supported. Expand/collapse – Settings are not maintained. All rows included… Continue reading Exporting to Excel

Set Field Value Action Guidelines

Use the following guidelines when working with the Set Field Value action. You cannot use a Before Record Load trigger to set field values for existing records. This limitation applies to the Set Field Value and Go To Record actions. Use a custom action to update fields on an existing record. The value you specify… Continue reading Set Field Value Action Guidelines

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