When we want to add months to a date in the ‘after field edit’ trigger it is unable to get the ‘ADD_MONTHS’ function in the formula field. So to add months to the date after the field edit, nlapiDateToString(nlapiAddMonths(nlapiStringToDate(nlapiGetFieldValue(‘custrecord_date’)),{custrecord_month}),’date’) custrecord_date: Id of the date fieldcustrecord_month: Id of the month field eg: add ‘6’ months with… Continue reading Adding Months to date in workflow
Author: Jency Nidhin
Chart of account CSV Import
To import the chart of accounts into the new accounts go to Setup -> Import/Export -> Import CSV records. Set ‘Import Type’ as Accounting. Set Record Type – Chart of accounts. Set Character Encoding – Western (Windows 1252). Set CSV column Delimiter – Comma. Select CSV file(s) as ‘One File To Upload’. Then select the… Continue reading Chart of account CSV Import
Search Criteria – To get the data that were edited or created within 24 hours
Saved search formula to fetch the record data that were created or edited within the last 24 hours. Based on the updates that appeared in the “System notes,” the data for this saved search is fetched. provide these criteria in the ‘Formula text‘ CASE WHEN ({systemnotes.date}>= {today}-1 ) THEN ‘SYS_NOTE’ WHEN ({datecreated}>= {today}-1 ) THEN… Continue reading Search Criteria – To get the data that were edited or created within 24 hours
Is it possible to change the account type?
NetSuite by standard does not permit us to change the account type and currency (accounting currency) once transactions have been posted for the same. Hence, we cannot change the account type and currency for an account that has associated posting and non-posting transactions such as sales orders and revenue commitments. This is the standard NetSuite… Continue reading Is it possible to change the account type?
Remove Duplicate Lines from the Saved Search for the Invoice
If the Invoice contains only one line item in the invoice record, but the saved search for the same invoice record includes 2 more extra lines as below. To avoid these extra lines from the invoice search, add a filter in the saved search:- Set “COGS Line” as ‘false’
Notification for Item fulfillment
When an item is added using a scanner, an alert message needs to display when the quantity added in the item fulfillment record is greater than the maximum. Create a client script to catch the field trigger of ‘Select Item’ field when the item is added using a scanner. The total quantity both before and… Continue reading Notification for Item fulfillment
Schedule a Report
If the report contains a large amount of data, then it is unable to see/load the data. So scheduling the report is a way to view the report. When viewing a report, you can click Schedule in the footer of the report to create a schedule to automatically email the report. There is a 25MB… Continue reading Schedule a Report
Proposal For Notification for Item fulfillment
Requirement When an item is added using a scanner, an alert message needs to display when the quantity added in the item fulfillment record is greater than the maximum. Our Solution Comparison of item quantity in the Item Fulfillment record. Create a client script to catch the field trigger of the ‘Select Item’ field when… Continue reading Proposal For Notification for Item fulfillment
To Modify the Standard NetSuite alert message
If we need to change the standard alert message of NetSuite (i.e., the ‘No match’ alert message shows when an invalid item is added to the item fulfillment record), add the following code content into the client script – ‘pageInit’ entry point. pageInit: function (scriptContext) { try { const WINDOW_ALERT = window.alert; window.alert = function… Continue reading To Modify the Standard NetSuite alert message
Deployment of Scripts and Scripts objects into a new Account
We must import the Suite script’s parent folder, which contains all of the scripts, into WebStorm. The objects for the suite scripts are contained in the ‘Script object’. It helps in the creation of scripted records and deployment records in the desired account. The objects that need to be imported to the WebStorm are Client… Continue reading Deployment of Scripts and Scripts objects into a new Account