Category: NS Customization

We can use decode function for mutilple conditions check like nested if condition. DECODE(   (CASE     WHEN {item.type} = ‘Inventory Item’ AND {quantity} = {quantityshiprecv} THEN 1     ELSE       (CASE         WHEN {item.type} = ‘Inventory Item’ AND {quantity} != {quantityshiprecv} AND {closed} = ‘T’ THEN 1         ELSE 0       END) END  ),   1, 1, 0 )     Using… Continue reading Decode Function in saved search

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.

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.

You need to reset your 2FA settings in NetSuite if you: Lose your phone. Change your phone number. Change your authenticator app. Change your verification code delivery method. When you click the Reset 2FA Settings link, you remove the existing 2FA setup information. To reset your 2FA settings: You can reset your 2FA settings from… Continue reading Reset Your 2FA Settings

Scenario Navigate to Setup > Company > View Billing Information > Billable Components tab, the Administrator can determine the number of Current Provisioned and Current Used licenses for their account. However, the report does not include specific users who are currently using each provisioned license for each license type. This has been submitted as Enhancement 266816. Solution As an alternate solution, a manual… Continue reading Determine Who Use the Full Licensed Users License of an Account

Employees with access to purchase requests can enter requests to purchase items, material or services from vendors. After requests are approved, they turn into purchase orders. To give an employee access to purchase requests, first, someone with permission to access the Enable Features page must enable the Purchase Requests feature. Next, the employee record must… Continue reading Giving an Employee Access to Purchase Requests

The table below outlines all possible types of transactions linked through Applied To and Applying Transaction join fields. This is useful when creating transaction saved searches, so users are guided what correct join field to use based on the transaction type they would like to pull up. The 2nd column (Type) is added in the Criteria tab, while the 1st (Applied to… Continue reading Quick Reference Guide for ‘Applied To’ and ‘Applying Transaction’ Types based on Transaction Type

The problem that was reported was on the inability to access the following sales orders and document number, as the document was not a hyperlink , but just in the format of the link and therefore the following changes were made to solve the problem. , Formula(text) was then converted to the formula(HTML) to form… Continue reading How to convert a saved search formula to a hyperlink

In NetSuite, campaign verticals are a vital organizational feature used to categorize and manage different marketing initiatives. These verticals allow businesses to group related marketing campaigns together, making it easier to analyze and report on the performance of each category. Think of campaign verticals as a way to compartmentalize your marketing efforts based on the… Continue reading Campaign Verticals