Ignore Item Availability search below
Search : JJ Print Picking Ticket
JJ Print Picking Ticket: Results – NetSuite (Magswitch Technology Worldwide Pty Ltd)
Open image-20250522-053713.png
FYI: When you move to production, all three searches may be revamped as this is correct now based on the SB data only
@Shekha E K @Angel Mariya
Backup
var transactionSearchObj = search.create({
type: “transaction”,
settings:[{“name”:”consolidationtype”,”value”:”ACCTTYPE”}],
filters:
[
[“type”,”anyof”,”SalesOrd”,”TrnfrOrd”],
“AND”,
[“taxline”,”is”,”F”],
“AND”,
[“shipping”,”is”,”F”],
“AND”,
[“cogs”,”is”,”F”],
“AND”,
[“mainline”,”is”,”F”],
“AND”,
[“memorized”,”is”,”F”],
“AND”,
[“status”,”noneof”,”SalesOrd:A”,”SalesOrd:C”,”SalesOrd:F”,”SalesOrd:G”,”SalesOrd:H”,”TrnfrOrd:H”,”TrnfrOrd:A”,”TrnfrOrd:G”,”TrnfrOrd:C”,”TrnfrOrd:F”],
“AND”,
[“formulanumeric: DECODE( {type}, ‘Sales Order’, 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 {quantity} != {quantityshiprecv} THEN 1 ELSE 0 END, ‘Transfer Order’, CASE WHEN {transactionlinetype} = ‘Item’ AND NVL({transferorderquantitypicked}, 0) != ABS({quantity}) AND ABS({quantity}) != NVL({transferorderquantityshipped}, 0) THEN 1 ELSE 0 END, 0 )”,”equalto”,”1″],
“AND”,
[[“applyinglinktype”,”noneof”,”DropShip”],”AND”,[“purchaseorder”,”anyof”,”@NONE@”],”OR”,[“applyinglinktype”,”anyof”,”SpecOrd”,”@NONE@”]],
“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: “internalid”,
summary: “GROUP”,
label: “Internal ID”
}),
search.createColumn({
name: “entity”,
summary: “GROUP”,
label: “Name”
}),
search.createColumn({
name: “shipto”,
summary: “GROUP”,
label: “Ship To”
})
]
});
var searchResultCount = transactionSearchObj.runPaged().count;
log.debug(“transactionSearchObj result count”,searchResultCount);
transactionSearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});
/*
transactionSearchObj.id=”customsearch1747892175900″;
transactionSearchObj.title=”JJ Print Picking Ticket (copy)”;
var newSearchId = transactionSearchObj.save();
*/
————————————————————————————-
search name: JJ Print Picking Ticket test some items commited HP
Open image-20250519-074758.png
Please do the unit test to see if this is correct for each location.
@Angel Mariya @Shekha E K
backup
Open image-20250519-075009.png
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”
})
]
});
var searchResultCount = transactionSearchObj.runPaged().count;
log.debug(“transactionSearchObj result count”,searchResultCount);
transactionSearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});
/*
transactionSearchObj.id=”customsearch1747641016502″;
transactionSearchObj.title=”JJ Print Picking Ticket test some items commited HP (copy)”;
var newSearchId = transactionSearchObj.save();
*/
—————————————————————————————–
I have created the Search for All Items Fully Committed.
Saved search: JJ Print Picking Ticket test all items committed
You can change the location & verify the same.
Let me know if there are any gaps or any SO missing.
you can verify whether this search is correct or not.
Similarly, you can make copy of this search and modify search to get the SO using the other filters.
@Angel Mariya @Shekha E K
BAckup
Open image-20250509-101404.png
Open image-20250509-101424.png
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} then 1 else 0 end”,”equalto”,”1″],”AND”,[“taxline”,”is”,”F”],”AND”,[“location”,”anyof”,”9″],”AND”,[“status”,”noneof”,”SalesOrd:A”,”SalesOrd:G”,”SalesOrd:H”,”SalesOrd:C”,”SalesOrd:F”],”AND”,[“mainline”,”is”,”F”],”AND”,[“closed”,”is”,”F”]],
“AND”,
[“sum(formulanumeric: case when {item.type}IN(‘Inventory Item’,’Kit/Package’,’Assembly’) THEN {quantity}-nvl({quantityshiprecv},0)-nvl({quantitycommitted},0) else 0 end)”,”equalto”,”0″],
“OR”,
[“max(formulanumeric: case when{item.type}IN(‘Inventory Item’,’Kit/Package’,’Assembly’) then 1 ({item.type} NOT IN (‘Inventory Item’,’Kit/Package’,’Assembly’) AND {quantitycommitted} < 0) THEN 1else 0 end)”,”equalto”,”0″]
],
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”
})
]
});
var searchResultCount = transactionSearchObj.runPaged().count;
log.debug(“transactionSearchObj result count”,searchResultCount);
transactionSearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});
/*
transactionSearchObj.id=”customsearch1746785612524″;
transactionSearchObj.title=”JJ Print Picking Ticket test all items commited (copy)”;
var newSearchId = transactionSearchObj.save();
*/