Auto cancellation of Sales Quotation

[former_member520086]

Hi,

Is there any way to cancel the quotation automatically...

I wrote the query for the cancellation but it get execute manually..when i manually execute that query from query manager it work..

but i want to that query to execute automatically..

Is there any way to solve this problem...Please let me know if there is any way

Regards

Sapna

[former_member520086 · Accepted solution]

Hi Nagarajan,

Here is the query...

update T1 set T1.CANCELED='Y',T1.DocStatus='C'

from OQUT T1 inner join QUT1 T2 on T2.DocEntry=T1.DocEntry

where (DATEDIFF(DD,T1.DocDate,getdate())=3) and (T2.TargetType=-1 or T2.TrgetEntry=NULL)

Regards,

Sapna

[kothandaraman_nagarajan]

Hi,

Not sure whether you know or not, updating of SAP B1 table is against SAP support policy. If any inconsistency due to this update, SAP will not support.

Regards,

Nagarajan

[former_member520086]

Hi,

There is user requirement for this...They wants this automatically...

I also tried to set alert for that but it does't respond..

Regards

Sapna

[kothandaraman_nagarajan]

Hi,

Can you share your query to check first?

Regards,

Nagarajan