Hello Team,
As part of our process, we need to restrict editing of Item lines on Sales Orders created from Estimates - removing, changing, or adding new Items on Sales Orders. We tried to create this Workflow Action Script, we are not receiving any error but it is not working as expected, we are still able to change the items:
function restrictItemChanges(context) {
var salesOrder = context.newRecord;
var estimateId = salesOrder.getValue('createdfrom');
if (estimateId) {
var estimate = record.load({
type: record.Type.ESTIMATE,
id: estimateId
});
var estimateItems = estimate.getLineCount('item');
var salesOrderItems = salesOrder.getLineCount('item');
if (estimateItems !== salesOrderItems) {
throw new Error('You cannot add or remove items on this Sales Order. Items must match the Estimate.');
}
for (var i = 0; i < estimateItems; i++) {
var estimateItem = estimate.getSublistValue('item', 'item', i);
var salesOrderItem = salesOrder.getSublistValue('item', 'item', i);
if (estimateItem !== salesOrderItem) {
throw new Error('Items on the Sales Order must match the Estimate.');
}
}
}
}
Please advise. Thanks!