cancel
Showing results for 
Search instead for 
Did you mean: 

expiration date

Former Member
0 Kudos

Hi,

For an item with serial number maintained with expiration date alert should be set 3 months before to the user.

Can u please help me what is the query i have to write in this regard.

Thanks,

Varalakshmi.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Refer this thread

[inventory ageing for Batch management item|;

Modify the Query in the replies in the thread as per your requirement

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Varalakshmi,

It is always a good idea to try the SQL query by yourself first. When you have difficult to complete, then post it here.

Thanks,

Gordon