Search code examples
netsuitesaved-searches

How to add add row number to NetSuite saved searches

I have a Transactions saved search that sums an amount over a number of grouped fields:

Results window looks like this (left out a number of Groups for simplicity) : enter image description here

I would like to add a row_number to the result, such that the search result is ordered by a column that will always give the same ordering.

Is this possible?

I tried this, but the rownum column is not shown in the result :

enter image description here

@ehcanadian, I also tried this : enter image description here and this enter image description here

but then it just doesn't show that column in the preview.

Solution

  • If you use at least one Summary column, Netsuite will not display any column without Summary Type defined, so you need to add that to your Rownum column too. So here is a working example: enter image description here

    And the result is: enter image description here