Month: June 2025

Approved Sales Order Goes Back to “Pending Approval” Status After Edit

User wants to know why approved Sales Order goes back to Pending Approval Status after being edited. Solution This behavior is caused by a preference enabled. When the Require Re-approval on Edit of Sales Order preference is enabled, editing an approved Sales Order will cause the Status to revert back to Pending Approval. This preference… Continue reading Approved Sales Order Goes Back to “Pending Approval” Status After Edit

Filter Values from a Multi-Select Item Field to a Line (column) Field

To source values from a Multi-Select Field to a Custom Line Field: Step 1: Create a Custom List: 1. Navigate to Customization > List, Records, & Fields > Lists > New. The Custom List page is displayed. 2. In the Name field, enter a name for the list. 3. In the Value field, enter a value for the list. 4. Click Add. 5. Repeat steps 3 and 4… Continue reading Filter Values from a Multi-Select Item Field to a Line (column) Field

REST API for Creating Sales Orders

If the user needs to create a sales order using the REST API, then we have to add the mandatory field values in the request body. Below is the endpoint URL and the request body for that: The API type: POST Endpoint URL: https://[Account Id].suitetalk.api.netsuite.com/services/rest/record/v1/salesOrder Request body: {     “externalId”: “TEST007”,     “customForm”:… Continue reading REST API for Creating Sales Orders

Data transfer in DBeaver

Supported formats ExportImportDatabase (table-to-table transfer)CSVCSVXLSX DbUnitXML HTMLTableJSONMarkdownSQLSource codeTXTXMLParquet XLSX  Export data DBeaver allows you to export data from your database to various formats for use in other systems or applications. Info For more details, see Data Export. Depending on the selected format, exporting allows you to: Export query results or entire tables. Adjust data extraction, formatting, and encoding options. Set… Continue reading Data transfer in DBeaver

Enforcing Vendor Selection for A/P Accounts in Journal Entries

Business Scenario When users manually create Journal Entries in NetSuite and select an Accounts Payable (A/P) ledger account, it’s critical to associate the correct Vendor. Failing to do so: Breaks subledger-to-ledger reconciliation, Causes issues with aging reports, And risks compliance with audit standards. To ensure data integrity, a validation was required to block line entries… Continue reading Enforcing Vendor Selection for A/P Accounts in Journal Entries

Differentiating Customer Center Login Type in NetSuite Using a Custom “eml_nkey” Overview

In NetSuite, managing and differentiating various types of users—such as customers, contacts, and employees—can be critical when granting access through the Customer Center. To support this, we’ve implemented a beforeSubmit User Event Script that utilizes a custom field (_eml_nkey_, referred to as Email Key) to determine and record the source type of a login—be it… Continue reading Differentiating Customer Center Login Type in NetSuite Using a Custom “eml_nkey” Overview

SuiteCommerce Security Compliance and Patch Management: Mandatory Update for Reference Product Features

What’s the Patch About NetSuite has released a critical patch for SuiteCommerce and SuiteCommerce Advanced (SCA), specifically targeting users of Reference Product Lists and Reference Product Reviews. Failure to implement this patch may lead to site inaccessibility or unresponsive behavior after the update deadline. Why It’s Urgent With the 2025.1 release, NetSuite is enforcing stricter… Continue reading SuiteCommerce Security Compliance and Patch Management: Mandatory Update for Reference Product Features

Testing NetSuite SuiteAnalytics Workbooks

SuiteAnalytics Workbooks offer powerful, real-time reporting and analytics capabilities within NetSuite. As a tester, your focus is on validating data accuracy, filtering logic, and visualisations generated by custom workbooks. This involves testing saved searches, pivot tables, charts, and data sets that feed these workbooks. You must ensure that the workbook outputs match expected business metrics… Continue reading Testing NetSuite SuiteAnalytics Workbooks

Corner Radius vs. Border-Radius

Corner Radius (Design Term): “Corner radius” refers to the rounded curvature at the junction of two surfaces or edges. In traditional design disciplines such as industrial or graphic design, it’s a physical or visual descriptor used to soften corners. Border-Radius (CSS Property): In web development, border-radius is the CSS property used to apply this visual… Continue reading Corner Radius vs. Border-Radius