NetSuite recently added the ability to set sublist values via workflow, for the Items sublist. Prior to this new feature, the only way to manipulate data at the line level was via SuiteScripting. This resulted in many small scripts being written, meaning that NetSuite users had to find someone with the knowledge to do so.… Continue reading How to use Workflows to Set Item Sublist Fields?
Author: Aranya T R
Client Script for Making the Custom Subtab Entry Mandatory in Customer Payment
Business Requirement When entering a “Customer Payment” record, certain fields within a custom subtab must be completed before submission. This validation ensures that financial allocations are accurate and prevents discrepancies in payment records. If any required data is missing, the system should alert the user and prevent record submission until the values align. Solution /**… Continue reading Client Script for Making the Custom Subtab Entry Mandatory in Customer Payment
Customer Sync from NetSuite to third party system -Scenarios to be included in Create case
Creating a customer in NetSuite can be done in multiple ways, depending on the use case and level of automation required. Here are the most common methods: 1. Manual Entry via NetSuite UI Navigate to Lists > Relationships > Customers > New. Fill in required details such as Name, Email, Subsidiary (if applicable), Address, Contact… Continue reading Customer Sync from NetSuite to third party system -Scenarios to be included in Create case
Setting When Ordered By in SuiteScripts
There are times when we only care about the values on a Record where a certain field is minimal or maximal. For instance, perhaps we want the Totals of Sales Orders by Customer, but we only care about the most recent orders – in other words, where the Date field is maximal. For situations like this, NetSuite… Continue reading Setting When Ordered By in SuiteScripts
Disable the Remove link on Custom Record Sublists
When a custom record is added as a sublist to another custom record or standard record NetSuite will show Remove option once the record is created. Remove link will remove the Parent record link from the child record. This can be resolved in 2 ways: Procedure 1: In Custom record set the Access Type as… Continue reading Disable the Remove link on Custom Record Sublists
User with custom role doesn’t see custom subtab
I have a custom user role, but it doesn’t see the custom ‘Competitor Pricing’ sub tab on the Inventory Item page. When I login with the admin role, I can see this sub tab. Here is some information about the sub tab and the permissions of the role: Subtabs: Record: Inventory Item Role Permission: Solution… Continue reading User with custom role doesn’t see custom subtab
Purchase Order status with Partial amount Billed
I created a Purchase Order with only Expenses not Item. Selected the account and amount and saved it. Now I billed the Purchase Order with partial amount. For e.g. Purchase order is created with amount of 1000 and billed only 400. But the status for the Purchase Order shows as Fully Billed not Pending. Solution:… Continue reading Purchase Order status with Partial amount Billed
Unable to Select Warehouse Location After Selecting WMS
Scenario User has no option to choose or select a Warehouse Location after selecting WMS on SCM Mobile Application. The Location defaults to Location A. Solution 1. View the employee record 2. Edit the record 3. Remove Location A on the Location field on the main line 4. Click Save
Effects of Disabling WMS MAKE WH SITE on Location Record
As per field level help, user can enable the WMS MAKE WH SITE preference on the Location record to make it a Warehouse Site for WMS Lite. Once the location becomes a warehouse site, user can then use this location for processes allowed by WMS Lite. The processes that can be performed in WMS Lite… Continue reading Effects of Disabling WMS MAKE WH SITE on Location Record
Suitelet for running the SuiteQL queries in NetSuite
Create a Suiteelt script with the following code /** * @NApiVersion 2.1 * @NScriptType Suitelet * @NModuleScope Public */ /* var datatablesEnabled = true, remoteLibraryEnabled = true, rowsReturnedDefault = 25, queryFolderID = null, toolUpgradesEnabled = true, workbooksEnabled = false; var file, https, log, page, query, record, render, runtime, scriptURL, url, version = ‘2021.2’; define( [… Continue reading Suitelet for running the SuiteQL queries in NetSuite