As an Administrator, streamlining tasks through automation can save time and reduce manual errors. One often overlooked feature is the ability to create and attach Notes to records programmatically. Notes are useful for tracking internal communications, flagging important updates, or adding audit trails to transactions. In this article, we’ll walk through how to use a Scheduled… Continue reading Automating Notes on Transactions Using SuiteScript
Month: July 2025
NetSuite Analytics Warehouse: Empowering Data-Driven Decisions
NetSuite Analytics Warehouse (NSAW) is a powerful cloud-based data analytics solution designed to help NetSuite users gain deeper insights from their business data. Built on Oracle Autonomous Data Warehouse and integrated with Oracle Analytics Cloud, NSAW brings advanced analytics, reporting, and visualization capabilities to NetSuite’s ERP ecosystem. NSAW automatically extracts, transforms, and loads (ETL)… Continue reading NetSuite Analytics Warehouse: Empowering Data-Driven Decisions
View Record dynamic for transactions in saved search
View record generic link Formula (HTML) ‘<a href=”/app/accounting/transactions/transaction.nl?id=’||{internalid}||’” target=”_blank”>View Record</a>’ Multi associated transaction into one column using nsconcat &replace Formula (HTML) REPLACE( ns_concat( DISTINCT( CASE WHEN {applyingtransaction.type} = ‘Wave’THEN ‘WAVE #’ || {applyingtransaction.number} || ‘—><b>’ || {applyingtransaction.status} || ‘</b>’ END ) ), ‘,’, ‘,’ )
Maximum Upload Size for Document Fields in NetSuite
Maximum Upload Size The maximum file size that can be uploaded to a document field in NetSuite is 100 MB. If you attempt to upload a file that exceeds this limit, you will receive an error message stating:
Mass Updating Custom Records with Map/Reduce in SuiteScript 2.1
Introduction In large-scale NetSuite environments, managing thousands of custom records manually isn’t just time-consuming—it’s inefficient. Fortunately, SuiteScript offers a powerful solution: the Map/Reduce script type, built for batch processing with performance and governance in mind. Whether you’re updating custom statuses, recalculating fields, or syncing datasets, this script type is your go-to for scalable, server-side automation.… Continue reading Mass Updating Custom Records with Map/Reduce in SuiteScript 2.1
Configuring SFTP Connection for Auto Bank Statement Import
When using the Auto Bank Statement Import (ABSI) SuiteApp, an SFTP connection is required to connect NetSuite to your financial institution’s server. You can configure your SFTP connection in NetSuite by providing one or both information : Digital Certificate or Private Key Password If your financial institution requires two-factor authentication, be sure to provide both… Continue reading Configuring SFTP Connection for Auto Bank Statement Import
pricing mechanisms in Netsuite and Magento
🛒 In Magento 2: Magento offers several pricing mechanisms that can work individually or together depending on the catalog setup. 1. Tier Price Definition: Discounted prices based on quantity breaks. Example: Buy 1–4: $100 Buy 5–9: $90 Buy 10+: $80 Set for: Specific customer groups or all groups. Where Set: Product Edit → Advanced Pricing… Continue reading pricing mechanisms in Netsuite and Magento
Usage of SweetAlert2 in Elbrus version
SweetAlert2 is a powerful JavaScript library designed to replace native browser alerts with customizable, and responsive pop-up modals in SuiteCommerce Advanced (SCA) websites. It significantly enhances the user experience by supporting features such as icons, animations, and fully configurable buttons—making it ideal for confirmations, notifications, and form-related interactions. Example Implementation The example below demonstrates how… Continue reading Usage of SweetAlert2 in Elbrus version
Saved Search of Timesheets Billed Today
Create a Saved Search of Timesheets that were billed today. Solution Usually, the date of creation of Invoice is also the same date the Time has been billed: Navigate to Reports > Saved Search > All Saved Searches > New Select Customer Click Criteria Time fields…Status: Select Billed Transaction fields…Date Created: Select the date today… Continue reading Saved Search of Timesheets Billed Today
Tax rounding option in Indian accounts
Round-off is part of legal compliance in India Taxation as per Section 170 of the CGST Act and 288B of Income Tax Act, the correct method of rounding off is normal rounding. So, all the amounts of tax, interest, penalty, refund, or any other amount payable should be rounded off to the nearest rupee as… Continue reading Tax rounding option in Indian accounts