Scenario: We have a custom field ‘Asset type Department’, which is a list/record field. it lists departments. There are some inactive departments are there. We need to filter out these inactive departments from the list. This field is sourcing from Employee record. Solution: Open the custom field setup page 2. Go to Sourcing & Filtering… Continue reading Excluding Inactive values from a list in a custom field
Author: Anand T P
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
Auto journal creation & application in Payment
Scenario: Create a journal for applying in the credit section of the payment. Ultimate need is to capture the credit info from the custom record, need to create a journal or custom transaction of journal type then apply the same in the payment record.We have seen a limitation of once payment is saved the credit… Continue reading Auto journal creation & application in Payment
Comparing Two dates
Scenario: We have a start date and a Due date and need to a validation where Due date date should be a date after the Start date. Solution: Usually we can use the JavaScript Date() function. But you can’t compare two dates using that. Better approach to make comparison between dates is to use getTime() function. This… Continue reading Comparing Two dates
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
When you can’t add details in every fields in Suitelet
Suitelet scripts can be executed with any client scripts. Sometimes in such situations, the suitlet page(interface) mayn’t be working perfectly. There will be some conditions where some fields may not be working or sometime you can’t enter values to all (necessary) fields. In such situations, output also won’t be perfect. In the client script, almost… Continue reading When you can’t add details in every fields in Suitelet
Time sheet records and time track records in Netsuite
Timesheet records are kind of records which keeps the time records of each customer. The records are for a week. Ie; it keeps the time record of each week. Whether you use time tracking features within NetSuite or you use some other system for employee time entry and approval, now is the time to take… Continue reading Time sheet records and time track records in Netsuite
Integration of Google maps in Netsuite
In the era of cloud based business and communication services, integration of services, processes and product has become a necessity for a business to improve its efficiency and productivity. The integration of two major cloud based service providers that don’t requires anyone’s introduction NetSuite and Google Apps has potential to completely change entire work efficiency… Continue reading Integration of Google maps in Netsuite