One trick I use in general when I want to control certain on/off aspects of a saved search results page, is the following: Add a Formula field to your Results, and make it a SQL CASE statement. When the CASE evaluates one way, have it result in 0. If it evaluates another way, have it result in 1. You can nest CASE…

What if every result row was the summary type "group"?

Another complicated option is to write a suitelet that lets the user put an arbitrary date range and other items in, and programmatically builds a search from that and generates a table or report in HTML, CSV, or whatever. I think you can get what you're looking for by using Formulae in your Results, with minimal to no…

Did any of those ideas work for you?

Not even system notes or user notes?

filter by System Notes fields?

Oh - if you want that sort of thing then it looks like a big project to me. You're better off if you can find another way around using non-scripted approach. If you do decide to use a script then to get results like that you will need to do the searches in order using each other's results and use the script to combine the…

Sorry for leaving you waiting there! I don't know NetSuite's standard records terribly well, so I can't offer you any elegantly simple solutions, but I can suggest that if you need to join past more than one "level" of joining, you will probably have to use a script, so that you can run several searches one after the…

I'm not sure - maybe you can set that option for all Currency fields in Setup > Company > General Preferences? I am not sure since I don't have access to that area, but that's one place you could try. Did you want to change this for all currency fields or just specific ones? Sometimes when I need the data to stay a certain…

If it comes to that, you can easily find script snippets for generating CSV on the Web, and just plug in your own variables.

Did you get it working? How about the grouping too?

So then you can make the decimal places very long generally, and then use formulae to limit the decimal places for specific fields? Is that the idea, alagarsamy?

For multiple level joins I usually end up using a scripted solution, to collect the values and use them between searches to input to the next search.

Can you give specific information on the Record Type in which this search is looking for the column?

That would be my first guess - probably a User Event Script with an afterSubmit or beforeSubmit.

What we did was we hosted a Fusioncharts-driven reporting app on a PHP server outside of NetSuite. But if you want to do something like that within your NetSuite hosting, FusionCharts has a JavaScript/HTML5 library too, and write a suitelet to generate HTML/JS code instead of responding with an nlobjForm. HighCharts might…

Yeah you could just use a Text formula on an Inline HTML field and do that. I have done the same thing to generate dynamic links on records - I don't know how well it works in List View though.

Another possibility comes to mind: I think saved searches can be affected by user's permissions level to access/read records that would be returns by the saved search. That's just speculation though - sorry - maybe next time I'll have more experience with Saved Search joins. Worst case scenario, you can fetch a list of ids…

I have a PHP script running as a Scheduled Task on one of our servers - It makes requests to a NetSuite ReSTlet we have deployed on our account. The PHP script has functions to define a Search which it sends in its request. The ReSTlet constructs or loads a search based on the params received and delivers the results set…

:-o Everyone should have this!

How do these security questions make our accounts more secure?

Not sure how to fix that myself, but I have an idea maybe - The footer filters appear to edit the URL with all-caps <field name>=<some value> in order to filter the search. If you provide a hyperlink without those criteria parameters, maybe it will give you the "clean" search on page load? I haven't tried this, but I…

Are you able to access the same field using the SuiteScript API? If so, how does it differ from the ODBC approach?

Be forewarned: Not all record types and not all fields are scriptable!

In script, if you are dealing with a CUSTOM record type, you can actually nlapiSearchRecord or nlapiLookupField on the record type "customrecordtype", and bring in the column/field "scriptid" to find the record type's ID. If it's a built-in record type, it is not as straightforward.

To get the built-in types, you may have to hardcode it or build a list yourself, based on the documentation. To find these in the documentation, open NetSuite Help, search for SuiteScript Records browser, and then click the link to it, and read up! It should contain the scriptid (record type ids, not internal ids) of the…

IIRC, getAllColumns() doesn't return actual columns, just column names. Glad you got it working.

Maybe in the meantime, post the file's binary data to a secure intranet file server using programmed suitelet forms? IDK surely there is some kind of Access Control for File Cabinet...? I haven't been involved much in security issues since I started with NetSuite so I don't know yet.

I don't know about a configuration way to do it yet, but if you programmed your own Suitelet form you could program in the folder ID for the file field. That's the hard way though - hopefully someone on here knows the easy way...

Actually if you post to a non-NetSuite file server you may not have to program a suitelet... But you'll have to find a way to post securely from a form of some kind to use that idea, either way.