Tag: saved search

Highlight a Specific Cell in Saved Search Results Based on a Criteria

Highlight a specific cell in the Saved Search result for values that reached certain criteria. For example, add a column in Saved Search Results that will show ‘Pending’ in red bold text with the yellow background if the Memo field in the Sales Order is null. Otherwise, the word ‘Done’ should be displayed in black… Continue reading Highlight a Specific Cell in Saved Search Results Based on a Criteria

Enable Item Display Image on Saved Searches

To show display images of Items in search, the ‘Web Store‘ feature needs to be enabled on Netsuite. To enable the Web Store feature, navigate to Setup > Company > Enable Features > Web Presence tab > Web Site section.  This will provide you two fields in searches Store Display Image and Store Display Thumbnail fields which help to display images of items on saved searches. Note: Using the Formula(text) field to pull… Continue reading Enable Item Display Image on Saved Searches

Issue in iterating search results

Scenario: While creating saved searches, after getting its result we may need to iterate the result sometimes after the iteration only one item may show in the console(or any output platform). Solution: The searchResults.run() method need a return true statement to continue the iteration. In Suite script, there is no break statement to break the… Continue reading Issue in iterating search results

Commission Report On Dashboard

Requirement To set up the dashboard to display the commission reports based on the market managers and regional managers. Solution Its not possible to setup a Dashboard using single saved search. So What we have to do is combine multiple saved searches to calculate commissions and setting up dashboard. So we can approach custom records… Continue reading Commission Report On Dashboard

Sales Order, Work Order, and Shipping planning & scheduling

Requirement: Some customers are highly important, and they frequently buy, the system, should remind the sales team to communicate with the customer regularly based on his buying pattern. Assumption: Send the email to the sales rep on the customer record using search. And now we have considered the buying pattern as if customers haven’t generated… Continue reading Sales Order, Work Order, and Shipping planning & scheduling

Error in the search after enabling the auto-numbering for custom record

JIRA- NTI-63 & NTI-64 Scenario: Saved search has been running successfully since it was created, but after a while the client encountered a problem trying to access it and was unable to open it. Issue: This error occurred after enabling the automatic numbering option on the custom record. In the search has formula criteria includes… Continue reading Error in the search after enabling the auto-numbering for custom record

Schedule the email alert sends on the last day of every month

Jira: CDU-611 & CDU-641 We can not be scheduled the email alert set on the last day of every month. NS only provides set a specific day of the month( Because the number of days in each month differs, recurring monthly events cannot be scheduled after the 28th), So we have to add one more… Continue reading Schedule the email alert sends on the last day of every month

Common SQL Expressions For Saved Search

Character Functions Function Syntax Description CONCAT CONCAT(char1, char2) returns char1 concatenated with char2 LOWER LOWER(char) returns char, with all letters lowercase UPPER UPPER returns char, with all letters uppercase LTRIM LTRIM(char [, set ]) removes from the left end of char all of the characters contained inset RTRIM RTRIM(char [, set ]) removes from the… Continue reading Common SQL Expressions For Saved Search

Saved search to get the contacts of the customer from an invoice.

Requirement – The purpose of this saved search is to run a report on all our contacts and bring in their spend in the past 12 months. The search should display the primary contact of the customer if there is no contact added in the invoice. Solution – Create an invoice saved search including the… Continue reading Saved search to get the contacts of the customer from an invoice.