When deploying forms from one account with the feature ‘Billing accounts’ to another account without such a feature, you may get an error message that says ” To install suiteCloud project, the account’s BILLINGACCOUNTS(Billing Accounts) feature must be enabled. ” We are unable to deploy the forms properly as a result of this problem. As… Continue reading SDF implementation – Form error
Author: Jency Nidhin
NVL Function
NVL(expr1, expr2) : In SQL, NVL() converts a null value to an actual value. Data types that can be used are date, character, and number. The data type must match with each other i.e. expr1 and expr2 must be of the same data type. Syntax – NVL (expr1, expr2) expr1 is the source value or… Continue reading NVL Function
NVL2 Function
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
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.