Scenario: Performing a CSV Import to update Item Record > Result unsuccessful > CSV response shows Error: Unexpected error has occurred. Solution: Checked if Feature Allow Purchase of Assembly Items is enabled: Navigate through Setup > Accounting > Accounting Preferences > Order Management tab > Allow Purchase of Assembly Items If Allow Purchase of Assembly… Continue reading How to resolve the Unexpected Error occurred when doing a Item record update using CSV Import
Author: Arnold Xavi
Resolve Error: “The Merge of Entity Was Blocked for the Following Reason: An Unexpected Error Has Occurred.” on Merge Vendor Page
Scenario: User is getting an error “The merge of entity was blocked for the following reason: An unexpected error has occurred.” on Merge Vendor Page when trying to merge vendor records. The error is caused when a Vendor record’s ‘Predicted Confidence Level’ field is not accurate. Solution: Review Vendor Performance Calculations Navigate to Lists > Supply Chain > Review Vendor… Continue reading Resolve Error: “The Merge of Entity Was Blocked for the Following Reason: An Unexpected Error Has Occurred.” on Merge Vendor Page
Comparison of Suite Script 2.1 and Suite Script 2.0
SuiteScript 2.1 uses a different runtime engine than SuiteScript 2.0, also supports ECMAScript language features that are not supported in SuiteScript 2.0. This causes some capabilities in SuiteScript 2.0 scripts to function differently when the script is executed using SuiteScript 2.1. The following sections describe important differences between SuiteScript 2.0 and SuiteScript 2.1: Reserved Words… Continue reading Comparison of Suite Script 2.1 and Suite Script 2.0
Limit Field to a Number of Characters When Printing Using Advanced PDF/HTML Template
Scenario: On printing values on a table, there are scenarios where the texts are lengthy and distorts the layout of the tables on the Advanced PDF template, and this is especially true for the item descriptions. This article provides steps on limiting the Item Description length to print only up to 30 characters when it… Continue reading Limit Field to a Number of Characters When Printing Using Advanced PDF/HTML Template
Resolve Error: “Unexpected Error” Caused by a Workflow Setting the Employee Field on Before Record Load Trigger
Scenario: Upon saving Expense Reports, the system throws an unexpected error. An existing Workflow with a server-side Set Field Value Action that triggers on Before Record Load is to set the Employee field upon creation of Expense Reports then the Currency field is auto-populated via Sourcing based on the employee. Server-side triggers does not respect… Continue reading Resolve Error: “Unexpected Error” Caused by a Workflow Setting the Employee Field on Before Record Load Trigger
Unexpected Error Is Returned When Connecting to SFTP Server Using SuiteScript 2.0
Scenario: When connecting to an SFTP server using SuiteScript 2.0, users may encounter an unexpected error. One of the reasons is because the directory property on the createConnection method does not exist on the server. Solution: To ensure that the problem is not the directory, remove the directory property on the connection or give it… Continue reading Unexpected Error Is Returned When Connecting to SFTP Server Using SuiteScript 2.0
MUTUALLY_EXCLUSIVE_ARGUMENTS Error During SFTP Connection
Scenario: NetSuite currently does not support 2FA connections over SFTP connections. There is currently a defect on this topic tracked as Defect 569291 for allowing the use of two types of authentication at the same time (2FA) . When there is a use case to send 2 types of authentication at the same time, the below code throws error MUTUALLY_EXCLUSIVE_ARGUMENTS. Since 2019.2… Continue reading MUTUALLY_EXCLUSIVE_ARGUMENTS Error During SFTP Connection
Customizing Delete Behaviour for Records Referenced by Custom Fields
List/record and multiple select type custom fields provide a list for users to select values. The list of values is populated by records of the list/record type set in the custom field definition. Because list/record and multiple select custom fields are dependent on these referenced records, deletion of these records can be problematic. For example,… Continue reading Customizing Delete Behaviour for Records Referenced by Custom Fields
How to overcome the Error “Overage Is Not Allowed” Occurred when Billing the Sales Order
Scenario: When the user is trying to Edit and Save a Sales Order record with multiple line items and creating an Item Fulfillment with only one of the line items this error message is encountered. The error is encountered when the following are met: Setup > Accounting > Accounting Preferences > Allow Overage in Item Fulfilment = F Create a Sales… Continue reading How to overcome the Error “Overage Is Not Allowed” Occurred when Billing the Sales Order
Tips to Optimize NetSuite Preferences
NetSuite includes many preferences that users can set to configure the system for optimum performance. Users can review available preference options at Home > Set Preferences. Users can adjust the following preferences to speed up page loading: On the Appearance subtab, in the Centers & Dashboards section, set the Landing Page preference to open NetSuite to a page… Continue reading Tips to Optimize NetSuite Preferences