NVL2 is an advanced function that the Oracle database supports. It is used to substitute a value if a NULL value is encountered and to substitute another value if a non-NULL value is encountered. Syntax: NVL2 (value, replace_with_if_not_null, replace_with_if_null) Parameters: value: It is used to specify the value to be tested for a NULL value. replace_with_if_not_null: It… Continue reading NVL2 Function
Author: Jency Nidhin
Combine Two Objects in Javascript
To combine two objects in javascript, we can use the code section given below const posts = { ‘2018-05-11’: { posts: 2 }, ‘2018-05-12’: { posts: 5 }};const notes = { ‘2018-05-11’: { notes: 1 }, ‘2018-05-12’: { notes: 3 }}; function objCombine(obj, variable) {for (let key of Object.keys(obj)) {if (!variable[key]) variable[key] = {}; }}… Continue reading Combine Two Objects in Javascript
Show an alert box while the entity is expired
A function to show an alert box while the status of the entity is the preferred status. Here the status of the Vendor is expired, then show an alert box. The status of the vendor is fetched using lookup field function. function showMessageBasedOnEntityStatus(id) { try { var entityStatus = search.lookupFields({ type: search.Type.VENDOR, id: id, //… Continue reading Show an alert box while the entity is expired
NetSuite Instance Implementation
To implement the Non-Oneworld account first, we need to set all the preferences and set up the following as per the need of the client. Enable features Company Information setup Subsidiary Management General Preferences Accounting Preference Set/User Preferences Rename Record set up Auto Numbering Setup Duplication Detection setup Marketing Preferences Case preferences Forecasting Preferences Email… Continue reading NetSuite Instance Implementation
Restrict direct Contact creation
If we want to restrict the direct contact creation(Netsuite standard record), we use a user event script and write the script in the beforeLoad entry point. And which is deployed/applied to the contact record type. /** @NApiVersion 2.1 @NScriptType UserEventScript/ define([‘N/record’], /** @param{record} record*/ ( record) => { /** Defines the function definition that is… Continue reading Restrict direct Contact creation
Dataset
We are using Dataset while we need to join multiple records in a search. In saved search, we can join only single record fields. So we opt for Dataset for this purpose. To create a dataset go to Analytics -> Dataset -> New Dataset Select the transaction type for the dataset. You can set the… Continue reading Dataset
Memorized Transaction
This post briefs about the memorised transactions and its scope.