Search error occurred: Unknown identifier 'undefined'. Available identifiers are: {so=transaction AS SO}

AI generated answer (using internal Slack threads):

The error message "Search error occurred: Unknown identifier 'undefined'. Available identifiers are: {so=transaction AS SO}" typically occurs when you are trying to reference an identifier that is not defined in your search or query. In the context of NetSuite, identifiers are used to reference specific fields or records in a search or query. If the identifier you are using is not defined in the context of your search or query, you will receive this error message. Based on the conversations provided, it seems like the error could be due to a mismatch between the identifiers used in the search or query and the actual identifiers available in the database. For example, in the first conversation, the user encountered a similar error when trying to reference the identifier 'cfd228.EVALUE', which was not defined in their search. The error message provided a list of available identifiers that could be used instead. In the second conversation, the user was having issues with their saved search because they were using the wrong identifier to reference the transaction number. Another user suggested using the formula text {tranid} instead, which is the correct identifier for the transaction number in NetSuite. In the third conversation, the user was trying to get the sales order ID from its number using a RESTlet script. They were using the identifier 'tranid' to reference the sales order number, but were getting an id of -1. Other users suggested using SuiteQL for a faster and simpler solution, and provided code samples to demonstrate how to use the correct identifiers in a SuiteQL query. In conclusion, to resolve the error "Search error occurred: Unknown identifier 'undefined'. Available identifiers are: {so=transaction AS SO}", you should ensure that you are using the correct identifiers in your search or query. If you are unsure of the correct identifiers to use, you can refer to the list of available identifiers provided in the error message, or consult the NetSuite Records Browser or SuiteScript API documentation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******