We can add a formula in the workflow action condition that checks the value entered in the displayname field. Here’s the formula you need: (nlapiGetFieldValue(‘displayname’).toUpperCase()).indexOf(‘BBC’.toUpperCase()) >= 0
Category: NS Administration
All articles / code related to Netsuite administration
Missing Homepage Navigation Bar in iPad devices
Issue description Navigation Bar Missing in Home Page for Other Devices Workaround Add Shortcut link to the Dashboard Portlet. We can add the suitelet page link added as center link in the navigation bar, as Shortcut link to the Dashboard as shown below:
CSV import update for the Line Item Updates
The Import Assistant lets you update items data for the following types of transactions: Cash Sale, Estimate, Invoice, Opportunity, Purchase Order, Sales Order, Vendor Bill, Vendor Credit, and Vendor Return Authorization. You can modify data for existing line items and add line items to existing transactions. The Items sublist for transactions uses either Line/Order Line… Continue reading CSV import update for the Line Item Updates
AR Aging Report in Saved Search
Based on the formula above, the NVL({daysoverdue}, Round({today}-{trandate}, 0)): NVL() ensures that if {daysoverdue} is null, it defaults to the calculated difference between {today} and {trandate}. Round({today}-{trandate}, 0): Calculates the number of days since the transaction date. This means the formula originally used the Days Overdue, which is based on the Due Date. Instead, we… Continue reading AR Aging Report in Saved Search
How to access SuiteIdeas in NetSuite
When you want a feature or functionality added to NetSuite, visit SuiteIdeas to submit a new enhancement request or vote for an existing idea. SuiteIdeas is only available to users with the NetSuite Support Center role or the NetSuite Support Center (Basic) role. Steps to Add Permission Needed to Access SuiteIdeas: Navigate to Lists >… Continue reading How to access SuiteIdeas in NetSuite
Trial Balance Saved search
I tried several criteria already but still the result does not match. Upon further checking, this is still a system limitation and it is already filed under related Enhancements: #281398 Lists > Search > saved Searches > Transaction > Results tab > Add Quantity or Amount column > Please provide an ‘Alternate Date/Period Range’ on saved… Continue reading Trial Balance Saved search
Display a BarCode on a Saved Search
I had seen an article in LinkedIn. I do not remember the source but then I have copied that for personal use. You can try this out, It works for me. What you will need: Downloadable font uploaded to NetSuite file cabinet. Formula (HTML) in saved search column. Steps to use Google Fonts Navigate to… Continue reading Display a BarCode on a Saved Search
Email Notification on Transaction Deletion
Unfortunately at the moment we cannot send email confirmation for a transaction record being deleted. There might be a way by creating an UserEvent Script as an alternative. Please let me know if you are confident with running scripts in NetSuite so that I can I can ask my colleagues from SuiteCloud team to assist you. An… Continue reading Email Notification on Transaction Deletion
Render image from a hyperlink field to inline HTML field
‘<img src=”‘ || {custitem24} || ‘” width=”600″ height=”300″>’
Resolve Error:“Clear Failed. One Or More Account Transact…” in Match Bank Data
Clearing NetSuite account transactions is a valuable feature provided by Match Bank Data, enabling users to manage transactions that lack corresponding imported bank data. Users have the option to mark these account transactions as cleared, bypassing the matching process. Similar to matched transactions, user-cleared transactions are directed to the Review tab for verification before proceeding… Continue reading Resolve Error:“Clear Failed. One Or More Account Transact…” in Match Bank Data