Aaron S
07/18/2023, 2:25 PM/**
* @NApiVersion 2.0
* @NScriptType UserEventScript
* @NModuleScope SameAccount
*/
define(['N/record'], function(record) {
function beforeSubmit(context) {
//Check if record's form is the Varsityline - Sales Order Form
var formId = context.newRecord.getValue({ fieldId: 'customform' });
if (formId === '204') {
//Only run if SO is new or being edited
if (context.type === context.UserEventType.CREATE || context.type === context.UserEventType.EDIT) {
//Get SO number
var newRecord = context.newRecord;
//Get Vendor Name from povendor field on 1st line of sales order
var firstVendor = newRecord.getSublistValue({
sublistId: 'item',
fieldId: 'povendor',
line: 0
});
//Get line count
var lineCount = newRecord.getLineCount({
sublistId: 'item'
});
//Set povendor field on line items with the value from line 0 only if the checkbox is 'No'
for (var i = 0; i < lineCount; i++) {
var dontUseVendor = newRecord.getSublistValue({
sublistId: 'item',
fieldId: 'custcol_dont_use_vendor_on_all_lines',
line: i
});
if (dontUseVendor === false) {
newRecord.setSublistValue({
sublistId: 'item',
fieldId: 'povendor',
line: i,
value: firstVendor
});
}
}
}
}
}
return {
beforeSubmit: beforeSubmit
};
});
Kevin Baxter
07/18/2023, 2:29 PMAaron S
07/18/2023, 3:30 PM