Skip to Content
0
Former Member
Dec 11, 2008 at 09:50 AM

query support for approval templates

28 Views

hi

i want set approval on the base of query so i write query as follow

SELECT T0.[CardName], T0.[CreditLine] FROM OCRD T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode INNER JOIN OINV T2 ON T0.CardCode = T2.CardCode

WHERE T1.[GroupName] ='INSTATION' AND

T0.[CreditLine] >= 0 AND

T0.[CreditLine] <=50000

GROUP BY T0.[CardName],T0.[CreditLine]

but on this condition approval is not set so if i write query wrong then pls send updated quer

regards,

sandip