Skip to Content
0
Former Member
Oct 29, 2010 at 12:11 PM

Approval Procedure - Query not working

18 Views

HI All,

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

SELECT 'True'

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