Include Necessary Files: jquery.min.js jquery.alert.js jquery.alert.css You can host these files in your NetSuite account (File Cabinet) or use any CDN to refer. Create a Client Script: This script will be called in the Page Init function to add the necessary files to the HTML DOM of the NetSuite pages. function OnPageInit() { AddJavascript(‘http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.min.js’, ‘head’); setTimeout(function() {… Continue reading Steps to Show an Alert on a Sales Order with JQUERY
Month: February 2025
Database Normalization
Database Normalization In the realm of database management, ensuring data efficiency and integrity is paramount. Database normalization is a systematic approach designed to minimize data redundancy and improve data consistency. It involves organizing a database into multiple related tables while following a set of rules, or normal forms, to streamline data storage and retrieval. Why… Continue reading Database Normalization
How to setup Custom Employee Role with Integration capabilities
Scenario Customer wanted to create a role or edit a role that would only be Employee Specific. The permissions will only focus on Employee records with view capabilities and Web Services Integration. Solution Follow the steps below to resolve the concern of the customer: Navigate to Setup > Users/Roles > Manage Roles Look for the Employee Center Role > Click Customize Setup the Permissions below… Continue reading How to setup Custom Employee Role with Integration capabilities
Case Saved Search that allows you to drill down on grouped Escalated To field
Use Case: Ability to show Count of Cases and whom they are Escalated To and to be able to drill down on the Escalated To field to see detailed results Create a Saved Search by following these steps: 1. Navigate to Lists > Search > Saved Searches > New. 2. Select Case. 3. Provide a… Continue reading Case Saved Search that allows you to drill down on grouped Escalated To field
Return Currently Selected Line Item on Address of a Customer Record via nlapiGetCurrentLineItemIndex
If one needs to get an alert on every click out of the Address book sublist in the customer record, set up the client script below. The API will return the line number selected. Using the API returns a more consistent value than just returning a parameter like linenum. 1. Setup > Customization > Scripts… Continue reading Return Currently Selected Line Item on Address of a Customer Record via nlapiGetCurrentLineItemIndex
Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry
To correct the error message “Invalid subsidiary reference key xxx” when importing Journals: 1. Verify that the subsidiary is an active and existing subsidiary by navigating to Setup > Company > Subsidiaries. The subsidiary should be spelled the way it is spelled in the record. It is also possible to export the list of subsidiaries to get the correct format. If the Subsidiary… Continue reading Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry
An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors
An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors such as <a href=”#top”>Back to top</a>. i.e. The email message includes a “Back to Top of Page” link and clicking it should return the user to the top of the page. This looks… Continue reading An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors
Create a button and validate the fields on button click
To create a button and on button click validate the fields User Event Script function beforeLoad(context) { if (context.type === context.UserEventType.VIEW) { let form = context.form; let customerRecord = context.newRecord; let isProjectCreated =… Continue reading Create a button and validate the fields on button click
Mutation for setting inventory quantity
InventorySet($input: InventorySetQuantitiesInput!) { inventorySetQuantities(input: $input) { inventoryAdjustmentGroup { createdAt reason referenceDocumentUri changes { name delta } } userErrors { field message } } }
To display item table in pdf based on date created using advanced pdf/html template
To display item table in pdf based on date created using advanced pdf/html template. The button is available in invoice record. The date considered should be the created date in the related sales order. <#if record.item?has_content> <#assign cutoffDate = “01/02/2025”?date(“dd/MM/yyyy”)> <#assign createdFromDate = record.createdfrom.trandate> <#if createdFromDate?has_content> <#assign soDate = createdFromDate> <#if soDate < cutoffDate>… Continue reading To display item table in pdf based on date created using advanced pdf/html template