Approval procedure using Query for 2 conditions UDF and Price

[nareshcr77]

Dear Team,

We need to trigger approval for PO based on header Level UDF and Price combination we are using below query and its throwing error

Query:
SELECT Distinct 'TRUE' FROM OPOR where $[OPOR."U_EA_Item"]='Y' and $[OPOR."DocTotal"]<10000

Error:

Could not commit transaction: Error -1 detected during transaction

Please provide solution for this we need to have a approval procedure on 2 conditions at header level.

[SonTran]

Hi,

Try this query

IF ($[OPOR."U_EA_Item"]='Y' and $[OPOR."DocTotal".Number]<10000)
SELECT DISTINCT 'TRUE'

Hope this helps,

Son Tran

[nareshcr77]

Hi its not working as per your query refer attached snap shot

[SonTran]

Please turn-off your notification and try again.