To incorporate an email template designed for the ‘entity’ record type into a script.
Author: Swathi Krishna K S
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
Showing Role Permission Differences
To compare permissions for two or more roles: Go to Setup > Users/Roles > Show Role Differences. In the Base Role dropdown list, select the role that will be the basis for comparison to other roles. In the Compare To dropdown list, select one or more roles to compare to the base role. Do one of the following: To view… Continue reading Showing Role Permission Differences
Override the payment amount when creating payments for the sales order.
To verride the payment amount defaulted by Avalara when creating payments for Sales orders. According to Field Level Help on Payment Amount: Important: Be aware that now this field is always defaulted from the sales order TOTAL field, but this might change in future. Make sure you create a workflow to control this field’s value… Continue reading Override the payment amount when creating payments for the sales order.
Center Tabs: Customizing Center Tabs and Center Links
This article outlines how to edit center tabs and links, detailing editing standard tabs as well as custom tabs. Making edits to the Reports tab from NetSuite’s Classic Center will be used as an example for this article. Navigate to Reports > Reports Overview Click ‘Set Up Custom Tab’ Find the ‘Custom’ tab at the… Continue reading Center Tabs: Customizing Center Tabs and Center Links
Converting Date-Time Format to Date Only: Removing Time from Field Values in Script
To convert a date-time value in the format “8/23/2023 12:00 am” to just the date format “8/23/2023”, you can use the following code: Assuming FieldValue1 is the date in format: “8/23/2023 12:00 am”
Handling of Whitespace Strings in Script Validations to Prevent Unexpected Logs
While checking for null or empty values in the script, there can be issues that this validation isn’t working as expected, and you’re still getting script logs. One possibility for this behavior is that the field value might be a whitespace string rather than a null value or an empty string. Whitespace strings can sometimes… Continue reading Handling of Whitespace Strings in Script Validations to Prevent Unexpected Logs
Creating Transfer Order and the quantity available for the item is not updated.
While creating a transfer order the quantity available in the ‘to location’ in item record is not updated while the quantity available in the from location is updated. For this first need to fulfill the transfer order The quantity available will in the “To Location” will be updated only on receiving the transfer order. The… Continue reading Creating Transfer Order and the quantity available for the item is not updated.
Checking Whether a Value is a URL or Not
To check whether the given value is url or not: The code checks whether the variable imageFieldId contains a valid URL. If it does, it converts the URL to base64 format using the convertUrlToBase64 function and then logs the resulting base64 data and image type.
Convert URL to base64 format.
To convert a URL in to base64 format: