Hunter Jacobs
03/10/2023, 8:28 PM/**
* @NApiVersion 2.x
* @NScriptType UserEventScript
* @NModuleScope SameAccount
*/
define(['N/record', 'N/search'], function(record, search) {
function beforeSubmit(context) {
if (context.type == context.UserEventType.CREATE) {
var newRecord = context.newRecord;
var lineCount = newRecord.getLineCount({
sublistId: 'item'
});
var catalogs = [];
for (var i = 0; i < lineCount; i++) {
var itemId = newRecord.getSublistValue({ sublistId: 'item', fieldId: 'item', line: i });
var itemCatalog = search.lookupFields({
type: search.Type.ITEM,
id: itemId,
columns: ['custitem_catalog_field']
}).custitem_catalog_field;
if (itemCatalog) {
catalogs.push(itemCatalog);
} else {
catalogs.push('No Catalog');
}
}
var catalogString = 'Catalogs: ' + catalogs.join(' | ');
newRecord.setSublistValue({
sublistId: 'item',
fieldId: 'item',
line: lineCount,
value: "2769"
});
newRecord.setSublistValue({
sublistId: 'item',
fieldId: 'amount',
line: lineCount,
value: 0
});
newRecord.setSublistValue({
sublistId: 'item',
fieldId: 'quantity',
line: lineCount,
value: 1
});
newRecord.setSublistValue({
sublistId: 'item',
fieldId: 'description',
line: lineCount,
value: catalogString
});
}
}
return {
beforeSubmit: beforeSubmit
};
});
ehcanadian
03/10/2023, 8:48 PMitemCatalog
is returning and you'll seereptar
03/10/2023, 8:49 PMreptar
03/10/2023, 8:50 PM