To retrieve transaction details, including item and quantity information from the transaction line, we can use query on the transaction line table. By default, this query will include both standalone items and components of Kit Items. To exclude Kit Item components and return only the items listed on the sales order, include the following condition… Continue reading Excluding Kit Components in Sales Order Item Queries
Month: June 2025
Proposal for Automated Discount Application in Transactions
Proposal Summary This proposal outlines a custom script-based solution to automate the application of both flat-rate and percentage-based manual discounts at the item line level within NetSuite. The solution introduces a custom column field to capture discount amounts, and systematically generates corresponding discount lines to maintain transparency and traceability. The estimated time for completion… Continue reading Proposal for Automated Discount Application in Transactions
SUITE LET SCRIPT TO UPDATE A CUSTOM COL LINE FIELD IN SALES ORDER RECORD
This script is used to get the req del date column in the item line and then using the suitelet fields the sales order lines can be updated fo the mentioned roles define([ ‘N/ui/serverWidget’, ‘N/record’, ‘N/runtime’, ‘N/format’ ], /** * *… Continue reading SUITE LET SCRIPT TO UPDATE A CUSTOM COL LINE FIELD IN SALES ORDER RECORD
Debugger Not Triggering for Workflow Action Script Called from a Suitelet.
Applies To Product: NetSuite 2022.2 Scenario The debugger is stuck at ‘waiting for user action’ when debugging a workflow action script that was called adhoc by another script. Solution As of 2020.2, it is currently not possible to debug workflow action script if it is triggered through nlapiInitiateWorkflow() as workflow action scripts that are triggered by another script will… Continue reading Debugger Not Triggering for Workflow Action Script Called from a Suitelet.
Mapping HSN code of items in PO for overseas vendor
Scenario: During Purchase Order import, the vendor’s registration type is ‘overseas’ therefore GST is not applicable for the vendor. But the item has hsn code with GST rule applied which results in automatic tax calculation. Solution: Since GST tax calculation is not required for the vendor, map ‘Tax details override’ as ‘Yes’. Now, tax calculation… Continue reading Mapping HSN code of items in PO for overseas vendor
10 Best Practices to Automate Business Processes
Business process automation (BPA) refers to the use of technology to streamline and automate repetitive manual tasks within an organization. The goals of BPA include improving operational efficiency, reducing errors, standardizing processes and freeing up staff to focus on more strategic value-added activities. BPA can be applied to a wide range of business processes across almost… Continue reading 10 Best Practices to Automate Business Processes
Reasons Why Some Items Cannot Be Added in Creating a Transaction in NetSuite
Permissions and Roles: If a user does not have the necessary permissions to add certain items, they will be restricted from doing so. Ensuring that the user has the correct role and permissions can resolve this issue. Item Configuration: Inactive Items: Items that are marked as inactive in the system cannot be added to transactions.… Continue reading Reasons Why Some Items Cannot Be Added in Creating a Transaction in NetSuite
Upcoming Updates On Jira
A new sidebar allows users to access important information quickly, with options to reorder and pin items based on relevance. Goals are now generally available, enabling teams to align on priorities and track project success across various views. A new drag-and-drop interface within Plans helps coordinate work across multiple teams, enhancing collaboration. Simplified top navigation… Continue reading Upcoming Updates On Jira
Testowl
Testowl is a new testing tool launched in early access in June 2025 on the JetBrains Marketplace. Designed for Java-based projects, it provides real-time test execution as code changes, similar to NCrunch or Wallaby.js, offering instant feedback for developers and testers. Key Features: Real-Time Testing: Automatically runs tests during code changes, showing results instantly. Java… Continue reading Testowl
Failover Testing
Types of Failover Testing Network Failover Simulates a network outage to ensure the backup infrastructure operates correctly. Load Balancing Failover Distributes network traffic from the original server across multiple servers to enhance performance and reliability. Automatic Failover Software scripts automate the switching of applications to the backup infrastructure upon detecting an outage. Manual Failover A… Continue reading Failover Testing