Suitescript saved search code sample to fetch the Transfer Order Item Fulfillments that need to be Received

NetSuite Suitescript code for creating saved search that could only fetch the Item Fulfillments which are not received yet.


search.create({
   type: "transferorder",
   settings:[{"name":"consolidationtype","value":"ACCTTYPE"}],
   filters:
   [
      ["mainline","is","F"], 
      "AND", 
      ["taxline","is","F"], 
      "AND", 
      ["cogs","is","F"], 
      "AND", 
      ["shipping","is","F"], 
      "AND", 
      ["type","anyof","TrnfrOrd"], 
      "AND", 
      ["numbertext","is","TOFNA25000304"], 
      "AND", 
      ["applyingtransaction.type","anyof","ItemShip"], 
      "AND", 
      ["applyingtransaction.applyingtransaction","anyof","@NONE@"]
   ],
   columns:
   [
      search.createColumn({
         name: "internalid",
         join: "applyingTransaction",
         summary: "GROUP",
         label: "Internal ID"
      }),
      search.createColumn({
         name: "type",
         join: "applyingTransaction",
         summary: "MAX",
         label: "Type"
      }),
      search.createColumn({
         name: "tranid",
         join: "applyingTransaction",
         summary: "GROUP",
         label: "Document Number"
      }),
      search.createColumn({
         name: "statusref",
         join: "applyingTransaction",
         summary: "MAX",
         label: "Status"
      }),
      search.createColumn({
         name: "applyingtransaction",
         join: "applyingTransaction",
         summary: "MAX",
         label: "Applying Transaction"
      })
   ]
});

Leave a comment

Your email address will not be published. Required fields are marked *