Search for the filter some item committed in the pick picking ticket page

var transactionSearchObj = search.create({
   type: "transaction",
   settings:[{"name":"consolidationtype","value":"ACCTTYPE"}],
   filters:
   [
      [["type","anyof","SalesOrd"],"AND",["cogs","is","F"],"AND",["shipping","is","F"],"AND",["formulanumeric: case when ({item.type}NOT IN('Inventory Item','Kit/Package','Assembly') AND {item.isfulfillable} ='T' AND ({quantity} - nvl({quantityshiprecv},0)) >0 ) THEN 1 when {item.type}IN('Inventory Item','Kit/Package','Assembly') AND {quantitypicked}!={quantity} AND {quantitycommitted}>0 then 1 else 0 end","equalto","1"],"AND",["taxline","is","F"],"AND",["status","noneof","SalesOrd:A","SalesOrd:G","SalesOrd:H","SalesOrd:C","SalesOrd:F"],"AND",["mainline","is","F"],"AND",["closed","is","F"]]
   ],
   columns:
   [
      search.createColumn({
         name: "trandate",
         summary: "GROUP",
         label: "Date"
      }),
      search.createColumn({
         name: "tranid",
         summary: "GROUP",
         label: "Document Number"
      }),
      search.createColumn({
         name: "entity",
         summary: "GROUP",
         label: "Name"
      }),
      search.createColumn({
         name: "shipto",
         summary: "GROUP",
         label: "Ship To"
      }),
      search.createColumn({
         name: "shipmethod",
         summary: "GROUP",
         label: "Ship Via"
      }),
      search.createColumn({
         name: "statusref",
         summary: "GROUP",
         label: "Status"
      }),
      search.createColumn({
         name: "item",
         summary: "GROUP",
         label: "Item"
      }),
      search.createColumn({
         name: "lineuniquekey",
         summary: "GROUP",
         label: "Line Unique Key"
      })
   ]
});
var searchResultCount = transactionSearchObj.runPaged().count;

Leave a comment

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