APPROVAL PROCEDURE

[Former Member]

Hi Experts,

I need to do one approval procedure for PURCHASE ORDER based on our UDF field. In approval templeate , I have selected WHEN FOLLOWING APPLIES and also I selected one Query which is already I saved in Query manager. My query is

Select Distinct 'TRUE' from OPOR where U_pot=0 . But its going for all entries( for approval). Its not working based on my condition. Am not able to find the solution?

Help me to solve this ...

Regards

Jeevan

[Former Member · Accepted solution]

Hi Jeevan,

You may try:

Select Distinct 'TRUE' from OPOR T0

where U_pot=0 AND T0.DocNum=$[OPOR.DocNum\]

Thanks,

Gordon

[Former Member · Accepted solution]

Hi,

Thanks for your reply. But still am facing the same issue.

Regards

Jeevan,

[Former Member · Accepted solution]

Updated:

Select Distinct 'TRUE' from OPOR T0

where $[OPOR.U_pot.number\]=0 AND T0.DocNum=$[OPOR.DocNum\]

OR

IF $[OPOR.U_pot.number\]=0

SELECT Distinct 'TRUE'