-
QuickStart of using Formula fields in NetSuite Saved search with Examples
There are different types of formula fields in Saved search – Formula(date) , formula(date/time) , formula(numeric) , formula (percent),formula(text) Lets start with formula(text). Example 1: Say, we want to fetch the customer in sales order record in saved search. We can do this by two different methods. Method 1 is customary & Method 2 using Formula field. First navigate to list >saved search> New> select ‘Transaction’ Method 1: Select Date from the dropdown under “Results”subtab Method 2: Using formula field: Check Fig 2. Method 1 and Method 2 basically gives the same result. Formula fields opens to wide range of database functions (Check below) and the details of each function can be easily found online. ( Oracle Help center – Use this link to search formula and its syntax) # Functions in Formula text 1) ABS(n), 2) ACOS(n), 3) ADD_MONTHS(date, integer), 4) ASCII(char), 5) ASIN(n), 6)…
-
Some points on design a RESTlet in effective way for Beginners & Intermediate
RESTlet is a script type where it is used for read/create/update records in NetSuite. It takes JSON string as input data and processes the required action in the NetSuite system. How a requirement of RESTlet will be ? The requirement is straight forward from the customer where they require a module that should read/update/create record…
-
How to Debug Scripts in NetSuite
Suitescripts can be debugged using the suitescript debugger. To use the NetSuite debugger login to NetSuite system and navigate to Customization > Scripts > Script Debugger. (or) Sandbox : debugger.sandbox.netsuite.com Production : debugger.netsuite.com Choose “Debug Existing” to debug the deployed script. This will only show those scripts that are in Testing Mode. After choosing the script…