Skip to Content
avatar image
Former Member

PO Approval Query

Dear Experts please help me to correct below Approval query SELECT CASE WHEN $[OPOR.DocTotal]>='10000' and $[OPOR.Series]='396' THEN 'True' END

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 01, 2015 at 11:45 AM

    hi

    try this one

    SELECT DISTINCT 'TRUE' FROM OPOR T0

    WHERE $[OPOR.Series] ='396' AND $[OPOR.DocTotal]>='10000'

    --Ramudu

    Add comment
    10|10000 characters needed characters exceeded