var expenseReportSearch = search.create({ type: 'expensereport', filters: [ ['linefile.internalidnumber', 'equalto', fileId] ], columns: [ search.createColumn({ name: 'tranid' }), search.createColumn({ name: 'memo', join: 'expense' }), // Line memo search.createColumn({ name: 'amount', join: 'expense' }) // Expense document number ] }); line memo value is empty

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems like the users are discussing how to create searches in NetSuite using SuiteScript. They are sharing code snippets and providing suggestions on how to achieve their goals. In the first thread, a user is trying to create a search on opportunities and return related attached files. They are unsure about the column ID to use for the file id. Another user suggests creating the saved search in the UI first, then loading it in the script to inspect its columns and filters. In the second thread, a user shares a code snippet for creating a search on the

PAYMENT_INSTRUMENT

type. Another user confirms that this was the solution they were looking for. In the third thread, a user is trying to create a transaction search for sales orders with

Main Line = True

. They are having trouble filtering by the billing address's internal ID or custom field. Another user shares a code snippet that might solve the problem, but the original user is still having issues. They suggest it might be a bug specific to their account. Please note that these are interpretations based on the provided conversations and may not fully capture the context or nuances of the discussions.