mg2017
09/27/2022, 3:51 PMobj_result['binnumber'] = result.getText({
name: 'binnumber',
join: 'inventoryDetail'
});
obj_result['issueinventorynumber'] = result.getText({
name: 'issueinventorynumber',
join: 'inventoryDetail'
});
obj_result['tobinnumber'] = result.getText({
name: 'tobinnumber',
join: 'inventoryDetail'
});
battk
09/27/2022, 4:04 PMmg2017
09/27/2022, 5:25 PMmg2017
09/27/2022, 5:29 PMconst merged_search_1 = search.load({
id: 'customsearch_merge1_so'
})
merged_search_1.run().each(function (result) {
const obj_result = {};
obj_result['internalid'] = result.getValue({
name: 'internalid'
});
obj_result['tranid'] = result.getValue({
name: 'tranid'
});
obj_result['entity'] = result.getValue({
name: 'entity'
});
obj_result['datecreated'] = result.getValue({
name: 'datecreated'
});
obj_result['statusref'] = result.getValue({
name: 'statusref'
});
obj_result['item'] = result.getText({
name: 'item',
join: 'inventoryDetail'
});
obj_result['inventorynumber'] = result.getText({
name: 'inventorynumber',
join: 'inventoryDetail'
});
obj_result['binnumber'] = result.getValue({
name: 'binnumber',
join: 'inventoryDetail'
});
obj_result['issueinventorynumber'] = result.getValue({
name: 'issueinventorynumber',
join: 'inventoryDetail'
});
obj_result['expirationdate'] = result.getValue({
name: 'expirationdate',
join: 'inventoryDetail'
});
obj_result['quantity'] = result.getValue({
name: 'quantity',
join: 'inventoryDetail'
});
results.push(obj_result);
log.debug({title: "Results", details: obj_result});
return true;
});
mg2017
09/27/2022, 5:32 PMbattk
09/27/2022, 5:45 PMbattk
09/27/2022, 5:45 PMmg2017
09/27/2022, 5:54 PMbattk
09/27/2022, 5:58 PMbattk
09/27/2022, 5:58 PMtobinnumber
and issueinventorynumber
are not columns available to the inventory detail joinec
09/28/2022, 4:07 AMNElliott
09/28/2022, 9:33 AMmg2017
09/28/2022, 10:33 AMmg2017
09/28/2022, 11:28 AMec
09/29/2022, 2:36 AMNElliott
09/29/2022, 10:27 AMec
09/29/2022, 2:54 PMec
09/29/2022, 3:02 PMNElliott
11/02/2022, 2:53 PM