Is there a way that the built-in email notification functionality can fire a notification when a particular item or items are added to a Sales Order or a Work Order?
We have some special order items (let's just call it Item XYZ for this example) that only certain roles in the company can place POs for. So whenever Item XYZ is added to a Sales Order or as a component to a Work Order, we want to send a notification to that particular user that he needs to create a PO for it.
I have a saved search that lists any SOs or WOs with these items (and where a PO has not yet been made), which works and can be used as a reminder on that user's dashboard. However, he would really like to know right away whenever one of those items is added, rather than always checking the reminder on his dashboard. (And if my understanding is correct, in these cases the "send email alerts when records are created" won't always trigger, because that applies to when the SO/WO first gets created, not when items are added to it. Item XYZ might not be added at the time of SO/WO creation, but at a later date.)
Is this possible? Can we send email reminders whenever Item XYZ is added to a SO or to a WO?. If not, is there another means? We can resort to scripting, if needed, but would prefer to first work with what NetSuite has out of the box.