Corey Schwoebel
08/08/2023, 1:54 PMCD
08/08/2023, 1:59 PMCD
08/08/2023, 1:59 PMCorey Schwoebel
08/08/2023, 2:01 PMfunction afterSubmit(context) {
//List of items to update
let mums = [49318, /*54640,*/ 48891, 48892, 48893]
for (let i = 0; i < mums.length; i++) {
let lineNum = context.newRecord.findSublistLineWithValue({
sublistId: 'item',
fieldId: 'item',
value: mums[i]
})
if (lineNum == -1) continue
search.create({
type: "salesorder",
filters:
[
["mainline", "is", "F"],
"AND",
["closed","is","F"],
"AND",
["type", "anyof", "SalesOrd"],
"AND",
["item", "anyof", mums[i]],
"AND",
["shipdate", "within", "8/1/2023", "12/30/2023"]
],
columns:
[
search.createColumn({
name: "quantity",
summary: "SUM",
label: "Quantity"
})
]
}).run().each(result => {
let prebookedQty = result.getValue({ name: 'quantity', summary: 'SUM' })
log.debug({title: 'Adjusting prebooked qty', details: 'New value = ' + prebookedQty})
record.submitFields({
type: record.Type.INVENTORY_ITEM,
id: mums[i],
values: { custitem_current_prebook_qty: prebookedQty},
options: {
enableSourcing: false,
ignoreMandatoryFields : true
}
})
});
}
}
Corey Schwoebel
08/08/2023, 2:06 PMClay Roper
08/08/2023, 2:21 PM