Netsuite: How to get a rowcount as a value instead of the saved search result?
Instead of exporting the rows in the saved search. I want to just get a count for the number of rows there are.
Saved search of transactions, returns 1000 rows to Integrator to pass along, I want to just pass a single row, with value 1000 in it.
This is for a validation process with a partner, so I need to be able to get the row count.
You can use the 'Count' summary type on the internal ID field after adding it as a column in the saved search.0
Another approach would be to use the following in your Saved Search's results tab:
This could potentially be more accurate for other record types where the results include line information, for instance, a Sales Order record, which would have the same Internal ID for those lines.
Thanks Dan, Thats exactly what I was looking for.0
Please sign in to leave a comment.