cancel
Showing results for 
Search instead for 
Did you mean: 

APPROVAL QUERY HELP - Differance Doc Total AP Invoice and Purchase Order and/or GRPO is > 50

0 Kudos
519

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))

Accepted Solutions (0)

Answers (0)