Map/Reduce scripts in NetSuite is a scheduled script type that can work on large set of data. It is intended for parallel bulk data operations. They offer more power and benefits over the standard Scheduled scripts.This is a sample code of a map-reduce script for sending emails to all customers with pending invoices that are… Continue reading Map-Reduce script example
Tag: saved search
Automate Spiff Report Email
Automate Spiff Report Email
KPI Customization
JIRA: PCIC-744 Scenario: Client wants to see the additional column( $$ changes) on the standard KPI of dashboard. Solution: We are unable to add a $$increase column to the dashboard’s KPI. So We have to create new saved search for the similar to the KPI and should have to set up the custom search portlet… Continue reading KPI Customization
CASE SAVED SEARCH
REQUIREMENT: New Saved Search and custom fields to support the report. Eagle Point Solutions are desiring a new saved search to report on the status of cases. This saved search will pull from related records and require some new fields as well. A visual of what the report would look like is on the following… Continue reading CASE SAVED SEARCH
showing more… in the text area field in the saved search result
Reason for showing more… in the text area field in saved search result
Tips and Tricks in Using Saved Search Formulas
Tips and Tricks in Using Saved Search Formulas
Items and related Saved Searches
Tips on Item related saved searches
Activity Search
We have to create a Automated Email Report daily that send contact activities at 7.00am .The fields that we required in the Search are:- Customer ID Contact: Name and Company Name Activities from under the Communications tab Phone call “Status completed” Event “Status complete” Task should be excluded Message notes from within the “Phone Call or Event” Last Modified Date… Continue reading Activity 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