cancel
Showing results for 
Search instead for 
Did you mean: 

Approval for 'Item Type' AR Credit Memo

Former Member
0 Kudos

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'

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this query,

SELECT distinct 'TRUE' FROM ORIN T0 where $[ORIN.DocType] = 'I'

Regards,

Nagarajan

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

Try this

IF $[ORIN.DocType] = 'I'

Select 'True'

Thanks

Engr. Taseeb Saeed