Email Notifications

Not as configuration.

You could do this using IPA.  You'd have to create the logic for exactly what you are wanting to look for and where to send notification, and then you'd have to schedule it to run based on your needs.

Another alternative is to use SmartNotes, if you own that (Lawson) product.

Thanks Kelly, appreciate if you can share a sample process file done before,

Also is it a good practice to use database mail option (SQL) for notifications ?

Thanks
Sameera

I really don't have a sample process to share with you, as we use SmartNotes for these types of notifications, but you should be able to figure it out. It's just a matter of querying the data you are looking for, and then sending email either on each loop (if you are sending email for each record) or at the end of the flow (if you are wanting a listing), or both.

I've never used database mail option, so I can't comment on that.