In NetSuite, item pricing, group pricing, and price levels are key concepts related to managing how products or services are priced for customers. These concepts allow businesses to define and apply customized pricing structures for different customer groups, individual customers, or specific items. Here’s an explanation of each: Item Pricing: Item pricing in NetSuite refers… Continue reading Item pricing, Group pricing and Price level of customer in NetSuite
Author: Keerthy Davis
Filter array of objects by array of ids
Convert array into key value pair
Resolve Error: “An Unexpected Error Has Occurred.” on Duplicate Merge Page
User is unable to merge two customer records. Whenever the user tries to do this, the following error message appears: “An unexpected error has occurred.” The unexpected error may be caused by various reasons. As an initial fix, user can try the following as the alternate solution. Solution Login as Administrator Navigate to Lists > Relationships > Customers Duplicate Customer Record: Click Edit Actions… Continue reading Resolve Error: “An Unexpected Error Has Occurred.” on Duplicate Merge Page
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