This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

need a sanity check - if i want to send an email whenever an expense report is paid in full, i cannot do so via a saved search with the `SEND EMAIL ALERTS WHEN RECORDS ARE CREATED/UPDATED` box checked, because the "update" isn't taking place on the expense report itself - the status is being updated by another process

Could you do it on the paying transaction instead?

that's what i was thinking as a solution too

and further - the "create/update" aspect of this refers to the record's create event or an edit/update trigger to the record itself, correct? not, for example, that the "create" occurs whenever the record first "enters" the search results, regardless of how it gets there

Does it need to be in real-time? Would a scheduled workflow suffice?

<@UHRE7JTGE> I think I am going with a scheduled workflow, yes. Here I'm mostly trying to gain an understanding / confirm how I think something works, not looking for workarounds, really.

gotcha, learning here too - would have thought that a status was updated on the expense report tbh (same as on an invoice / bill etc)