searchForItemLines(ifRecID) {
let itemArray = []
let itemNames = ""
let count = 1
var itemfulfillmentSearchObj = search.create({
type: "itemfulfillment",
filters:
[
["type", "anyof", "ItemShip"],
"AND",
["internalid", "anyof", ifRecID],
"AND",
["shipping", "is", "F"],
"AND",
["taxline", "is", "F"],
"AND",
["cogs", "is", "F"]
// "AND",
// ["inventorydetail.inventorynumber","noneof","@NONE@"]
],
columns:
[
search.createColumn({ name: "internalid", label: "Internal ID" }),
search.createColumn({ name: "item", label: "Item" }),
search.createColumn({
name: "salesdescription",
join: "item",
label: "Description"
}),
search.createColumn({
name: "line",
sort: search.Sort.ASC,
label: "Line ID"
}),
search.createColumn({
name: "inventorynumber",
join: "inventoryDetail",
sort: search.Sort.ASC,
label: " Number"
}),
search.createColumn({ name: "location", label: "Body Location" }),
search.createColumn({
name: "binnumber",
join: "inventoryDetail",
label: "Bin Number"
}),
search.createColumn({ name: "quantity", label: "Body Quantity" }),
search.createColumn({
name: "quantity",
join: "inventoryDetail",
label: "Bin Quantity"
}),
search.createColumn({
name: "custitem_jj_sequence_number_hidden",
join: "item",
//sort: search.Sort.DESC,
label: "Sequence Number [H]"
}),
search.createColumn({
name: "memo",
join: "appliedToTransaction",
label: "Memo"
}),
search.createColumn({
name: "type",
join: "item",
label: "Type"
}),
search.createColumn({
name: "line",
join: "appliedToTransaction",
label: "Line ID"
})
]
});
var searchResultCount = itemfulfillmentSearchObj.runPaged().count;
log.debug("itemfulfillmentSearchObj result count", searchResultCount);
if (searchResultCount > 0) {
itemfulfillmentSearchObj.run().each(function (result) {
let temp1 = {}
let temp2 = {}
//log.debug("itemNames",itemNames)
if (itemNames != result.getValue({ name: "line", label: "Line ID" })) {
itemNames = exports.escapeXml(result.getValue({ name: "line", label: "Line ID" }))
temp1.count = count
temp1.itemName = exports.escapeXml(result.getText({ name: "item", label: "Item" }))
temp1.description = exports.escapeXml(result.getValue({ name: "memo", join: "appliedToTransaction", label: "Memo" }))
temp1.location = exports.escapeXml(result.getText({ name: "location", label: "Body Location" }))
temp1.quantity = Math.abs(result.getValue({ name: "quantity", label: "Body Quantity" }))
temp1.invNum = ""
temp1.binNum = ""
temp1.binLoc = ""
temp1.itemType = exports.escapeXml(result.getValue({ name: "type", join: "item", label: "Type" }))
temp1.lineId = exports.escapeXml(result.getValue({ name: "line", join: "appliedToTransaction", label: "Line ID" }))
count++
}
temp2.itemType = exports.escapeXml(result.getValue({ name: "type", join: "item", label: "Type" }))
var binVal = exports.escapeXml(result.getText({ name: "inventorynumber", join: "inventoryDetail", label: " Number" }))
log.debug('Bin valu etype',typeof(binVal))
log.debug('ItemType-binVal', temp2.itemType + '-' + binVal)
// if (binVal != '') {
// temp2.itemName = ""
// temp2.description = ""
// temp2.location = exports.escapeXml(result.getText({ name: "location", label: "Body Location" }))
// temp2.quantity = result.getValue({ name: "quantity", join: "inventoryDetail", label: "Bin Quantity" })
// temp2.invNum = exports.escapeXml(result.getText({ name: "inventorynumber", join: "inventoryDetail", label: " Number" }))
// temp2.binNum = exports.escapeXml(result.getText({ name: "binnumber", join: "inventoryDetail", label: "Bin Number" }))
// }
if(temp2.itemType != "Kit"){
temp2.itemName = ""
temp2.description = ""
temp2.location = exports.escapeXml(result.getText({name: "location", label: "Body Location"}))
temp2.quantity = result.getValue({name: "quantity", join: "inventoryDetail", label: "Bin Quantity"})
temp2.invNum = exports.escapeXml(result.getText({name: "inventorynumber", join: "inventoryDetail", label: " Number"}))
temp2.binNum = exports.escapeXml(result.getText({name: "binnumber", join: "inventoryDetail", label: "Bin Number"}))
temp2.lineId = exports.escapeXml(result.getValue({ name: "line", join: "appliedToTransaction", label: "Line ID" }))
}
itemArray.push(temp1)
itemArray.push(temp2)
return true;
});
}
log.debug('item Array', itemArray)
return itemArray;
}