on 2022 Dec 17 5:25 AM
I need to trigger an approval for any AP invoice higher than the purchase order or the GRPO > 50. And Item sub category NOT IN ('01-002','01-001'). Thank you!
SELECT DISTINCT 'TRUE'
FROM DUMMY
WHERE
(
($[OPOR."DocTotal".NUMBER] > 50)
AND
((SELECT
IFNULL(T1.COUNT,0)
FROM OITM T0
LEFT JOIN (SELECT
COUNT(T1."ItemCode")AS COUNT,
T1."ItemCode"
FROM OPOR T0
LEFT JOIN POR1 T1 ON T1."DocEntry" = T0."DocEntry"
WHERE T0."CANCELED" = 'N'
GROUP BY T1."ItemCode"
) T1 ON T0."ItemCode" = T1."ItemCode"
WHERE T0."ItemCode" = $[$38.1.0] AND T0."U_SOL_SUBCATEG1" NOT IN ('01-002','01-001')) = 0))
Request clarification before answering.
User | Count |
---|---|
5 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.