is it possible to update records using suiteql? (for example, set location for all transaction lines that match a certain WHERE condition). If not, how can I batch update records

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** No, it is not possible to update records using SuiteQL. SuiteQL is a read-only tool and can only be used to retrieve data from NetSuite. It does not support UPDATE or DELETE operations. To batch update records, you would need to use a different method. One common approach is to use a Map/Reduce script. This involves using a search or query to implement the WHERE clause filter, then updating all of the results in a loop, using the record.load/save or record.submitFields. Another method is to use Restlets, SOAP, or REST to update records. These methods allow you to interact with NetSuite data and perform CRUD (Create, Read, Update, Delete) operations. Please note that these methods require a good understanding of NetSuite and its APIs. If you are new to NetSuite, you may need to spend some time learning about these tools and how to use them effectively.

CSV import is also an option

CloudExtend ExtendInsights for Excel can also help here if you can get your data into Excel (you can use a saved search directly in Excel with CloudExtend) and then build logic in Excel to identify just the transaction lines needed and push those to NetSuite (you'll have the line ID in your search results).