I am trying to add an approval procedure for sales orders with a query attached.
I only want to issue approval if the customer has property 10 ticked within their 'business partner master data' screen
I have created the query below
FROM ORDR T0 JOIN OCRD T1 on T0.[CardCode] = T1.[CardCode]
WHERE T1.[QryGroup10] = 'Y' AND T0.[DocNum] = $[$8.0.0]
But when testing, the doesn't execute as expected, does anyone have any ideas ??
The system is currently at 8.8 PL10
Thanks in advance......