on 02-23-2017 6:19 AM
Hi ,
I need to create approval stage for AR Credit memo documents with doctype = 'I' .How can I do this with user query?I've created the following query and put it as approval terms query ,but it is blocking every AR-Credit Memo documents (Including Service Type).
SELECT distinct 'TRUE' FROM ORIN T0 where T0.DocType = 'I'
Hi,
Try this query,
SELECT distinct 'TRUE' FROM ORIN T0 where $[ORIN.DocType] = 'I'
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Try this
IF $[ORIN.DocType] = 'I'
Select 'True'
Thanks
Engr. Taseeb Saeed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.