on 02-14-2018 6:38 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you share your query to check first?
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.