How to pass data/parameter from Suitelet to HTML

For loading the html page the syntax is var HTML_FILE_ID = 464444; // NetSuite File id var fileContent = file.load(HTML_FILE_ID).getContents(); BY this syntax we can load this page , but can’t pass data for passing data write this line code in suitelet fileContent = fileContent.replace(/REPLACE_INTENT_HERE/g, response.body); And in Html Code add line code as: const… Continue reading How to pass data/parameter from Suitelet to HTML

Using REPLACE and SUBSTR for Formula functions

This article gives examples on using some common string functions that can be used for NetSuite search formulas via UI or script, and custom formula fields. REPLACE : Replaces a sequence of characters in a string with another set of characters. Syntax: REPLACE(char, search_string[, replacement_string ]) Examples: REPLACE(‘123123test’, ‘123’); would return ‘test’REPLACE(‘123test123’, ‘123’); would return ‘test’REPLACE(‘222test’, ‘2’,… Continue reading Using REPLACE and SUBSTR for Formula functions

Service Resource Planning (SRP) in NetSuite

The above diagram explains the high level design flow of Project Management in NetSuite. In the Project To Cash Flow Process the user roles includes the Sales Project Manager Consultants & Contractors Finance & Operations The flow starts with the CRM process which initiates with a Create Oppurtunity which comes under the Oppurtunity Management. From… Continue reading Service Resource Planning (SRP) in NetSuite

Multibook Creation

Multi-book accounting provides the ability to maintain multiple sets of accounting records based on a single set of real-time financial transactions. This enables businesses to support different managerial and regulatory compliance needs To enable the Full Multi-Book Accounting features: Go to Setup > Company > Setup Tasks > Enable Features. Click the Accounting subtab and locate the Multi-Book… Continue reading Multibook Creation

Adding A Week field In The Workbook

The client wants to add a week field in the workbook. The week format should be week number/month/year Solution Add a formula field to see the week. Add the below formula to see the week number. ‘W’||to_char({trandate},’IW’)||’/’||to_char({trandate},’MON’)||’/’||to_char({trandate},’YYYY’)

Use SuiteScript in Browser Console

open the browser console.  just right-click somewhere on the page and find the option to inspect the page. Unlike actual SuiteScripts, we can only import modules using require() instead of define(). Using require() will load in any dependencies that are needed. Import a module by assigning it to a variable. For example, to import the Record module, declare a variable called… Continue reading Use SuiteScript in Browser Console