Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Restrict Editing of Item Lines on Sales Orders Created from Estimate
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.'); 0