Autorizacion Salida de Almacen

[martin_romano3]

Hola

Necesito crear una autorizacion para que cada que se use el almacen '1999' dispare la autorizacion

no lo logro

intente con varios modelos aca algunos

SELECT

CASE WHEN $[IGE1."WhsCode") = '1999'

THEN 'TRUE' ELSE 'FALSE' END FROM DUMMY;

------------------------------------------

SELECT Distinct 'TRUE'

FROM OPOR T0

INNER JOIN POR1 T1 ON T0."DocEntry" = T1."DocEntry" WHERE T1."WhsCode" ='1999'

AND T0.DocNum=$[OPOR.DocNum]

---------------------------------------------

IF (SELECT $[$13.15.0]) = '1999'
SELECT 'TRUE'

[martin_romano3]

Thank You It WORKS!!!

[SonTran]

Please close the thread by marking correct answer.

[SonTran]

Hi,

Try this query for PO. If it's ok you can adjust for other documents.

SELECT DISTINCT 'TRUE' FROM OPOR T0 INNER JOIN POR1 T1 ON T0."DocEntry"=T1."DocEntry" WHERE $[$38.24.0]='1999'

Hope this helps,

Son Tran