Author: Jasmine Jacob

NetSuite makes this easy with a Formula(text) field and  “a” tag with a link to a record. Add the anchor tag as a Results column of type Formula(text). Example: Additional Features: Target=”_blank” If you want to open the record in a new tab you can add target=”_blank” to the end of your URL, like this:… Continue reading Create a link to another record in a Saved Search

If you want to create a folder under a parent folder, you have to include N/Record module. Then create a record of type folder. Set the name to the folder. Set the parent of that folder. const createFolder = (name) => { let folder = record.create({ //creating a folder type: record.Type.FOLDER, isDynamic: true, }); folder.setValue(“name”,… Continue reading Script Sample to create a folder under a specified folder.

Delete Files from File Cabinet using Mass Update. Navigation Lists>Mass update>choose files>delete file. Delete Files from File Cabinet using Mass Update. Enter the Search criteria to get all files to be deleted. Click on Preview to check the files going to be deleted. Click the checkbox under Apply if you don’t want to consider that… Continue reading Delete Files from File Cabinet using Mass Update.

To resolve this remove the scheduled script context from the Execution Context under Context Filtering in the deployment of the user event Script

The reason for that is the salesorder document number in the sourced dropdownlist list contains “#”. When we try topass that as URL it gets trimmed at #. The solution is to pass the internal id or remove the # symbol before passing it as a parameter.

Write the below code in the LineInit of the ClientScript

let new_date = new Date();

const date = new Date(); // get current dateconst month = date.getMonth();const year = date.getFullYear();const startDt = new Date(year, month, 1);const endDt = new Date(year, month + 1, 0);

Create Saved Search of type TransactionUnder the Criteria tab > Standard subtab: Type = is Sales Order Add Formula (Numeric) Field In formula column Enter: (TO_DATE(TO_CHAR({today},’MM/DD/YYYY HH24:MI:SS’),’MM/DD/YYYY HH24:MI:SS’)-TO_DATE(TO_CHAR({datecreated},’MM/DD/YYYY HH24:MI:SS’),’MM/DD/YYYY HH24:MI:SS’))*24 Description : less than or equal to 1Click Save.

We can define multiple print templates for a single saved search using Advanced PDF/HTML Templates for any record type. The main reason to consider this feature is that we can use the power of saved searches to format data. Steps to create a template for printing saved search results. Go to Lists > Search > Saved… Continue reading Advanced PDF templates for Saved searches.