Case: When we schedule a script to run every 6 hours, then it will run at 12 am, 6 am, 12 pm, and 6 pm. when the script runs at 6 am, then we need the data from the time 12 am up to 5.59 am. But in case of priority, the scheduler runs at… Continue reading Function to fetch the Start time and End time for saved search based on the availability of the processor.
Author: Jency Nidhin
To check whether the Date created date and Line system note date is the same or not
If you want to check whether the sales order’s date created and the line system notes date are the same or not, we need to create a formula text field in the saved search. formulatext: CASE WHEN (TO_CHAR({datecreated}, ‘DD/MM/YYYY HH24:MI’)=TO_CHAR({linesystemnotes.date}, ‘DD/MM/YYYY HH24:MI’)) THEN ‘Yes’ ELSE ‘No’ END When we use this formula in the saved… Continue reading To check whether the Date created date and Line system note date is the same or not
Adding Months to date in workflow
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
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