Alert based on Batch Expiration Date

[Former Member]

Scenario:

Batch Managed Items

Type: for every transaction

Goods receipt PO > Batch setup window > "Expiration date" ( activate expiration date field from form settings) > set date

Requirement:

An alert to be sent to the purchase dept. user 10 days prior to the defined "expiration date" (in the batch setup window)

vijay

Edited by: SU Vijay on Oct 6, 2008 3:42 PM

[Former Member · Accepted solution]

Have you tried to create any queries for this alert? If you do, please post is here.

Thanks,

Gordon

[Former Member · Accepted solution]

hey I need the query for this alert.

vijay

[Former Member · Accepted solution]

Use this query

SELECT T0.[ItemCode], T0.[ItemName],T0.[BatchNum], T0.[WhsCode], 
T0.[ExpDate],datediff(dd,getdate(),T0.[ExpDate]) as 'Days to Expire' 
FROM OIBT T0  where datediff(dd,getdate(),T0.[ExpDate]) =10