CASE WHEN INSTR( TO_CHAR(REPLACE(NS_CONCAT(DISTINCT {custrecord_jj_transaction_number_ahap729.salesteammember.id}), ‘,’, ‘<br>’)), TO_CHAR(MAX({custrecord_jj_sales_person_ahap_729.id})) ) > 0 THEN ‘Y’ ELSE ‘N’ END add this in the formula text Maximum
Author: Hormese Paul
Fixed Assets Management: Saved Search Showing Disposal Write-Off Amount
When managing fixed assets in NetSuite using the Fixed Assets Management (FAM) module, users often rely on saved searches to track various aspects of asset activity — including disposals. However, a current system limitation affects the visibility of specific financial data in these reports. As of now, there is no built-in method to display the write-off… Continue reading Fixed Assets Management: Saved Search Showing Disposal Write-Off Amount
Getting the List of Customer Statuses
In NetSuite, each customer record is assigned a status—such as Qualified, Close Won, or Renewal—based on their position in your sales pipeline. These statuses are stored internally using numerical IDs, which can be unclear when building reports or SuiteQL queries. To help with this, you can use the SuiteQL query below to generate a list of customer statuses. It allows you to easily… Continue reading Getting the List of Customer Statuses
Allow multi select in bank reconciliation
In the console, we can type the below. document.querySelectorAll(‘.uif1506.uif1510.uif1513.uif1515.uif1438’).forEach(el=>el.click()) It will multi-select 111 records at a time
“Submit Failed. NetSuite could not submit all…” in Match Bank
For finance teams, maintaining accurate and timely bank reconciliations is critical for reliable financial reporting, fraud prevention, and cash flow management. Many businesses rely on NetSuite’s Match Bank Data feature to streamline this process. However, users often overlook a key step—submitting the matched or cleared transactions—which can prevent completion of the reconciliation. Understanding the correct submission workflow and… Continue reading “Submit Failed. NetSuite could not submit all…” in Match Bank
Best Practices for HTML Templates in Marketing Campaigns & Email Templates
OverviewCreating HTML templates for NetSuite Marketing Campaigns and Email Templates requires careful design for compatibility across email clients. This quick guide offers essential tips for NetSuite admins to craft effective email content that renders well and communicates clearly. Key Terms:HTML Template: Code for designing email layouts for marketing campaigns.Marketing Campaigns: NetSuite feature for promotional email… Continue reading Best Practices for HTML Templates in Marketing Campaigns & Email Templates
Missing Commerce Categories
When implementing SuiteCommerce Advanced as your web store, you might encounter an issue where your commerce categories are missing from your site, or sometimes none of the categories appear at all. You may try to access the categories directly by adding the URL component to your domain in the address bar, which sometimes works, and… Continue reading Missing Commerce Categories
Automating Notes on Transactions Using SuiteScript
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
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 ) ), ‘,’, ‘,’ )
Print picking ticket page saved search sample reference’s
Ignore Item Availability search below Search : JJ Print Picking Ticket JJ Print Picking Ticket: Results – NetSuite (Magswitch Technology Worldwide Pty Ltd) Open image-20250522-053713.png FYI: When you move to production, all three searches may be revamped as this is correct now based on the SB data only @Shekha E K @Angel Mariya… Continue reading Print picking ticket page saved search sample reference’s