Skip to Content
avatar image
Former Member

Approval for 'Item Type' AR Credit Memo

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'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 23, 2017 at 06:26 AM

    Hi,

    Try this query,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 23, 2017 at 06:51 AM

    Hello,

    Try this

    IF $[ORIN.DocType] = 'I'
    
    Select 'True'

    Thanks

    Engr. Taseeb Saeed

    Add comment
    10|10000 characters needed characters exceeded