Open the script record where we want to add parameter, click “New Parameter” button in parameter subtab and add the parameter. Using script get the current script and then get the parameter. For example: let myScript = runtime.getCurrentScript(); let businessDaysCount = myScript.getParameter({ name: ‘<field_Id>’ }); The parameter value will be assigned to the variable, and… Continue reading Add Parameters to Script Record and Get Parameter Value in Suitelet Script
Author: Theres Davies
Execute Map/Reduce using Suitelet Script
Create task record in suitelet to pass the required parameters to map/reduce script, var mapReduceTask = task.create({ taskType: task.TaskType.MAP_REDUCE, scriptId: BULK_SCHEDULER_OBJECT.scriptId, deploymentId: BULK_SCHEDULER_OBJECT.deploymentId, params: { “custscript_dynamicdate”: JSON.stringify(dynamicDate) } }); var taskID = mapReduceTask.submit(); After collecting all the information from map/reduce script send the parameters to suitelet script, let requesturl = ExternalURL + ‘&apiType=bulkcreation&fundnumber=’ + fundNum… Continue reading Execute Map/Reduce using Suitelet Script
Multi-Language Translation for Customer Record
Customers can view item names, descriptions, and expense categories on printed transaction forms using the Multi-Language features in the language they have chosen for their record. We can enable the Multi-Language feature at Setup > Company > Setup Tasks > Enable Features. Click the customer record’s Preferences subtab. Choose the customer’s primary language in the… Continue reading Multi-Language Translation for Customer Record
Deferred Cost Journal Entry
A deferred cost journal entry is made to accrue the deferred costs for amortization when you save the revenue arrangement with costs recorded. The source transactions have no effect on the main ledger. The specified delayed expenditure account is debited and the expense account is credited in the deferral journal entry. In the revenue arrangement,… Continue reading Deferred Cost Journal Entry
Ways of Tracking Changes to Records in NetSuite
There are multiple ways to keep track of record modifications and keep updated on the impact of transactions on the General Ledger (GL) in NetSuite. System Notes offer a time-stamped record of all modifications made to setups, customizations, and other kinds of records in NetSuite. The pre- and post-change values, the user role of the… Continue reading Ways of Tracking Changes to Records in NetSuite
Long Text Character Count using Script
NetSuite counts “line break” as two characters. So, to count the characters in a long text field using script, must count “line break” as two characters. Using script, we can count the characters by using length property of a string object which returns the number of characters in the string, along with that calculates the… Continue reading Long Text Character Count using Script
PROPOSAL FOR ITEM RESTRICTIONS ON SALES ORDER BASED ON SHIPPING ADDRESS AND SHIPPING METHOD
Proposal Summary This proposal covers the scope of restricting items on sales order based on the shipping address and shipping method. Requirement The requirement includes restricting certain products from being added to sales orders for customers in certain areas due to shipping restrictions and some items cannot be shipped internationally due to being… Continue reading PROPOSAL FOR ITEM RESTRICTIONS ON SALES ORDER BASED ON SHIPPING ADDRESS AND SHIPPING METHOD
Counting the Total Number of Days using Script from Business Days
To count the business days backward use a while loop to move one day back and check whether it is a weekend or not using day numbers 0 to 6. Each day of a week start from Sunday that is 0 and ends with Saturday that is 6, use getDay() to get the number of… Continue reading Counting the Total Number of Days using Script from Business Days
Item for Subscription Plan
All the components used to make a subscription are included in a subscription plan. These things include usage, commit plus overage, one-time payments, and recurring services. Generate item records for the products and services that sell as part of subscriptions before you can build a subscription plan. To create an item for a subscription plan:… Continue reading Item for Subscription Plan
Bin Putaway Worksheet
To print a bin numbers list for the items in the warehouse or stock room that need to be restocked, use the Bin Putaway Worksheet. Items appear on this list when an item that uses bins has a count greater than the combined on-hand count of its associated bins. The date, the items that need… Continue reading Bin Putaway Worksheet