Scenario
User tries to access any transaction records list as per samples below but this error shows: “The result field Formula (Currency) cannot be grouped. Please edit search and omit this field or use a different summary function”.
Examples:
- Navigate to Transactions > Sales> Enter Salesorder > List
- Navigate to Transactions > Sales> Create Invoice > List
Solution
- Navigate to the Transaction Records List where error is encountered, i.e. Transactions > Sales> Create Invoice > List
- On the URL section, remove the characters after “netsuite.com“
- Paste this link after “netsuite.com” in the browser: /app/accounting/transactions/transactionlist.nl?searchtype=Transaction&sortcol=Transaction_NUMBER_raw&sortdir=DESC&csv=HTML&OfficeXML=F&pdf=&style=NORMAL&report=&grid=&searchid=-2100&quicksort=&dle=
- Change the View to Default
Note: This error is encountered when the View of the Transaction Records List is set to a Saved Search that might be invalid.