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

image.png

hello - does anyone know if there's a way to edit reports layout in NetSuite? Users are asking for spaces in between segments

They want to see this format when they export which means in NetSuite as well.

Non-financial reports - no. Script, I suppose, will make it work

Any ideas on the script or link that I can use as guide.

<@UFCC2GQ95> Apparently reports are not accessible via script. Saved Searches are but will not put out information as rich as a report.

<https://stackoverflow.com/questions/69156414/how-to-create-a-report-through-suitescript2-0>

Thanks

I am not a scripter :disappointed:. good luck!

you can use ClientScript to export custom Report.

Here we can manipulate the format of export file as well as maintaining the necessary infos

<@U064CEY04EP> any link or info for reference?

<@UFCC2GQ95> no worries, learning here at the same time as well

<@UPB6XUVQS> it's NS customization, so I'm afraid I can't provide relative link

You can get native report excel file using Suitescript, and remove the blank rows using SuiteScript, and download it