Alerts are generated with empty results

[former_member657158]

Hello experts,

I have some user defined alerts based on queries and running every 1 | 5 minutes. These alerts also send the result by email. The problem is that the alert is being generated even when the query does not return any results, so the user is constantly receiving the alerts emails unnecessarily.

Is there a way to prevent the alert from being generated when the query has no results?

Thank you,

Federico Michell

[former_member1129310]

Is there any resolution for this issue? We just upgraded to SAP B1 version 10 and are having this same problem with Alerts.

[ANKIT_CHAUHAN]

Hi lacey.simpson,

What is the SAP Business One Version and patch?

Have you checked SAP Note 2972669? Did it help?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[former_member657158]

Hi André,

I'm running 10 FP 2008. The note describes exactly the behavior I am experiencing. Thank you for bringing it to my attention.

[Andre_S]

Hi Federico,

what B1 version are you running?
There is a bug in B1 10 FP 2008, please have a look at #2972669 - Alerts Are Triggered When Queries Have No Results