Skip to Content
avatar image
Former Member

How to set up user query in sap B1 ?

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 ?

step-1.png (17.1 kB)
step-2.png (57.5 kB)
step-3.png (9.4 kB)
step-4.png (18.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 05, 2017 at 10:38 AM

    Hi Jeni,

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

    Need to activate Job service in SLD

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 05, 2017 at 11:54 AM

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

    The problem is solved

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 29, 2017 at 12:39 PM

    Thank you for the help!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 29, 2017 at 12:40 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded