how to send email when a field changes its value

(0) Share

Report

Posted on by Community Member

Hi All,

In Dynamics Nav we have this notification field where emails being send to people when they are registered to approve Purchase orders.

If you see in the picture that when the status is ready it means that notification emails are working perfectly . But sometime emails tend to get broken for no reason and that status field changes the error or in process ..

So is there a way to send emails to myself ( i am a newly graduated IT ) when the status changes into anything other than ready so that i can give attention to it ?

Any help will be appreciated

Thanks in advance already !

2844.Screenshot_5F00_2.png

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

You need create another process report which will loop through job queue entries and check the status. If any errored out send email to yourself.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi suresh

Thank you for your answer. you mean By process report is that reports that are designed with Development environment is it ?

Where i need to create data set, program with C/L and all .

Would you think that there is an easier way or some template to it please?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

You need access to the development environment. Please check the image, I have used a codeunit to check for the Job Queue for Errors and then send an email notification to the person and set the job on Hold. I have setup to run this codeunit in the job queue.

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (0)

Report

Hi,

Or as an alternative to Suresh, you could add a Subscriber-Function on the Field Status of the Job Queue Entry-table.

That subscriber-function would trigger an Email when the Status changes to Error.

docs.microsoft.com/.../subscribing-to-events

Was this reply helpful? Yes No