Tag: saved search

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.

Export Search Result and Sync in SFTP Proposal

Proposal summary Export Saved Search result into 3rd party storage Requirement  There will be different saved searches already created in NetSuite. This should be exported to a third party storage (like SFTP server or Sharepoint) in a predefined Date Format Our Solution There will be a custom record named ‘Saved Search Export’. This custom record… Continue reading Export Search Result and Sync in SFTP Proposal