Skip to Content
0
Jul 18, 2019 at 07:48 AM

Message Alerts not appearing in SAP B1 9.3

954 Views

Dear Experts,

I have some questions on alert management.

We are running SAP Business One 9.3 (9.30.150) PL: 05 (32-bit) and we have number of Query Alerts.

If you run the queries they produce the expected data. However, If you attached the query to an Alert the alert does not appear..

This is query which we created:

SELECT T0.DOCNUM AS 'SO No',T0.DOCDATE AS 'SO Date', T0.CARDCODE AS 'Customer Code',T0.CARDNAME AS 'Customer Name' FROM ORDR T0 WHERE CONVERT(VARCHAR,T0.CREATEDATE,103) = CONVERT(VARCHAR,GETDATE(), 103)

We've checked the following already:

  1. The SQL Queries do return results
  2. The Alerts have a SQL Query attached
  3. The Alerts are Active (they have been unticked and reticked)
  4. The user who created the alert and query is a superuser
  5. The user is signed into SAP
  6. The Alerts do not return a NULL value in the first column
  7. The Alerts are not based on a query which includes comments such as "/*...--...*/"
  8. The SQL queries do not contain an IF statement
  9. All alerts have names, and those are excluding special characters such as (*)

Does any one have any idea as to why the Alerts are not appearing?

Looking forward to your responses.

Best regards

Ha Vu