Scenario

[Former Member]

Hi experts,

i have a scenario.. we make stock transfer from delhi to chennai. it takes 3 days for the stock to reach chennai. my customer wants to track the shipping. so i created 3 udf shipping date, received date and shipping received (yes/No).so we enter the shipping date and enter the expected receiving date. so my requirement is after 2 days from expected receiving date the system should check third udf shipping received (yes/no), if it is no it should give an alert 'SHIPMENT NOT REACHED'

is it possible.. pls help...

Regards,

Vignesh

[Former Member]

Hi Vignesh,

This is a typical alert example. You don't need any SP.

Try this user alert y query:

SELECT T0.DocNum, T0.DocDate, T0.U_Ship_Name, T0.U_Revd_date

From OWTR T0

WHERE DateDiff(DD,T0.U_Revd_date,GetDate()) > 2 AND T0.U_Ship_done = 'N'

Thanks,

Gordon

[Former Member]

hii

yes you can do by using SP_transaction_notification and you have to modify the procedure according to your query

thanxx

[Former Member]

hello,

i have not done any query an dcan u pls help me in doin this stored procedure. Udf table names are Ship_Name, Revd_date, Ship_done. can u pls help.

regards,

Vignesh