In the context of a Saved Search formula field of type “Text,” you can concatenate two fields, such as the customer’s name and internal ID, using the || concatenation operator. Here’s an example formula:{entityid} || ‘ – ‘ || {internalid}This formula concatenates these two fields together with a hyphen and space (‘ – ‘) as… Continue reading Saved search formula to concatenate two fields.
Author: Swathi Krishna K S
Unexpected SuiteScript error” while uploading a file to an SFTP server in NetSuite
Encountering an Unexpected SuiteScript Error When Uploading a File to SFTP using the script: The error was caused by the character “:”(Colon (:)) in the File Name. This can be resolved by removing colon from the file name as:
Transferring Files Between Two SFTP Folders
To move a file to another folder on the SFTP server, you can use the SFTP library’s move method.The source and destination path is constructed by combining the source directory with the file name.
Creating new plugin implementation for Email capture plugin.
To create new plug-in implementation, navigate to: Customizations>Plug-Ins>Plug-in implementations>New 1.Add the Script File and click on create Plug-in implementation. 2.On the Select Plug-in Type page, click the Email Capture link. 3.On the New Plug-in Implementation page, enter the following information: 4.On the Scripts subtab, in the Implementation dropdown list, select the script file that containsthe… Continue reading Creating new plugin implementation for Email capture plugin.
Tracking NetSuite as OIDC Provider Integrations and Users
The Login Audit Trail is a specialized search that helps keep track of account users, when they have logged in, and from where.You can use the Login Audit Trail to track NetSuite as OIDC Provider integrations and users. To track integrations and users: Go to Setup > Users/Roles > User Management > View Login Audit Trail.… Continue reading Tracking NetSuite as OIDC Provider Integrations and Users
To perform an employee search, regardless of role-based permissions.
To utilize an employee search created in a client script, even with a role that does not have employee and employee record permissions. We can use the backend suitelet script to overcome the permission issue.This approach involves passing search criteria data as parameters to the suitelet script and executing the suitelet in an admin role.… Continue reading To perform an employee search, regardless of role-based permissions.
Troubleshooting NetSuite as OIDC Provider
Authorization Code Grant Flow Errors:For information about errors that may occur during the OAuth 2.0 flow for NetSuite as OIDC provider, see the following topics:1. Authorization Errors in Step One:The following table lists errors that may occur in Step One of the OAuth 2.0 authorization code grant flow. Error requests are sent to the redirect… Continue reading Troubleshooting NetSuite as OIDC Provider
Creating a Letter Template Record
Letter templates are Microsoft Word files that you merge with your NetSuite data to create personalized correspondence. You store letter templates in the Letter Template folder in your file cabinet. Letter templates generate personalized letters that you can print using Word, and then mail to those with whom you do business. Letter templates can contain… Continue reading Creating a Letter Template Record
Adding Email Template in script.
To incorporate an email template designed for the ‘entity’ record type into a script.
Create a saved customer search to show Parent Customers only.
To create a Saved Customer Search and show only ParentCustomers, follow the instructions below: 1. Navigate to Lists > Search > Saved Searches > New2. Select Customer3. On the Criteria Tab, add the following:** Sub of is any of -None-** Stage is Customer4. On the Results Tab:** Remove unnecessary columns* Add the columns you wanted to see 5. Enter a Search Title6. Click Save and Run