Hello everyone,
we have deployed a script that checks if a custom field on an opportunity (a checkbox field) is checked (Yes) or not (No). If the field value is "No" then the sales rep is not allowed to create an estimate against that opportunity until a sales manager approves the opportunity by changing the value of the checkbox field on a form that is not accessible to the sales reps.
Now comes the key issue - currently the ONE work-around to this system is to create an opportunity, get it approved and then go back and change the opportunity and issue new estimates.
Is there a way to check whether the line-items of the opportunity have been edited in any way through scripting? That way I could check if any line item has been edited (or if new items have been added) and re-set the value of the check box to "No"
Our main concern is ensuring that the item information has not changed - so we don't need to check the body fields...
Thanks everyone
Walter
p.s. this would be all not necessary if only Netsuite had estimate approval !!!!:mad: