Hi All, I created a sales order saved search and grouped my results to avoid displaying duplicate lines. The saved search looks great, but grouping your results seems to cause the "View|Edit" link that takes me directly to the transaction record to go away. Now clicking on the document number or any other field in the results takes me to another page with a more drilled down version of the report. Then that drilled down report shows the "View|Edit" link. Is there any way to use the grouping functionality in the results while maintaining the ability to go directly to the transaction record without having to go to the drilled down version first?

Hey Eddi, try setting the criteria Main Line = true

If the above fullfill your needs then that's fine. Make sure to remove the grouping from the results then. you need line level details in your search for any reason and want to keep the grouping functionality. Then create a formula html field. Open any transaction take its url and replace 1.The record type with transaction? 2. The internal id at the end with {internalid} This will take you directly to your transaction. Make sure in each row you are getting only a single transaction.

Don't think so, because by grouping you could end up (at least in theory) grouping two different transactions in a single line result.

@Greg Lopez I actually need to keep Main Line as False, because I am bringing in results from Sales Order related records (e.g. Item Fulfillment & Invoice)

Show the formula

Group - formula html field formula: '<a href="https://your account id.app.netsuite.com/app/accounting/transactions/transaction.nl?id='||{internalid}||'" target="_blank">'||{tranid}||'/a' if your account id is 1111111 for production replace your account id with 1111111 for sb1 replace your account id with 1111111.sb1 and so on.