This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi All, Are we able to generate a Predefined NetSuite Report (e.g. Trail Balance) as a CSV via Script and store in the file cabinet? Anyone tried anything like this?

<@U5W5QEZLJ>, you would use a combination of the search and file modules. Load a search and use it to create your csv as a long string in the script. Then you would create the csv with that string and save it to the file cabinet.

var fileObj = file.create({
    name: 'test.csv',
    fileType: file.Type.CSV,
    contents: 'Hello World\nHello World',
    folder: **folder id as a number**
});

Hi <@U4DG62U2H> while if it was a saved search it could be done but I was after standard netsuite reports which can't be recreated via saved search like the trail balance.