approval procedure

[Former Member]

hi all

i am trying to create a approval procedure so that the purchase person cannot create a PO when the warehouse code is 09. this is the query i used

SELECT 'true' FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry WHERE $por1.WhsCode ='09'

it does not seem to work. i get an error saying could not commit transaction(adoc). is my query wrong?

could anyone help?

thanks!

prem

[Former Member · Accepted solution]

Query for approval procedure may not be easy to check line detail in this case. Try this one:

If $[$38.24.0\] LIKE '09'

SELECT 'True'

It has the limitation that only check the first line.

Thanks,

Gordon