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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
How to create a Saved Search Sends Email Alert When Purchase Order is Approved?
Hi,
I am new to oracle NetSuite 3 month experience
objective : Saved Search Sends Email Alert When Purchase Order is Approved
question : Is there a possibility to run the save search each time the transaction is created?
help : the save search not work why?
I have transaction(purchase order) saved search with the criteria:
Type: is Purchase Order
System Notes : Type is Change
System Notes : Field is Document Status
System Notes : Old Value contains Approved
Main Line is true
With the results :
Date Create
Type
Document Number
Name
Status
Formula(Date) = Case When {systemnotes.newvalue} = 'Pending Receipt' then {systemnotes.date} else NULL end
0