cancel
Showing results for 
Search instead for 
Did you mean: 

How to set up user query in sap B1 ?

0 Kudos

A company sells food products. The management of articles is done by batch. The system has been configured so that the batch used is specified at each movement of the products. At the entry of the products, when the batches are created, the expiration and manufacturing dates are entered into the system. The warehouse manager wants to be informed of the number of days remaining before the articles expire. We decided to create a user alert that must run daily.

1. Here is the query used

2. Create report

3. Schedule execution

4. Alert Management

When I reconnect to the system, the alert doesn't automatically appear. Why ?

Do you have any idea ?

Accepted Solutions (1)

Accepted Solutions (1)

former_member312729
Active Contributor
0 Kudos

Hi Jeni,

Under general settings--services--> Activate send alerts option

Need to activate Job service in SLD

Regards:

Balaji.S

Answers (3)

Answers (3)

Former Member
0 Kudos

Question how do I confirm that the report is actually being sent out properly. Also if it is not working properly how would I set it up correctly.

Former Member
0 Kudos

Thank you for the help!

0 Kudos

Thank you very much!!!!!!!!!!!!!!!

The problem is solved