how to get expense line memo value through search using script

AI generated answer (using internal Slack threads):

To get the expense line memo value through a search using a script, you can use the SuiteScript API's search functionality. Here is a sample code snippet that demonstrates how to do this:

javascript
var mySearch = search.create({
   type: "transaction",
   filters:
   [
      ["type","anyof","VendBill"], 
      "AND", 
      ["mainline","is","F"], 
      "AND", 
      ["cogs","is","F"], 
      "AND", 
      ["shipping","is","F"], 
      "AND", 
      ["taxline","is","F"], 
      "AND", 
      ["memo","contains","Your Memo Text"]
   ],
   columns:
   [
      search.createColumn({name: "tranid", label: "Document Number"}),
      search.createColumn({name: "line", label: "Line ID"}),
      search.createColumn({name: "memo", label: "Memo"})
   ]
});
var searchResult = mySearch.run().getRange(0, 100);

This script creates a search on the transaction record type, specifically targeting Vendor Bills (

"type","anyof","VendBill"

). It filters out main lines, COGS lines, shipping lines, and tax lines, leaving only expense lines. It then filters for lines where the memo contains a specific text (

"memo","contains","Your Memo Text"

). The search returns the document number, line ID, and memo for each matching line. Please replace

"Your Memo Text"

with the actual memo text you are searching for. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******